I have a pivot based Stacked Bar Chart that I need to fix the colours so that a supplier is alway the same colour in the chart.
A copy of the sheet can be found here. https://www.box.com/s/fecc3765a19db88a6058
I found ideas here: http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-category-label/
but along with some others it is falling at this line of code:
Any help please.
A copy of the sheet can be found here. https://www.box.com/s/fecc3765a19db88a6058
I found ideas here: http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-category-label/
but along with some others it is falling at this line of code:
Code:
.Points(iCategory).Interior.ColorIndex = rCategory.Interior.ColorIndexAny help please.
Last edited:
