GB,
-- Two options that you can consider:
(1) Create the chart by first using data from the single sheet in which you
want the chart to reside. You can do this via the Chart Wizard. Then, add
the new series that refer to the other sheets as secondary steps.
(2) Create a summary range on the single sheet in which you want the chart
to reside. The summary range will consist of formulas referring to the data
on the other sheets. After the summary range is complated, create the chart
from the summary range. You can use the Chart Wizard for this too.
