View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Several (x, y) coordinated lines on one graph

I am trying to plot for the general (x, y) coordinated dataset.

For example,

Series A
(1, 50) (8, 90) (10, 300) (300, 500)

Series B
(3, 80) (400, 90)

Series C
(30, 80) (200, 120)

and so on.

The data is store on single worksheet

Series Name x coordinate y coordinate
A 1 50
A 8 90
A 10 300
A 300 500
B 3 80
B 400 90
C 30 80
C 200 120


I tried to plot the graph using Line graph, with 3 series each named A,
B, C,
set the values for each series with corresponding y's, and set the x
axis labels as the whole x coordinate range, but it doesn't work as I
wanted.

Any help on plotting a set of lines based on (x, y) coordinates?