Dynamically Shifting Ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RSquid - 31 Jul 2008 17:45 GMT

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?

Signature

RSquid

Reply to this Message

Jon Peltier - 31 Jul 2008 18:40 GMT

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
_______

>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
[quoted text clipped - 6 lines]
> a
> value (rather than the formula). Can anyone help?

Reply to this Message