multi sheet graphing

[john cowpar]

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.

 

[Bernard Liengme]

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

 

[Jon Peltier]

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/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html

- Jon