multi sheet graphing

  • Thread starter Thread starter john cowpar
  • Start date Start date
J

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.
 
Hi John,
I tried putting Sheet1:Sheet3!A1 as the source for a simple coloumn chart.
No go - the references is not valid.
Bernard
 
Back
Top