Excel VBA Loop Every Chart and Every Series and Change Y Values

Hello,

I am trying to change the Y values of every chart in my worksheet. I have many, many charts each with 3 series named "Data", "Min" and "Max".
Each chart is named "C3", "C4", etc.
If the series name is "Data" I want it to grab the information from sheet "Summary" from columns L to AO for the row number of the Data double and same can be said for Min and Max.

Here is what I have:

Please Login or Register  to view this content.

I am getting Run-Time error '1004': Application-defined or object-defined error