chart change data series color

Hello,

I have always found really good solution & tips from this forum. Hope someone will able to help me to achive this one! I have got Pivot table with stacked bar chart. How can i change the data series color using for each loop functionality?
File attached

Thanks,