Start the chart wizard. On step 2, Source Data, you can click in the Data Range box
on the Data Range tab, or any of the similar boxes on the Series tab. While you're
in one of these boxes, you can switch to another sheet using the tabs on the bottom.
You can also switch to a different open workbook using the Window menu. Whatever
data you select, from whichever sheet, is used in your new chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
