Start the chart wizard in the workbook where you want the chart. On step
2, where you select the data, use Excel's Window menu to switch to
another workbook, and the sheet tabs to change sheets, then select the
data. Continue with the chart wizard.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
