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
