MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Charting data from stacked sheets

Posted by Trudy on June 28, 2001 8:22 AM

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.

Posted by Damon Ostrander on June 28, 2001 8:49 AM

Hi Trudy,

Just use the wizard to chart the data on one of the worksheets. Then for each additional sheet, copy the range of data you want to add to the chart, go back to the chart and select it, and paste.