Chart w/Offset function not updating

Good morning,
I have the attached file to track expenses from 2 accounts. I used the offset function to find the last category in the list so it will be dynamic for the end-user. The issue is I have added the category "Volleyball" and from the Mortgage account/tab added an expense. My charts on the Mortgage tab and on the Total tab have not updated for this additional expense category. How do I correct this?

(FYI - this file was created in Excel 2007)

If further explanation is needed, please let me know.

Thank you,
N