break XY data to series
 

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.

break XY data to series
 

Here's how to break it up:

http://peltiertech.com/Excel/Charts/...nalChart1.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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
oups.com...
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.