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?