Forum Discussion
Anonymous
9 years agoNot applicable
Conditional Formatting of Bar Chart
I would like the bars that are below the target value to be red and those equal to or above target to be green. I do not see the 'divergent' color bar options .. do I have an old version of the app?...
- 9 years ago
Anonymous
Vvelarde
Community Champion
9 years agoAnonymous
Anonymous
8 years agoNot applicable
Hi Team,
I need my data bar to have only two colours. I have an average line. The value below average should have red and above should have green. When I apply the field in colour saturation and in 'Format' when I give color code for Minimum ans Maximum, I get bars in the middle with combination of both green and red, values above one are a gradient shade of green, and bars below one are shades of red. I don have any fixed value to be given as minimum and maximum as values changes dynamically with average line.
Can you suggest a way to sort this.
Thanks in advance.