I have a set of charts over a table, showing views of the data for that year.
For the next year, I clone the data table, change the tab name from Jan.2020 to Jan 2021 (for example), and update the data in the table.
Now I also clone the summary sheet with all the graphs, but I want to change the table references in all of the graphs from "Jan.2020" to "Jan.2021".
I can of course manually go through in all of the graphs, select data, and edit the table references. Ugh.
Can I somehow instead have a cell on the summary sheet, that maps all the plotted data to the desired data sheet?
Then I would only change one cell, to change (re-target) all of the graphs on the sheet.
For the next year, I clone the data table, change the tab name from Jan.2020 to Jan 2021 (for example), and update the data in the table.
Now I also clone the summary sheet with all the graphs, but I want to change the table references in all of the graphs from "Jan.2020" to "Jan.2021".
I can of course manually go through in all of the graphs, select data, and edit the table references. Ugh.
Can I somehow instead have a cell on the summary sheet, that maps all the plotted data to the desired data sheet?
Then I would only change one cell, to change (re-target) all of the graphs on the sheet.