Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Year end Data from multiple worksheets
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 "SWFisherman" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |