SOLVED
Home

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
J-Griff
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
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.

 

 

perfect, THANK YOU SO MUCH!!!!
You're welcome!!
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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies