View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton
 
Posts: n/a
Default Line Graph with 2 lines

Use an XY (Scatter) chart type, which can be formatted to have lines
connecting the markers.

Create the XY (Scatter) chart type for one set of XY pairs.

(One way is to arrange your data with X values in a column on the left and
corresponding Y values in an adjacent column on the right, and select both
the X and Y values before using the Chart Wizard.)

Then use Chart | Source Data | Series to add the second set of XY pairs.

- Mike
www.mikemiddleton.com

"Need help making line graph with 2 lines" <Need help making line graph with
2 wrote in message
...
I am trying to make a line graph with 2 lines, each with its own separate
x-axis and y-axis values. I've tried but cannot seem to do this. Any help
would be great.

50 50 55 45
25 25 32 23
12.5 12.5 17 15
6.25 6.25 9 8
3.125 3.125 6 3
1.5625 1.5625 3 3
0.78125 0.78125 1 2

These are the two lines I'm trying to graph, with the x-axis being on the
left and the y-axis on the right.