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

[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?

 

[Andy Pope]

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

 

[Echo S]

I did a screengrab recently of what Andy's describing -- but I did it in
rows instead of columns. Either way will work. (Don't forget to use the
Series in Columns option if you place your data in columns!)

Here's a link to the thread:

http://groups.google.com/group/micr...st&q=echo+scatter+powerpoint#a5859dfeb898a3b4

 

[mongigaloid]

Worked great! Many thanks!