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
 

Ask a Question

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.

Ask a Question

Similar Threads

Spell Check issue 2
Plotting Graph with dynamic table 3
Dynamic graph 0
Getting the graph style I want 4
Overlay line graph points on bar graph 1
Need help making graph 3
Automatic Macro to create 200 graphs 1
Dynamic graph issue 2

Top