Changing the color of a category in a chart

[TamirBasin]

Hello,

After reading the article of Jon Peltier
https://peltiertech.com/vba-conditional-formatting-of-charts-by-category-label/

I an still looking for a way to hardcode within the VBA the colours for the various categories.

Is there a way to do it?

e.g. I have a stacked chart with categories named: 0,1,2,3
I would like to hardcode that category "0" will be filled with red, category "1" will be filled with green...etc.

My scenario:

Working with a pivot chart.
The numbers of columns are changing according to slicer's pick.
I have names of companies on Rows
I have Categories on Columns (this is where my problem is. Not always, all categories appear)


Thank you,
Tamir

 

[pike]

Hi TamirBasin,
use,,

Private Sub Chart_Calculate()
On Error Resume Next
With ActiveChart
       .SeriesCollection("0").Interior.ColorIndex = 3     'Red
       .SeriesCollection("3").Interior.ColorIndex = 6                'Yellow
       .SeriesCollection("2").Interior.ColorIndex = 4                'Green
       .SeriesCollection("1").Interior.ColorIndex = 5                 'Blue
End With

End Sub

 

[TamirBasin]

Hi Pike,

I gave it a quick try and it seems to be doing exactly what I need.

Thank you

Regards,
Tamir