Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data from multiple worksheets | Excel Worksheet Functions | |||
copying data from multiple worksheets | Excel Discussion (Misc queries) | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
Merging data from Multiple Worksheets | Excel Worksheet Functions | |||
same data multiple worksheets | Excel Discussion (Misc queries) |