Are Charts with Multiple XY Datasets Possible?

[sshervais]

I'd like to be able to build a chart using multiple XY datasets -- say
from two different experiments. If I plot the two columns of dataset
as XY, then Add Data and try to plot the two columns of dataset B,
get an XY plot (A), overlaid by two line plots, one for each column o
dataset B. I tried googling but have not found any usefu
information.

Thanks
Steve Shervais

 

[duane]

when you add the 2nd range did you check the box saying that the firs
column is the x axis values

 

[Jon Peltier]

Steve -

There are several ways to add data to an XY chart. First, it is
important to make sure it really is an XY Scatter chart, and not a Line
chart. Right click on the chart and choose Chart Type, and make sure one
of the XY types is highlighted.

You can copy data from the sheet, then select the chart and paste, but
you'll have more control if you use Paste Special from the Edit menu. A
dialog pops up, and you have the ability to choose how to paste it.
Presumably you want a New Series, and (as Duane pointed out) you can
tell Excel to use the first column and row of the copied data for
category (X) data and series names.

You can also add data by right clicking the chart, choosing Source Data,
and clicking on the Series tab. CLick Add, then select the ranges
containing X and Y data and the series name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[sshervais]

Jon, Duane,
Thanks for the quick responses. It was the "checking the box fo
X-axis labels" part that I was missing. Everything looks good now.

Thanks again.

Regards
Steve Shervai