Forum Discussion
Tricky formatting for a gauge chart... (see attached)
If the boarder between yellow and green needs to reflect your goal, the sum of red and yellow needs to be 100%. I assume you want the RED to reflect a performance of up to 35%. Then YELLOW should be 65%. If you then also set GREEN to 35% and BLANK to 50%, the gauge looks nice and balanced.
Make sure that the percentage in the formula in G4 is set to 200% in the above example. Achieving 100% will put the needle where you want it to be.
If the boarder between yellow and green needs to reflect your goal, the sum of red and yellow needs to be 100%. I assume you want the RED to reflect a performance of up to 35%. Then YELLOW should be 65%. If you then also set GREEN to 35% and BLANK to 50%, the gauge looks nice and balanced.
Make sure that the percentage in the formula in G4 is set to 200% in the above example. Achieving 100% will put the needle where you want it to be.
- perfect, THANK YOU SO MUCH!!!!
- Oooops......
Re-reading my earlier reply. Noticed I made a typo. The BLANK part should also be 65%, so that the percentages add up to 200. But I guess you figured that out by yourself 🙂 - You're welcome!!
