Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Monthly charts do not retail formula row/column
1) Each month I do a "save as" to copy worksheets to the next month. Even
though the cell references in the formulas are absolute, the range changes for the new month. For instance - I have data in Shift1 in February that goes from A1 to Z100. When I "save as", and clear the Feb Shift1 data to enter the March data, the formula =SUMIF('SHIFT 1'!$L$1:$L$517,"HB",'SHIFT 1'!$T$1:$T$1) may read =SUMIF('SHIFT 1'!$L$1:$L$23,"HB",'SHIFT 1'!$T$1:$T$1). [$L$517 changes to $L$23]. I thought the $ in front of the row/column would make it "really" absolute - no changes, period. Would a named range be the solution? 2) In the same workbook, I have charts. Some of them automatically update to reflect the new month's data. Others (pie charts) relect the old data numbers, even though the source data has the new month's data in it. Why do some charts update, and others do not? TIA, Carole O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RETAIL MARK UP FORMULA | Excel Discussion (Misc queries) | |||
How do I create a formula that will calculate monthly changes fro. | Excel Worksheet Functions | |||
Formula help in a monthly sales report. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
What formula can you use to compound monthly returns? | Excel Worksheet Functions |