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! 🙂
@@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.
@@ExcelCampus Hi Jon. Great tutorial. I am also trying to figure out how have the progress color change. I can do it with a more standard donut, but prefer the look of your gauge. Fingers crossed that you'll add this to your video library or on your website. Thanks!!
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?
Excellent video. I will definitely be using this gauge chart. Very useful, thank you.
Great to hear that, Peter! 😀
Excellent tutorial. It may also be that this type of graph is successful because people think of Power BI. Thank you Jon.
Glad it was helpful, Ivan! 😀
Anything that emulates the literal design of aircraft panel instruments is going to benefit from that research into human factors esp readability.
Very informative video again, thanks Paul
You're welcome, @paulbrownbill7129 😀
Great - cool addition to your first video - Thx!
Thanks for the feedback @MiroslavGavric 😀
So helpful! Thank you!
Glad it was helpful! 😀
thank you for this amazing design
Welcome 😊
Love it!!!
thanks very much , that's awesome
Genius thx!
How can you create the same chart but with less sequence slots?
Did you start the color side with just 1s like the other because 0 is not showing up when changing the %
When I selected the secodary Axis, the grey chart kept disappeared, what should I do? Please kindly advise. Thank you.
Is there a way to have the color of the speedometer change depending on the range of numbers input (red, yellow, green)
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! 🙂
@@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.
@@ExcelCampus Hi Jon. Great tutorial. I am also trying to figure out how have the progress color change. I can do it with a more standard donut, but prefer the look of your gauge. Fingers crossed that you'll add this to your video library or on your website. Thanks!!
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?
LINKS AREN'T WORKING PLEQSE CHECK
Hi! We are sorry for the inconvenience, the link has been updated www.excelcampus.com/charts/guage-charts/ Thanks! 😀
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