OFFSET Formula Error

Hello,

I have the attached spreadsheet where I want to use the OFFSET formula to do a dynamic chart that will give the 20 latest updated scores. When I delete both columns (A2 where I have the datees and B2 where I have the scores), I end up having an error message stating : A formula in this worksheet contains one or more invalid references.

I have checked the offset formula from the Name Manager and I don't see the error. Can someone please help?

FYI the scores go from 0 to 1 the highest

Thanks

Hello
You appear to have the error in your VBA code even without deleting columns, but your code is password protected , so I cant look at it.