Trying to Plot two lines on one graph

[Erica]

Help! I have two data sets and want to plot them both on
one graph for comparison. Problem I am facing is the x-
axis data points don't seem to decipher between the two
plots.
For instance, my 2 data sets are:
Line1 Line2
X Y X Y
1 4 1.5 7
2 7 2 6
3 9 3 8
4 2 4.2 0
5 7 5.1 1

But after plotting, Excel can only display the Line 1 x
values. Therefore Line 2 is not represented correctly.
Anyone have any suggestions?

 

[Leo Heuser]

Erica

One way:

Make a XY-scatter chart for the first data set.

Rightclick the chart and choose "Source data" (or similar)
From the tab "Series" (or similar) add a new series.
Drag through data set 2 to get the X- and Y-values.