Year end Data from multiple worksheets

  • Thread starter Thread starter SWFisherman
  • Start date Start date
S

SWFisherman

I am trying to display some year end data in graphical format. Right now I
have 1 worksheet for each month, & every worksheet contains daily info,
weekly info, & monthly info.

I have no trouble making a bar chart for each month, but when I try to
select every week from every month, it only lets me get to March or the third
worksheet.

There has to be a way to select more data then what it is limiting me too.

Here is an example of what the data range looks like (this is the most it
will let me input):
='January 2008'!$B$11,'January 2008'!$B$19,'January 2008'!$B$27,'January
2008'!$B$35,'February 2008'!$B$11,'February 2008'!$B$19,'February
2008'!$B$27,'February 2008'!$B$35,'February 2008'!$B$43,'March
2008'!$B$13,'March 2008'!$B$21

Thanks in advance for any help you can give me.
 
SWFisherman,
Try this solution.
Insert a new worksheet, call it "Summary"
In cell A1, put "Months".
In cells A2, put "Jan-08", cell A3, put "Feb-08", and so forth to A13.
In cell B2, type "= then select the appropriate worksheet for Jan-08 and
select the final information for that worksheet. In your example, say
January!$B$35 is the monthly total.
Then cell B2 on Summary sheet will look like, "=January 2008!$B$35"
Then cell B3 on Summary sheet will look like, "=February 2008!$B$43"
And so on and so forth.

hth
Dennis
 
Back
Top