Feb 26 2022 05:14 AM
Hi All!
I'm working for an NGO and there financial reports are unclear so I'm preparing a dashboard for easy financial review.
When illustrating ratios I want to depict these using donut charts with the ratio in the middle of the donut for clarity.
To help staff understand the meaning of this ratio I want the appropriate donut segement to change colour if there is a problem. Normally I can do this on a single cell using conditional formating but for donut chart, i dont know how to do it.
For example: If< 0.5 (green). If between 0.51 and 0.80 (orange). If > 0.81 (RED)
How can I do this?
Feb 26 2022 07:05 AM
Progress Doughnut Chart with Conditional Formatting in Excel
Assuming the data is in A1, then:
Assuming the data is in A1, then:
Home -> Conditional Formatting -> New Rule -> Use formula to determine which cells to format -> enter this formula and format the cell by color.
If =A1>0.5 (green)
If =A1=>0.51
If =A1=<0.80 (orange)
or
=AND($A1>0.51,$A1<0.80) (orange)
If =A1> 0.81 (Red)
Untested...but should work :)
Hope I was able to help you with this info.
I know I don't know anything (Socrates)