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?

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

Here's an X-Y selection that works

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