building chart from multiple sheets
 

I have 5 sheets and would like to build a stacked bar graph using data from
each. Say I have 4 values in A1, A2, A3 & A4 on each of these sheets. Each
stacked bar is to respresent the 4 values from a single sheet. Is there any
way to do this with out having to build a table on an extra page?
Thanks,
Brad K

building chart from multiple sheets
 

If I understand your data structure, you will need to use a range to
consolidate the data.

http://peltiertech.com/Excel/ChartsH...iffSheets.html

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


"Brad K." wrote in message
...
I have 5 sheets and would like to build a stacked bar graph using data from
each. Say I have 4 values in A1, A2, A3 & A4 on each of these sheets.
Each
stacked bar is to respresent the 4 values from a single sheet. Is there
any
way to do this with out having to build a table on an extra page?
Thanks,
Brad K