Excel Offset Function Dynamic Range Question

Hi everyone,
I have been using the offset formula to capture the data stored in rows (and when they get expanded the charts I am using automatically updates).
The formula I have been using has worked right up to the last row of my spreadsheet and is now missing the last cell in the row. It is almost as if the formula is saying -1 or something...

I have attached photos because I know this is hard to explain. Basically you can see that the formulas in the two photos are EXACTLY the same, yet the range in the first photo includes the cell in Column K, and yet the second photo (with the same formula) only goes to J..

Can anyone help me figure out why this is?
Thanks!