charts with data from two worksheets
 

I have set up a stock chart with 3 series, high, low and close.

The data is from two worksheets. My existing series1 is =sheet1!$b$10:$x$10.
I would like to include the following data from sheet 2 to the same chart-
=sheet2!$b$10:$x$10. I have tried putting + or : between the two sets of data
above but it will not take it. Do you know what I am doing wrong? I have also
tried copying the row from sheet 2 and pasting to the series in sheet one but
it doesn't seem to work. Thanks for your assistance.
--
Shooter

charts with data from two worksheets
 

Separate the data with a comma, not a + or a colon.
You may find it easier to copy the data, then go to the chart, and Edit/
Paste special, and follow the prompts for adding a new series, or new points
to the existing series.
--
David Biddulph

"Shooter" wrote in message
...
I have set up a stock chart with 3 series, high, low and close.

The data is from two worksheets. My existing series1 is
=sheet1!$b$10:$x$10.
I would like to include the following data from sheet 2 to the same
chart-
=sheet2!$b$10:$x$10. I have tried putting + or : between the two sets of
data
above but it will not take it. Do you know what I am doing wrong? I have
also
tried copying the row from sheet 2 and pasting to the series in sheet one
but
it doesn't seem to work. Thanks for your assistance.
--
Shooter

charts with data from two worksheets
 

You can't combine data from multiple sheets into the X or Y values of a
single series. You could copy the data and paste it as a new series, but not
as new points. Here's more about charting data from different sheets:

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

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


"David Biddulph" wrote in message
...
Separate the data with a comma, not a + or a colon.
You may find it easier to copy the data, then go to the chart, and Edit/
Paste special, and follow the prompts for adding a new series, or new
points to the existing series.
--
David Biddulph

"Shooter" wrote in message
...
I have set up a stock chart with 3 series, high, low and close.

The data is from two worksheets. My existing series1 is
=sheet1!$b$10:$x$10.
I would like to include the following data from sheet 2 to the same
chart-
=sheet2!$b$10:$x$10. I have tried putting + or : between the two sets of
data
above but it will not take it. Do you know what I am doing wrong? I have
also
tried copying the row from sheet 2 and pasting to the series in sheet one
but
it doesn't seem to work. Thanks for your assistance.
--
Shooter