Sorry, I thought at first it didn't work correctly, but then I realized I was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line chart, it
simply puts the selected data at the beginning of the chart, regardless of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote in
message ...
My, the sign-on process was annoying! I had to click "allow this" 12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data to
the and want them to appear on the chart, the only way I've found to do
this
is to right click, choose "select data", "add" and then individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time, why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me use
Excel.