I am trying to create a x,y scatter plot of multiple series, each with their own x,y values. The data is organized as shown below (also see attached workbook), as "series name, x, y". I can create the scatter plot by adding each series to the chart using "select data", but there are hundreds of series and I need a faster way to go through it. Is there a way to input these three columns (or macros) so that excel can sort the data into series and graph it? (Using Excel 2013)
series x y (also see attached workbook)
a1 599885.304 4051177.368
a1 599884.681 4051181.09
a1 599884.618 4051181.697
a2 599870.543 4051175.651
a3 599854 4051171.144
a3 599854.177 4051174.89
a4 599839.572 4051177.898
Thank you very much!
turtlepower54
Bookmarks