Our New And Improved Gauge (Speedometer) Chart In Excel!

🔗LINKS

Related Content:

00:00 Introduction
01:00 Gauge Chart
02:55 How to Set Up Source Data
05:07 How to Build Gauge Chart
07:20 Rotate the Chart

Thoughts/comments/suggestions/feedback? Leave them in the comments below ⬇️

[ShadowhunterJDeng]

Brilliant! Very helpful, thanks so much

[peterdobrijevic]

Excellent video. I will definitely be using this gauge chart. Very useful, thank you.

[IvanCortinas_ES]

Excellent tutorial. It may also be that this type of graph is successful because people think of Power BI. Thank you Jon.

[PaulEBrownbill]

Very informative video again, thanks Paul

[MGAa]

Great - cool addition to your first video - Thx!

[jonr]

Anything that emulates the literal design of aircraft panel instruments is going to benefit from that research into human factors esp readability.

[najmahmed]

thanks very much, that's awesome

[inclassable]

Did you start the color side with just 1s like the other because 0 is not showing up when changing the %

[luukiejj]

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?

[WandeeLimanantrakool]

When I selected the secodary Axis, the grey chart kept disappeared, what should I do? Please kindly advise. Thank you.

[danzuniga]

How can you create the same chart but with less sequence slots?

[DM]

Is there a way to have the color of the speedometer change depending on the range of numbers input (red, yellow, green)

[rmvlvs]

LINKS AREN'T WORKING PLEQSE CHECK

[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 <= cv, 1, 0),
colortotal, (parts * 2) - cv,
seqs, VSTACK(seq, seqtotal),
greys, VSTACK(grey, greytotal),
colors, VSTACK(color, colortotal),
body, HSTACK(seqs, greys, colors),
staging, VSTACK(header, body),
staging))