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

Подписаться 575 тыс.

Просмотров 21 тыс.

50% 1

Check out the updated version of our Excel Gauge (speedometer) Chart tutorial: it's better than ever! Thanks to my friend Jon Peltier from peltiertech.com for his input. DOWNLOAD THE WORKBOOK ► www.excelcampus.com/charts/gu...
🔗LINKS
🔎 Get free weekly Excel tips: www.excelcampus.com/newsletter/
💡 Free 60-minute Excel training session: www.excelcampus.com/blueprint
📖 Join Our Comprehensive Excel Training Program: www.excelcampus.com/elevate
Related Content:
✅ Types of Progress Charts: • Progress Charts in Exc...
✅ Gauge Chart: • How To Make An Excel S...
✅ Steps Chart: • How To Make A Steps Ch...
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 ⬇️

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@tom-xy7rg 5 дней назад

Genius thx!

@najmahmed7356 4 дня назад

thanks very much , that's awesome

@jonr6680 10 месяцев назад

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

@IvanCortinas_ES 9 месяцев назад

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

@ExcelCampus 9 месяцев назад

Glad it was helpful, Ivan! 😀

@arokiarajan1230 10 месяцев назад

Love it!!!

@tibibara 26 дней назад

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

@MGA19a 10 месяцев назад

Great - cool addition to your first video - Thx!

@ExcelCampus 10 месяцев назад

Thanks for the feedback @MiroslavGavric 😀

@peterdobrijevic3107 8 месяцев назад

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

@ExcelCampus 7 месяцев назад

Great to hear that, Peter! 😀

@PaulEBrownbill 10 месяцев назад

Very informative video again, thanks Paul

@ExcelCampus 10 месяцев назад

You're welcome, @paulbrownbill7129 😀

@lisapike4839 7 месяцев назад

So helpful! Thank you!

@ExcelCampus 7 месяцев назад

Glad it was helpful! 😀

@ahmedyoussry8442 2 месяца назад

thank you for this amazing design

@ExcelCampus 2 месяца назад

Welcome 😊

@danzuniga5404 4 месяца назад

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

@1in1classable Месяц назад

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

@luukiejj 6 месяцев назад

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?

@DM03110 3 месяца назад

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

@ExcelCampus 3 месяца назад

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! 🙂

@DM03110 3 месяца назад

@@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.