Plotting 6-line chart with 6 different sets of X and Y data?Possible?

  • Thread starter Thread starter mongigaloid
  • Start date Start date
M

mongigaloid

Ok, here goes.... Line chart with 6 lines.

I have to plot these 6 lines on 1 chart. The chart has a vertical Y
axis going from 0 to 1.0 in increments of .1
The X axis goes from 0 to 60 in increments of 10. So far, no problem.

I have 6 lines, each with different values for BOTH the X and Y data.
Yet all 6 lines have to be plotted on the 1 chart together.

Tried a scatter chart, but that only gives you 1 X axis (correct?)

Only way I could figure to do this in PPT was to create 6 different
charts, then overlay them all together (as a graphic). This seems
like a bunch of trouble, and incaccurate to boot. I must be missing
sometihing.

Is there an easier way to plot all this in 1 chart?
 
Hi,

Use the xy-scatter chart. Assuming the data sheet is set to plot By Column
then in first column enter all the X values for the 1st series.
In the second column enter all the Y values for the first series. Now when
entering the values for the 2nd series start at the row immediately below
the 1st series.
Again in the 1st column enter the X values. In the 3rd column enter the Y
values for the 2nd series. Repeat process for all 6 series.

Basically the empty Y value cells for each series will cause those points
not to appear.

Cheers
Andy
 
Back
Top