break XY data to series

[uridato]

Hi

I have a problam creating an XY chart in excel 2007

for each point (x,y) is in a certain group and i want to create a
chart that color each point according to it's group.

I tried to put each group in a diffrent series, but I only managed to
do so manually, since I have nearly a hundred groups it's not so
practical.

my data is somthing like:

X Y G
1 1 1
2 1 1
3 2 2
4 1 2
5 19 3

and so on.

 

[Jon Peltier]

Here's how to break it up:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Put your G values into the header cells to the right of the G column, then
use formulas that return the value in the Y column if the value in the G
column matches the header (otherwise return #N/A). Plot the X values against
all of the columns under the G values.

- Jon