Hi,

Jon Peltier has a page on the subject that might help.
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Cheers
Andy

john mcmichael wrote:
I need to build a chart that has data sources on multiple spreadsheets in the
same workbook but can not make it happen. Can anyone provide advice on how
to do this. Sheet 1 contains q1-Q4 data for 2003, sheet 2 contains q1-q4 for
2004 etc.

Thanks for the help.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info