How do I chart multiple worksheets ?

[Guest]

How can I chart multiple worksheets that are in the same workbook all on one
graph but seperate lines?

 

[Debra Dalgleish]

Jon Peltier has instructions for charting data from different sheets:

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