Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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.

Re: Charting data from stacked sheets

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.

Damon

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.