SOLVED

Tricky formatting for a gauge chart... (see attached)

%3CLINGO-SUB%20id%3D%22lingo-sub-918336%22%20slang%3D%22en-US%22%3ETricky%20formatting%20for%20a%20gauge%20chart...%20(see%20attached)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918336%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20format%20the%20primary%20pie%20graph%20(red%2C%20yellow%2C%20green)%20of%20the%20attached%20gauge%20chart%20to%20a%20set%20value%20rather%20than%20a%20percent.%20In%20the%20attached%20example%2C%20I%20need%20the%20meeting%20of%20yellow%20and%20green%20to%20equal%20the%20goal%20or%20146%2C650.%20This%20way%2C%20if%20we%20exceed%20the%20goal%2C%20any%20surplus%20will%20be%20captured%20in%20the%20green%20portion%20of%20the%20chart.%20I%20am%20sure%20there's%20a%20way%2C%20but%20I%20can't%20figure%20it%20out.%20Any%20help%20is%20greatly%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

I am trying to format the primary pie graph (red, yellow, green) of the attached gauge chart to a set value rather than a percent. In the attached example, I need the meeting of yellow and green to equal the goal or 146,650. This way, the needle will reflect any surplus amount in the green portion in stead of the blacked out portion below. I am sure there's a way, but I can't figure it out. Any help is greatly appreciated! 

 

Thanks,

 

John

4 Replies
Highlighted
Solution

@J-Griff 

 

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.

 

 

Highlighted
perfect, THANK YOU SO MUCH!!!!
Highlighted
You're welcome!!
Highlighted
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