charts ..make it linked up to current month

[DEEARO]

hi all,

i have a chart which shows all the months from October 2021 to September 2022 however is there away it only shows up to current month, so next month it wail add more information.

i dont mind adding an extra table or changing anything.

[Greg M]

Hi there,

Try inserting the following formula in Cell D175 and copying it across as far as Cell O175:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M