Hello,
I would like to ask some help regarding dynamic charting.
In the sample file I would like to define a formula to select the Last (-1 row) n date but I cannot figure out.
The blocking points for me:
- the DATE cell contains formula,
- the range selection should start at Last (-1 row) n date.
The details in the attached file.
Thank you in advance the reply!
1. Delete the formulae in the blank cells at the foot of the data.
2. Turn the data into an Excel table (the first column will auto increment when you add a value in the second column).
3. Create 3 more named ranges (you're already familiar with this) : ChtCats, ChtVal and ChtLen and readdress the graph to ChtCats and ChtVal.
4. Sit back & admire...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Glenn,
Thank you for your time!
Unfortunately, not possible to delete the formulae at the foot of data (in column DATE). Do you have other idea?
An odd requirement... Oh well.
Use this in the named range ChtCats:
=OFFSET(Sheet1!$B$2,SUMPRODUCT(--(LEN(Sheet1!$B$2:$B$1000)>0))-1,0,-MIN(ChtLen,SUMPRODUCT(--(LEN(Sheet1!$B$2:$B$1000)>0))-1),1)
if you don't need 1000 rows, amend the ranges to something more suitable.
Thank you very much Glenn, you helped me lot!
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks