chart a different workbook
 

is there a way i can have excel chart info from another wookbook?


--
caldolegare
------------------------------------------------------------------------
caldolegare's Profile: http://www.excelforum.com/member.php...o&userid=26773
View this thread: http://www.excelforum.com/showthread...hreadid=400395

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


caldolegare wrote:

is there a way i can have excel chart info from another wookbook?