Graph & Charts - Conditional Formating based on value
Is there a way for the color of the graphs to change based on certain values?
Eg. In a bar chart, as the value change, the bar column chart changes as well.
Is there a way to do this?
Thanks.
-
Official comment
Kevueli Tavainavesi- This is in the vision where we intend to bring Charts in Workiva!
Can you tell me how you would use it in your use-case? That way, we can keep it in mind when we go to build it. (e.g., if a bar goes above $100, then color the whole bar red)
Hi Kevin Walker,
Yes, just like you said. If the bar is below or above certain value, the bar changes to a different color.
In our ERM workspace, the color of the bars reflects the risk rating of each risks. Eg. If a risk rating for aparticluar risk is between 0 - 5, color is green, 6 - 10 color is blue, 11 -15 color is yellow, 16 - 20 color is orange, 21 - 25 color is red.
0Kevin Walker, please note this applies not only to bar charts, but also in the other charts like pie chart, etc.
0Please sign in to leave a comment.
Comments
3 comments