How to create a an excel chart from other sheets?

  • Thread starter Thread starter Guest
  • Start date Start date
Mario -

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/
_______
 
Back
Top