using data from 2 different worksheets

  • Thread starter Thread starter rachael
  • Start date Start date
R

rachael

I would like to combine data from 2 different worksheets
into one line graph. The data in the first worksheet is
weekly data and in the second worksheet is the
continuation of the data in the first worksheet, so I only
want there to be one line on my graph since it is just a
different time frame for the same data. I am running
excel 97. Is this possible?

thanks
 
An alternative is to put the data from both worksheets into a third
summary worksheet. Use Copy-Paste Special-Link so the summary sheet
updates if the original data changes.

If you need the second sheet because you ran out of columns after 256
weeks, consider transposing the data, to plot by columns instead of by rows.

- Jon
 
It is possible to source date from two different sheet..In my case I am
looking at 20 sheet and i don't want to combine all twenty sheets into
one sheets.
 
Back
Top