| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamically Shifting Ranges
I use charts to display 21-periods of data. Every period new data is
entered, and I have to mannually change the range of values for each series to a new 21-row range. From last period's range of "Sheet!L50:L70" to the new period's range of "Sheet!L51:L71" for example. I'm not clear about how to name and define a range using OFFSET where the reference cell is 21 rows above the last cell in my vector column that has a value (rather than the formula). Can anyone help? -- RSquid |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamically Shifting Ranges
Your issue is similar to this:
http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "RSquid" wrote in message ... I use charts to display 21-periods of data. Every period new data is entered, and I have to mannually change the range of values for each series to a new 21-row range. From last period's range of "Sheet!L50:L70" to the new period's range of "Sheet!L51:L71" for example. I'm not clear about how to name and define a range using OFFSET where the reference cell is 21 rows above the last cell in my vector column that has a value (rather than the formula). Can anyone help? -- RSquid |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically Changing Named Ranges | Excel Worksheet Functions | |||
| Simple code for shifting | Excel Discussion (Misc queries) | |||
| Shifting Hyperlink | Excel Discussion (Misc queries) | |||
| How to specify cell ranges dynamically? | Excel Worksheet Functions | |||
| dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Hybrid Mode
