Hi,
Is it possible to create a scatterplot with multiple series (2) from a
dataset with 3 columns:
group X Y
A 1,9 9,6
B 9,9 3,6
A 8,3 8,4
B 7,7 5,8
B 6,9 0,8
C 6,8 7,3
C 8,2 8
D 6,8 4,5
D 3,1 5,3
E 3,3 5,9

The firts column defines the group (each group has a different symbol), the
second and third define the X and Y coordinates. My dataset contains about
400 lines and has 15 groups, which is too much work to copy the XY from each
group to different columns. I'm working in Excel 2003.

many thanks,
Maarten