View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
SWFisherman SWFisherman is offline
external usenet poster
 
Posts: 4
Default Year end Data from multiple worksheets

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.