LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Different lines in a spreadsheet on the same line in graph? Leisha Phifer Charts and Charting in Excel 1 May 9th 06 08:42 PM
I can't get the lines to connect on my line graph solesmate Charts and Charting in Excel 1 November 9th 05 10:47 AM
Trying to plot two lines onto a single graph in excel [email protected] Excel Worksheet Functions 3 October 13th 05 05:01 AM
graph with one column and two lines Polina Excel Discussion (Misc queries) 1 June 23rd 05 06:45 PM
Formatting Graph Grid Lines Christopher Anderson Excel Discussion (Misc queries) 1 December 1st 04 10:39 PM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"