Change color of chart based on category name

Hello,

I am trying to get the chart color to change automatically based on the series name and their given color format. I have found several sources of instructions on Google but the code doesn't seem to work.

The first result had a code as below:
Excel 2007 and later:

Please Login or Register  to view this content.

Can anyone please give me some suggestions as to how to correct the code (already in the excel) and apply it to my sheet?

Thank you!

Code works if the chart is selected

If you want the code to work without the chart being selected you can change the code slightly.

Please Login or Register  to view this content.