Conditional Chart Data Range

[default_name]

Hey guys,

I have a workbook that charts data for various dates.
I want the chart (called "Chart 6") to display different ranges of data as the years go on.

When I select my chart and go to Select Data, then the Select Data Source window pops up.
Currently, the chart is displaying data from the following Chart Data Range:

=Visuals!$E$13:$BM$25

I want to implement something like this:

=IF(YEAR(TODAY()=2020,Visuals!$E$13:$BM$25,IF(YEAR(TODAY()=2021,Visuals!$E$13:$BY$25,Visuals!$E$13:$CK$25))))

However, trying to do this results in a "That function isn't valid" error. Apparently it cannot be done in this manner.

Can this be done some other way?

Thanks

 

[default_name]

Adding a little bit of clarification:

Basically, the chart currently displays data from $E$13:$BM$25
Next year (2021) I would like it to automatically update to display data from $E$13:$BY$25
Then $E$13:$CK$25 the following year (2022)

Would something like this require VBA to achieve? Thanks in advance