-
Solved: Chart Series only use last 4 rows
I'm trying to create a chart that will only use the last 4 rows of a range. The range is dynamic so I'm wondering how only select the last rows by using a =address(counta( formula in the series identifier or create a Dynamic Range Name that will only select the last 4 rows of a column.
Are either of these possible?
Thanks for any ideas...
JimS
-
if I define a name:
=OFFSET(Sheet4!$B$23,COUNTA(Sheet4!$B$23:$B$34000)-4,0,4)
it will be the last 4 rows of a column starting at B23, assuming:
1. contiguous data
2. the list is at least 4 rows long!
B34000 is a cell below which the list is unlikely to go
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
Just realized I didn't mark this as Solved - sorry.
Thanks p45cal, that helped me out...
JimS
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules