View Single Post
  #2  
Old October 1st, 2003, 07:43 PM
Bernard V Liengme
external usenet poster
 
Posts: n/a
Default Multiple series with different x-values on one scatter plot

Hi,
Let's say you have a chart with the first data series displayed.
Now select the data (the x-values and y-values ) for the new data series and
click the Copy tool
Click the chart to activate it
Use the menu command Edit|PasteSpecial; the dialog box will set you specify
New Series AND X-values in first Column (row).

Bernard
www.stfx.ca/people/bliengme

"NKelly" wrote in message
...
I'm trying to add a new series to a scatter plot in Excel,
but the new series uses a different set of x-values. I
want to plot it along the same axis as the other series,
but Excel plots the first point at (1, #) and the second
point at (2, #), etc., instead of actually reading in the
x-value and putting it at that place on the plot.

How can I change this so that it plots the point at the
correct/actual x,y values?