Conditional Formatting on a Donut Chart

Copper Contributor

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?

 

 

 

1 Reply

@AliSheikh 

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.

 

NikolinoDE

I know I don't know anything (Socrates)