How do I apply series names across multiple charts on one sheet

[JHExcel2022]

Yikes. I have about 300 charts on one sheet, all referencing one table on a different sheet. The legend has used the default: Series1, series2 etc. for the series names. I want ALL charts to use actual names that exist as a row at the top of the data table. I can edit these series names, but I can't do this individually for each chart. How do I apply the same series names to ALL charts?
Chart series names.PNGCahrt 2.PNG