chart data from several workbooks

[Todd]

How do I chart data from several workbooks in one chart?
I want to build a chart that shows sales results from
several periods and each period is in its own workbook.

Thanks,

Todd

 

[Tushar Mehta]

Copy the data from each workbook, select the chart, then Edit | Paste
Special... and provide the information XL will ask for.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Todd -

Here is some information about charting data from different sheets:

http://peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html

- Jon