Forum Discussion
Et1w
8 years agoFrequent Visitor
Conditional formatting in a clustered column chart
Hi everyone I have a clustered column chart with many columns. What i want to do use conditional formatting on the chart so if one of the bars has a value higher than a certain value it will be a...
- 8 years ago
Sorry for misleading you, I did not understood the question at first.
You can do that, and here is how to do it step by step :
1 - Add the value you want to use as a color filter in the Color Saturation field
2 - Go to the Data Colors section in the Format area, it looks like that :
3 - Input the value as it follow :
Here I've put 999 999 as minima so that everything below is black and not half yellow half black
- Quentin