multi sheet graphing

Does anyone know if you can graph acrosss worksheets
i.e. if you have 10 sheets with data in box c10 can you
graph all c10 boxes vrs the tab on the worksheet or other
specified variable.

Hi John,
I tried putting Sheet1:Sheet3!A1 as the source for a simple coloumn chart.
No go - the references is not valid.
Bernard

"john cowpar" wrote in message
...
Does anyone know if you can graph acrosss worksheets
i.e. if you have 10 sheets with data in box c10 can you
graph all c10 boxes vrs the tab on the worksheet or other
specified variable.

You would need to collect the data in a summary sheet, which can be done
with formulas. Here is a little more information about plotting data
from different worksheets/workbooks:

http://www.geocities.com/jonpeltier/...entSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bernard Liengme wrote:
Hi John,
I tried putting Sheet1:Sheet3!A1 as the source for a simple coloumn chart.
No go - the references is not valid.
Bernard

"john cowpar" wrote in message
...

Does anyone know if you can graph acrosss worksheets
i.e. if you have 10 sheets with data in box c10 can you
graph all c10 boxes vrs the tab on the worksheet or other
specified variable.