chart data from same cell on multiple sheets

[drhamann]

how can i chart data from the same cell on multiple sheets? when i enter
sheet1:sheet5!a5 i get a invalid reference error.

 

[Jon Peltier]

The values for a chartseries must all come from a single chart. You need
to create a summary range on a worksheet to hold the values. This page
has a few hints:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

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