Charting data from stacked sheets

I am attempting to chart data appearing across stacked sheets within a single file, and
have not been successful. Nor can I find a solution in help or in a book. Is it even
possible? And if so, how do I do it? I tried highlighting the data I want to chart first,
using the Ctrl key, but then the Chart Wizard dims. Or, if I open the Wizard first, then
try to highlight the data -- I get an error. I would appreciate any help on this.

Thank you.