chart data from several workbooks

  • Thread starter Thread starter Todd
  • Start date Start date
T

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