create charts from multiple worksheets

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

I have created 10 worksheets from a master template,
populating each of the 10 sheets with data relevant to
that project. How can I create a chart that pulls data
from 2 cells from each worksheet? fyi: the data are
calendar dates, if that has any significance.

Thanks for the help!
 
create a master graphsheet with links to the slave
worksheets.
The data can be tabulated together with data from the
links to the other worksheets. Create separate graphs
from the relevant ranges.
Calendar dates are not significant since they can be
graphed as numerical values or as labels.
I know this doesn't address the graphs themselves but
your question pertained to data and not the graphing.
 
amy said:
I have created 10 worksheets from a master template,
populating each of the 10 sheets with data relevant to
that project. How can I create a chart that pulls data
from 2 cells from each worksheet? fyi: the data are
calendar dates, if that has any significance.
Click to expand...

jr had a good suggestion - create a summary sheet and chart the data from
that summary sheet. An alternative method is to create a named range
(Insert | Name | Define...) that references your 20 cells. Then chart that
named range.

Dave
dvt at psu dot edu
 
Back
Top