Automatically Display New Chart Data Every Week

[ericrichard25]

Hello. I'd like to format the five charts on the 'Eric' sheet so that the x-axis automatically expands each week, and the most recent week's data is displayed. The file is attached.

The x-axis data is pulled from the 'Portfolio Data' sheet, in the row starting with V14.

The y-axis data is pulled from the rows on the 'Portfolio Data' sheet as follows:

NAV: (row starting with) V68
Long: V55
Short: V59
Token Long: V86
Token Short: V90

I've seen some tutorials saying to use dynamic named ranges and use the OFFSET function, but I'm a bit unsure how to proceed. Thanks for the help.