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.
-
Oficjalny komentarz
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.
0Zaloguj się, aby dodać komentarz.
Komentarze
Komentarze: 3