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?
[TABLE="width: 242"]
<tbody>[TR]
[TD]series[/TD]
[TD]x[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]599885.304[/TD]
[TD]4051177.368[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]599884.681[/TD]
[TD]4051181.09[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]599884.618[/TD]
[TD]4051181.697[/TD]
[/TR]
[TR]
[TD]a2[/TD]
[TD]599870.543[/TD]
[TD]4051175.651[/TD]
[/TR]
[TR]
[TD]a3[/TD]
[TD]599854[/TD]
[TD]4051171.144[/TD]
[/TR]
[TR]
[TD]a3[/TD]
[TD]599854.177[/TD]
[TD]4051174.89[/TD]
[/TR]
[TR]
[TD]a4[/TD]
[TD]599839.572[/TD]
[TD]4051177.898[/TD]
[/TR]
</tbody>[/TABLE]
Thank you!
[TABLE="width: 242"]
<tbody>[TR]
[TD]series[/TD]
[TD]x[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]599885.304[/TD]
[TD]4051177.368[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]599884.681[/TD]
[TD]4051181.09[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]599884.618[/TD]
[TD]4051181.697[/TD]
[/TR]
[TR]
[TD]a2[/TD]
[TD]599870.543[/TD]
[TD]4051175.651[/TD]
[/TR]
[TR]
[TD]a3[/TD]
[TD]599854[/TD]
[TD]4051171.144[/TD]
[/TR]
[TR]
[TD]a3[/TD]
[TD]599854.177[/TD]
[TD]4051174.89[/TD]
[/TR]
[TR]
[TD]a4[/TD]
[TD]599839.572[/TD]
[TD]4051177.898[/TD]
[/TR]
</tbody>[/TABLE]
Thank you!