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

Charts

Posted by Sheila Peck on August 21, 2001 5:56 AM

Is it possible to create a chart from multiple sheets in a workbook?

Here's an X-Y selection that works

Posted by Eric on August 21, 2001 6:15 AM

If you start up the chart wizard with no data selected, choose the X-Y format, click "next", then SKIP the data range and instead click over to the "series" tab, and select "add", you can add the "X" data and "Y" data separately, and from different sheets.
Hope that helps

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.