I have a workbook with multiple sheets. The "raw data" is 30+ columns of data that is collected daily.

This is then applied to a "weekly data" and "monthly data" worksheet.

These 2 worksheets are then used to produce multiple charts.

Is there any way of altering all of the "Data Source" options for a collection of charts at the same time? i.e. if I have 10 charts plotting data for the last 12 months, on 01/11/23 I will want to drop October 22 data of the charts and include October 23. At present I have to "Select Data" for each individual chart and tick/untick the respective boxes to include/exclude the data as necessary.