TamirBasin
New Member
- Joined
- Apr 11, 2017
- Messages
- 49
- Office Version
- 365
- Platform
- Windows
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
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
Last edited: