I would like to conditional format the Advanced Gauge for my different KPI’s as follows;
Red color = “<- 95%” of target.
Yellow = “95% to 105%” of target.
Green = “105% ->” of target.
However as far as I can see it only allows me to set the interval between 0 – 100%. Is it really not possible to do what I’m trying to do?
It is possible with the ‘Value’ option but not for the ‘% of Gauge Target’.
- Enter the Minimum and Maximum value under the ‘Gauge options’
- Select ‘Value’ option under the conditional formatting
- Enter the range in the ‘From’ and ‘To’ section.
- In case, if you still see the maximum value as 100 instead of your defined maximum value, click on the ‘+’ option to get your Maximum value.