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

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