Solved: Chart Series only use last 4 rows

[JimS]

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]

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]

Just realized I didn't mark this as Solved - sorry.

Thanks p45cal, that helped me out...

JimS