I have used the offset function many times before to name a dynamic range
however this time something funny is happening. I have a sheet with many
different data tables that that I will use for charting. When I am trying to
define a range for one series the using the offset function: =OFFSET('Chart
Data'!$J$5,0,0,COUNTA('Chart Data'!$J:$J),1) it selects a range of cells from
J5 to J33, even though cells J13:J21 are blank. Does anyone know why its
doing this?

I was able to find a correction to this by entering in the offset function
as follows: =OFFSET('Chart Data'!$J$5,0,0,COUNTA('Chart Data'!$J:$J)-21,1)
but I am worried that as more data is inserted into this table I might lose
something.