VBA - Search Chart for Data Series Title and format.

Hey All,

I have a macro that formats my charts however one of the Data Series I would like to format differently. I recorded a Marco and note that VBA names each data series as 1, 2, 3 etc...

How can I get VBA to loop through each Series Title and IF Series Title = "Max" then do format ELSE do Nothing.

I found a solution if anybody else finds this thread

Please Login or Register  to view this content.