VBA for changing a chart point color based on its label

[Shmurkam]

Hello!

I'm in need for macro that changes colors in chart with external table as reference. Current excel document hold about 10 doughnut graphics and want to have them with the same colors.
I found out the code bellow and it's almost what i need.
The main problem is that macro change only the first year. (inside ring)

doughnut.PNG

Can you help what should be changed for both of them to work properly?

Please Login or Register  to view this content.

Thank you very much!

[rorya]

You'd need to loop through the chart series, instead of just using series 1:

Please Login or Register  to view this content.