VBA to assign colors per legend for multiple charts

[joeino]

Hi,

Need a little help with my charts.

I have multiple pivot bar charts (8 to be exact) which is coming from one data source. My problem right now is, I want to assign a specific color per legend so all chart's legends will be the same. I already searched using google but can't find an answer applicable to my situation. I am using excel 2016.