Graphing Worksheets

T

TrevB

How do I graph different worksheets from different work books onto one work book
Thanks in advance
 
S

stefano

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
 
T

Tushar Mehta

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
 
Top