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

"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.


Do you actually want a line graph, or is it an XY (scatter) graph you want?
I would have thought it was the latter if you've got X and Y values for each
point. I assume that the first and third columns are the X and Y for the
first series, and the 2nd & 4th columns are X & Y for the second series?

The easy option is to select the four columns & Insert Chart, then adjust
the Source Data to suit. You'll want one series with column A for X data
and C for Y, and the second series would have column B for X data and D for
Y.

If you really do want a line graph, then the same process will do, but you
won't have A axis data values, merely labels.
--
David Biddulph