Hallo, I'm new here and I have a problem with coloring bars in a stacked column chart

Hallo,

I'm Rob and I'm doing a project for school.
For this project I'm using a Yamazumi chart (that I found) for balancing the workload between workstations.
I've found a template that does that, but I would like to color the bars (red for waste, green for value adding activities and orange for necessary non value adding activities).
The bars series name starts with Waste, VA or NVA. Is it possible to color the bars on basis on the text or is there an other way?


ps: I saw this link, but I didn't fully understand it
http://www.excelforum.com/excel-programming-vba-Yamazumi chart.xlsmmacros/713028-stacked-area-chart-series-colour-change.html

sorry for double post, I thought that my post suited better at the other subforum.