you put all the data onto one worksheet. select a field and type
then select the field from the other workbook. you can change the other workbook and the field will update automatically
As long as any one series does not require data from multiple
worksheets, the process for handling data from multiple
worksheets/workbooks is the same as for making multiple charts from
data on a single worksheet.
--
Regards,
Tushar Mehta www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
