Doh!!

Here's the link I forgot:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

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


"ShaneDevenshire" wrote in
message ...
Hi Jon,

Don't forget the page: ?

--
Cheers,
Shane Devenshire


"Jon Peltier" wrote:

Both ranges highlighted in this way must be on the same worksheet.

You can use data from different sheets in the same chart, but the X
values
or Y values within a single series cannot be split over multiple
worksheets.
You could construct a summary table linking to the separate sheets. This
page gives more details:

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


"ShaneDevenshire" wrote in
message ...
Hi,

What version of Excel are you using:

In 2003 and earlier in the Chart Wizard in the Data range box on step
2,
highlight one of the ranges, then hold down the Ctrl key and highlight
the
other range.
--
Cheers,
Shane Devenshire


"Skeety" wrote:

Both worksheets are in the same workbook.