Dynamic line chart

Hello all,

I am looking to build a dynamic line chart where the range increases increases with the date as there is a value in each cell. In the attached file, I have written the offset formulas on the "costs" tab in N50 and N51.

I am looking to make the dynamic line chart show the sales for salesperson 1 and salesperson 2 over time progresses, but would like the range to only show dates that are smaller than today's date.

Any help would be much appreciated.

Cheers,
Blake