Excellent tutorial. It may also be that this type of graph is successful because people think of Power BI. Thank you Jon.
@ExcelCampus8 ай бұрын
Glad it was helpful, Ivan! 😀
@PaulEBrownbill9 ай бұрын
Very informative video again, thanks Paul
@ExcelCampus9 ай бұрын
You're welcome, @paulbrownbill7129 😀
@tibibaraКүн бұрын
Ohh, I loved that tutorial so much, thanks! ------------------------------------------------------------------------------------------- GAUGEstaging(100, 50%) as formula parts - number of units: 100 complevel - completion level in percentage: 50% ------------------------------------------------------------------------------------------- GAUGEstaging=LAMBDA(parts, complevel, LET( header, HSTACK("Sequence", "Grey", "Color"), cv, complevel * parts, seq, SEQUENCE(parts), seqtotal, parts + 1 & "-" & parts * 2, grey, SEQUENCE(parts, , 1, 0), greytotal, SUM(grey), color, IF(seq
@MGA19a9 ай бұрын
Great - cool addition to your first video - Thx!
@ExcelCampus9 ай бұрын
Thanks for the feedback @MiroslavGavric 😀
@jonr66809 ай бұрын
Anything that emulates the literal design of aircraft panel instruments is going to benefit from that research into human factors esp readability.
@peterdobrijevic31077 ай бұрын
Excellent video. I will definitely be using this gauge chart. Very useful, thank you.
@ExcelCampus7 ай бұрын
Great to hear that, Peter! 😀
@lisapike48396 ай бұрын
So helpful! Thank you!
@ExcelCampus6 ай бұрын
Glad it was helpful! 😀
@ahmedyoussry8442Ай бұрын
thank you for this amazing design
@ExcelCampusАй бұрын
Welcome 😊
@danzuniga54043 ай бұрын
How can you create the same chart but with less sequence slots?
@1in1classable29 күн бұрын
Did you start the color side with just 1s like the other because 0 is not showing up when changing the %
@luukiejj5 ай бұрын
I'm trying to do this on a Macbook. But i can't switch the chart to a combo and still be a doughnut... Is this a Mac thing or am i just not doing it right?
@DM031103 ай бұрын
Is there a way to have the color of the speedometer change depending on the range of numbers input (red, yellow, green)
@ExcelCampus2 ай бұрын
Hi Daniel! 😊 It is possible to add at least one more color via this method (e.g., red). Without a third (tertiary) axis for another color, two colors (green, red) on the same axis may be the limit of this particular setup due to joint rotation issues. There are other ways to go about this, so I have added your idea to our list of potential video topics. Thank you! 🙂
@DM031102 ай бұрын
@@ExcelCampus that would be amazing i took your advice on another comment and have managed to create 3 graphs that communicate and only fill in if they fall within range but i need that to take place on one graph for presentation purposes.
@rmvlvs52289 ай бұрын
LINKS AREN'T WORKING PLEQSE CHECK
@ExcelCampus9 ай бұрын
Hi! We are sorry for the inconvenience, the link has been updated www.excelcampus.com/charts/guage-charts/ Thanks! 😀