turtlepower
New Member
- Joined
- Nov 8, 2013
- Messages
- 2
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, as (series name, x, y). I can create the scatter plot by adding each series to the chart, 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?
<tbody>
</tbody>
Thank you!
series | x | y |
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 |
<tbody>
</tbody>
Thank you!