Using Excel 2010, I am attempting to create an XY scatter platter with multiple series.
The series names are arranged as rows in my source table with corresponding X and Y values on each row. Sample data below.
Working with this example, I'd like five series (00110, 00401, 00405, 00415, 00417) with two or three x,y data points plotted for each.
I've found a way to do this by manually adding each series and assinging separate x and y data ranges for each. Unfortunately, in the real worksheet, I have a couple dozen different series values, so that solution is impractical. Is there another way?
Series X Y
00110 75 2.25
00110 50 1
00401 25 0.25
00401 25 0
00401 50 0.52
00405 25 0
00405 50 0.6
00405 75 0.98
00415 25 0
00415 50 1
00417 25 0.89
00417 50 2.05
00417 75 2.65
00435 25 0.58
00435 50 0.79
00435 75 0.98
The series names are arranged as rows in my source table with corresponding X and Y values on each row. Sample data below.
Working with this example, I'd like five series (00110, 00401, 00405, 00415, 00417) with two or three x,y data points plotted for each.
I've found a way to do this by manually adding each series and assinging separate x and y data ranges for each. Unfortunately, in the real worksheet, I have a couple dozen different series values, so that solution is impractical. Is there another way?
Series X Y
00110 75 2.25
00110 50 1
00401 25 0.25
00401 25 0
00401 50 0.52
00405 25 0
00405 50 0.6
00405 75 0.98
00415 25 0
00415 50 1
00417 25 0.89
00417 50 2.05
00417 75 2.65
00435 25 0.58
00435 50 0.79
00435 75 0.98