Create single chart with data from seperate worksheets

[Guest]

I would like to create a chart using data from several worksheets.
Basically, each worksheet graphs data for a different time period. For
example
SHEET1:
Store : Customers : Sales : Margine
Data : Data : Data : Data

SHEET2:
Store : Customers : Sales : Margine
Data : Data : Data : Data

etc. I would like to be able to create a chart using say, the sales data.
(SHEET1:Salesata, SHEET2:Salesata).
Is there a way to select the datarange from seperate Worksheets?

 

[Jon Peltier]

You can chart data from different sheets or workbooks together, subject to
certain constraints. Generally the easiest way is to combine the data onto a
single sheet (linking it, of course), and plotting this data.

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