chart data from same cell on multiple sheets

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

Say you want an embedded chart on sheets 1, 2, and 3 in the same workbook.
Sheet 1 cell A1 contains the number 5. You want to create a clustered column
chart based on the data in sheet 1 cell A1 (the number 5). For each of the
three charts, the series formula should look like this irregardless of what
sheet the chart resides on.

=SERIES(,,Sheet1!$A$1,1)

----
Regards,
John Mansfield
http://www.pdbook.com

"drhamann" wrote:

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

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/ChartsH...iffSheets.html

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

drhamann wrote:

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