View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph
 
Posts: n/a
Default XY scatter plot with multiple data pairs for each variable

"gpotavin" wrote in message
...
I need to create an xy scatter plot for 24 items (A through X). Each
letter
(A-X) has 3 pairs of xy data.

For example Item A has data pairs x1y1, x2y2 and x3y3

However, when I plot these I get x1y1, y1x2, x2y2, y2x3 and x3y3. In
addition I need each item (A-X to appear in the legend only one time not
multiple times)

Can anyone help me with this??


How have you laid out your data, and how have you created the chart?
If you put your x1 x2 x3 values in one column and your y1 y2 y3 alongside
them in another column, you should get the plot you want.
--
David Biddulph