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:Sales:Data, SHEET2:Sales:Data).
Is there a way to select the datarange from seperate Worksheets?