Hi,
I have used someone else's macro which controls colors of all bar charts in worksheet, and it works fine. I now need to change some of the charts to stacked bar charts, i.e. add a field into the Legend, and also control colors of the different elements of the stacked bar.

e.g.
For bar called "Delivered", I have color fixed as 1213412. This works for first series in the stack (legend = "Match"), but second series ("No Match") shows as different color. This is fine but I want to control this color in the macro.

thanks.

Capture2.PNG


Please Login or Register  to view this content.