Excel - set data range for multiple charts

You can try to use Excel named table and apply filters to it. Tt automatically filters a chart input data.

You can add True/False column for easier filtering or use filter directly to WeekNumber column.

enter image description here