excel charts

[john mcmichael]

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]

Hi,

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

Cheers
Andy