VBA code to change pivot chart line on 12 charts

Good morning,
I have a workbook with 12 pivot charts on 2 sheets. I need to change the lines to all the same type, just different colors. Is there a way I can code this? I currently have the below, but I don't think it would be very efficient to code this for each of the 12 charts. Also note, some of the charts will have only 3 Series while others will have up to 8.

Please Login or Register  to view this content.

Thank you for your assistance!
N

Hey, Andy, thanks so much! That was amazingly simple (at least for me to copy and paste)!

Now the recipient of this report has taken his question one step further. Each of the series represents a retailer and as stated previously each retailer may or may not be in the resulting pivot chart. On each chart he would like there to be consistency among each of the retailer colors, that is, to see Retailer A always in yellow, Retailer B always in blue, Retailer C always in green, etc. If Retailer A is not represented on a given chart then another retailer should not be yellow. Does that make sense and is this possible to program?

Thanks again!
N

Thanks, Andy, that site did it for me!

Final code:

Please Login or Register  to view this content.

Thank you so much for your help!!
N