PDA

View Full Version : Solved: Chart Series only use last 4 rows



JimS
02-06-2012, 11:47 AM
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

p45cal
02-06-2012, 01:49 PM
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

JimS
03-02-2012, 11:48 AM
Just realized I didn't mark this as Solved - sorry.

Thanks p45cal, that helped me out...

JimS