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.