Excel Speedometer Charts - How to build them and why YOU SHOULDN'T!

  Рет қаралды 51,079

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

How to build Excel Speedometer Charts or Gauge Charts, why they are BAD and what to use instead.
Download the example file: www.myonlinetraininghub.com/e...
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
0:00 How to Build Excel Speedometer Charts
0:18 Building Excel Speedometer Charts
5:48 Dynamic Chart Label
6:33 The Problem with Speedometer Charts
7:16 Alternatives to Speedometer Charts

Пікірлер: 115
@HadesDownUnder
@HadesDownUnder Жыл бұрын
I love how concise and straight forward your videos are. Thank you for being such a prolific content creator.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks for your kind words 😊
@jc7671
@jc7671 Жыл бұрын
That was very rewarding. And at times, frustrating. Excellent to know you can insert pie charts into each other. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@PaulRichards1
@PaulRichards1 Жыл бұрын
Perfect timing on this video! I've been dealing with trying to transition a dashboard with a speedometer chart from Excel to Power BI and was having a lot of trouble. I think I'm going to try the bar chart idea. However, I need to show a range of outcomes relative to the thresholds, not just a single value. Need to play with it and see if I can make it work.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful 😊
@IvanCortinas_ES
@IvanCortinas_ES Жыл бұрын
Excellent tutorial. As always, Mynda's recommendations are very good. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you like it, Ivan! 🙏
@panplusk9539
@panplusk9539 Жыл бұрын
I was looking for something more compact than a gauge meter, so im glad ive stayed till the end :) Thank You.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@Pfupfi59
@Pfupfi59 Жыл бұрын
I love your examples, the explanations and the pros and cons.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Great to hear 🙏
@gmailh3ct0r
@gmailh3ct0r Жыл бұрын
Again, highly fun and educational with lots of practical info. Much appreciated!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you enjoyed it!
@johners2006
@johners2006 Жыл бұрын
Extremely well presented. Excellent coaching - thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much!
@notesfromleisa-land
@notesfromleisa-land Жыл бұрын
Great video that is in the "save for later" to implement. Perfect expositions, as always.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it!
@chrism9037
@chrism9037 Жыл бұрын
I've never used them. Thanks Mynda, another great video!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks for watching!
@douglasteachout1958
@douglasteachout1958 Жыл бұрын
Another solid gold presentation. Well done.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much!
@pvrameshbabu
@pvrameshbabu Жыл бұрын
Nice one. I liked the way you explained the cons of Speedometer charts.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much 😊
@wayneedmondson1065
@wayneedmondson1065 Жыл бұрын
Great advice! Thanks Mynda!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@darrylmorgan
@darrylmorgan Жыл бұрын
Hi Mynda!Great Tutorial.Really Prefer The Stacked Column Chart Much Neater And Cleaner...Thank You :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Cheers, Darryl 🙏
@GeorgeAJululian
@GeorgeAJululian Жыл бұрын
Perfect as always many thanks very helpful
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it 🙏
@peterdobrijevic3107
@peterdobrijevic3107 8 ай бұрын
Absolutely brill, I wish that I'd seen this before I'd purchased some expensive software that does the same thing. Thank you and keep'um coming
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
Glad it was helpful 🙏😊
@sergegagne874
@sergegagne874 Жыл бұрын
I clicked on this one to get it out of my feed cause I don`t care for charts that much... and then, oh, hmmm, what, wow! :) Awesome stuff as always Mynda :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was worth your time!
@gatsbyliu1084
@gatsbyliu1084 11 ай бұрын
Actually useful for making individual retail investor like me ! Thank you very much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 ай бұрын
Glad to hear that!
@willgreen2284
@willgreen2284 Жыл бұрын
Very well done. Good work
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thank you very much!
@ilkersarkici7461
@ilkersarkici7461 9 ай бұрын
Incredible. Thank you so much.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
Glad you enjoyed it!
@tibibara
@tibibara 23 күн бұрын
Very-very useful, thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 22 күн бұрын
Great to hear!
@arshpreetsingh9416
@arshpreetsingh9416 Жыл бұрын
Waow, the most detailed one on Guage charts Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@astrokevin92
@astrokevin92 Жыл бұрын
Many thanks, that's ingenious. I thought of a way to get Excel to place the 0..100 text labels, too. Just add a third donut series to carry the labels (no fill and no line of course). It will need 13 sections of width 0, 5, 10, 10....10, 95 and labels, "0", "", "10", "20"... etc.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Nice idea! Thanks for sharing.
@alexanderbaranov5418
@alexanderbaranov5418 Жыл бұрын
Interesting approach
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you think so!
@okoroudonsi1035
@okoroudonsi1035 Жыл бұрын
great one
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it 🙏
@HenricAndersen
@HenricAndersen Жыл бұрын
Great video Mynda 👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thank you 🙏
@ahlamfraij5312
@ahlamfraij5312 Жыл бұрын
Awesome 😍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks 🤗
@beltvq841
@beltvq841 6 ай бұрын
Thanks for a good video with an easy and understandable explanation. Is it possible to make the chart horizontal? I can't seem to make the point/line to fit if it's horizontal.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Not sure what you mean because it is horizontal 🤔 you’re welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@Anonom2012
@Anonom2012 Жыл бұрын
My boss happens to love cars and he LOVES my speedometer charts (mine are smaller as I don't use the gray exterior dataset.) It doesn't matter how much real estate they take up--he looks far more intently at what I am presenting because the visuals appeal to him.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Sometimes you have to please the boss 👍
@user-wz2pw1tr3f
@user-wz2pw1tr3f Жыл бұрын
thanks a lot
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Happy to help 😊
@user-hu7os2sq4n
@user-hu7os2sq4n Жыл бұрын
Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
My pleasure 😊
@rasoulkhoshravan5912
@rasoulkhoshravan5912 7 ай бұрын
Thanks for your tutorial which is excellent as always. I want to show a number in a pivot table in this speedometer. How can make the connection between pie chart needle number and the pivot table number, by selecting the item from a slicer?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
You can add a data label for the pie chart needle and link it to a cell in your workbook that's connected to the PivotTable value. If you get stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@m.ssharma535
@m.ssharma535 11 ай бұрын
Super useful gauge charts (avoid) and do a simple bar chart.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 ай бұрын
Agree 😊
@Yool69
@Yool69 Жыл бұрын
very good. Havec you got a example of project gantt charts with dependencies. Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Without dependencies, yes: kzfaq.info/get/bejne/d7SqhdNe3pPNh2w.html but not with dependencies.
@RayKanner
@RayKanner Жыл бұрын
Thanks for all the super content. Getting a 404 error when clicking on the Download the sample file link. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Download is fixed now!
@jeffryan7439
@jeffryan7439 9 ай бұрын
I haven’t seen copy paste into a chart like that, love it, Hey what if my range is not 100, I need a max range of 5 and my data is from .00, .01 etc up to max level of 5, So the needle could point to 2.57 for example, how would you do this?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 ай бұрын
Hey Jeff, glad it was helpful. Please post your question and sample Excel file on our forum where someone can help you modify the chart to suit your needs: www.myonlinetraininghub.com/excel-forum
@donnakel8809
@donnakel8809 Жыл бұрын
brilliant
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thank you!
@jumpmanz5
@jumpmanz5 Жыл бұрын
Love the video, but having trouble getting the chart scale doughnut (2nd doughnut) imposed on the first. it keeps adding it to the first so i have a single doughnut ring. I'm sure there is a solution I'm missing.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Great to hear you liked the video. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@TinaLillelundAndersen
@TinaLillelundAndersen 2 ай бұрын
Production exceed over budget, so 100% is not the limit, but must be where you have 50%. What should i enter, if i want range of values not to be 0-100% but from 50-150% or 75 -125%?
@elijahd.spragueph.d8905
@elijahd.spragueph.d8905 6 ай бұрын
Is there a way to make the needle go backwards when the number increases? I'm creating a speedometer for intake wait times for a treatment agency and I want the speedometer to go down into the red the longer an appointment takes to complete.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
I'd probably switch the colours so that red was the higher number, rather than change the direction of the needle.
@patrickkinbonso1809
@patrickkinbonso1809 Жыл бұрын
Hi .. thanks for the video .. quick question please. The video shows how to make a single stack column chart with a line marker .. is it possible to make a multiple columns chart with their corresponding line please? Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Yes. Add more columns to your source data table and extend the series to include the new columns. Set the 'line' for the Actual series to 'no fill' and add a gap width to the columns so they have space between them. If you get stuck, post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@patrickkinbonso1809
@patrickkinbonso1809 Жыл бұрын
Thanks, finally instead of column chart with marker can it be turned into a bar chart with line marker please
@ntlknight
@ntlknight 9 ай бұрын
Would it be possible to have a gauge (or speedometer) chart...using doughnuts similar to your speedometer...but that not only show the 0% - 100% range (horizontally, where the 0% is far left and the 100% is the far right of the gauge)...but to also extend the gauge to include negative values (that would extend the gauge to the left, going backwards...making a circle below the horizontal axis) as well as values that exceed 100% (and would go to the right, going forwards...making a circle below the horizontal axis) that currently stops at 100%?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 ай бұрын
Possibly, however I don't have any examples of it. You can try posting your question and sample Excel file on our forum where someone might be able to help you further: www.myonlinetraininghub.com/excel-forum
@ankushkhosla
@ankushkhosla Жыл бұрын
How do we publish the Power BI dashboards and share it with others in the organization ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
You publish the reports to the Power BI service. You and each person wanting to see the dashboard needs a Power BI Pro licence. That's the short answer but it's a bit more complicated than I can answer in the comments here. If you'd like to get up to speed with Power BI, please consider my course: www.myonlinetraininghub.com/power-bi-course
@mmjjagon5419
@mmjjagon5419 Жыл бұрын
👍
@peterscobbie3230
@peterscobbie3230 Жыл бұрын
Thanks, Mynda - your dexterity with all things visual in Excel puts me to shame, time to brush-up on my homework ;-)
@steven.h0629
@steven.h0629 Жыл бұрын
Absolutely..
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Glad you liked it, Peter!
@jeanpavan6816
@jeanpavan6816 Жыл бұрын
Interesting. As for Chris K below, the file cannot be found
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Sorry @jeanpavan6816 it should be working now
@naimapedrono9665
@naimapedrono9665 Жыл бұрын
HI Minda. I have a dashboard with a lot of charts. I would like to see every chart in "big" when I click on it. That it takes the full screen and I be able to return to my dashboard. Can you help.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
You'd need to create a separate sheet for the big version of each chart and then insert a hyperlink from the dashboard to each 'big' sheet, so when they click on the small charts in the dashboard it takes them to the sheet where the big version of the chart is.
@putrop.langit763
@putrop.langit763 3 ай бұрын
i want to make the scale for speedometer is just from 80 to 100 from 100% scale, how to make the neddle to be pointed at the exact value as i want, example 84 and 93
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@sivaprakash8518
@sivaprakash8518 Жыл бұрын
Which version this
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Microsoft 365.
@AndrewRandall-ih8hm
@AndrewRandall-ih8hm Жыл бұрын
The link for the download file seems to point to a 404 page.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Sorry about that, the automatic blog posting didn't work. Should be fine now
@chrisk.9765
@chrisk.9765 Жыл бұрын
File not found, 404 error...
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Sorry Chris, should be working now
@ScalpingForexWithTelegram
@ScalpingForexWithTelegram Жыл бұрын
@@MyOnlineTrainingHub Great video, for your info it is still missing the file
@dwarfusinterruptus9314
@dwarfusinterruptus9314 Жыл бұрын
@@MyOnlineTrainingHub , im getting 404 errors at this time.
@chrisk.9765
@chrisk.9765 Жыл бұрын
@@MyOnlineTrainingHub Thx, Regards from Poland
@chris35932
@chris35932 Жыл бұрын
🤔 should I watch this video if I shouldn't build speedo charts ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
😁 I'm hoping those who think they want a Speedometer chart, will realise they shouldn't, but you can't always convince people!
@YasinNabi
@YasinNabi Жыл бұрын
“Success is peace of mind, which is a direct result of self-satisfaction in knowing you made the effort to become the best of which you are capable.” -John Wooden,//
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Nice quote!
@drsteele4749
@drsteele4749 Жыл бұрын
Mynda's two pieces of advice: never make speedos and never wear speedos.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
😁 exactly!
@bathroombuddy17
@bathroombuddy17 Ай бұрын
Great video thank you!. Is it possible to make the line move in the stacked column if the value changes? I'm finding it disappears as soon as i change the value
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Yes, you should be able to. If you're stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@peterbartholomew7409
@peterbartholomew7409 Жыл бұрын
I had never thought of using a pie chart for the needle! On the rare occasions when I have used such a chart I have tended to go for a superimposed scatter chart with a single line segment from (0, 0) to (SIN(ϑ), COS(ϑ)). A nice thick red line and a faint shadow (maybe with a similarly formatted red disc at the centre) and all is ready to go! Just a moment of heresy. The purpose of such a large display of a single value, is to force the audience to focus on the value by excluding other information that might distract from the key point.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks for sharing your technique. If you’re only displaying a gauge chart then ok, but most people put them in dashboards where they aren’t the sole focus.
Excel Slopegraphs
11:52
MyOnlineTrainingHub
Рет қаралды 12 М.
How to Create a Gauge Chart (Speedometer) in Excel - Excel Girl
4:54
MISS CIRCLE STUDENTS BULLY ME!
00:12
Andreas Eskander
Рет қаралды 19 МЛН
Best KFC Homemade For My Son #cooking #shorts
00:58
BANKII
Рет қаралды 69 МЛН
Как бесплатно замутить iphone 15 pro max
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 8 МЛН
Mama vs Son vs Daddy 😭🤣
00:13
DADDYSON SHOW
Рет қаралды 46 МЛН
AWESOME Excel Charts & Visuals | For Business & Finance Professionals
16:36
Our New And Improved Gauge (Speedometer) Chart In Excel!
11:12
Excel Campus - Jon
Рет қаралды 20 М.
How to create Target Achievement Doughnut Chart in Excel
14:28
Tech Solutions
Рет қаралды 4,3 М.
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 148 М.
How To Build a GORGEOUS Speedometer Gauge Chart in Excel
9:40
Mellon Training
Рет қаралды 33 М.
How to Instantly Improve Your Excel Charts [Watch This!]
11:16
MyOnlineTrainingHub
Рет қаралды 34 М.
Info-graphics: 3D Gauge Chart in Excel
15:41
PK: An Excel Expert
Рет қаралды 52 М.
Проверил, как вам?
0:58
Коннор
Рет қаралды 248 М.
Rate This Smartphone Cooler Set-up ⭐
0:10
Shakeuptech
Рет қаралды 6 МЛН
Tag him😳💕 #miniphone #iphone #samsung #smartphone #fy
0:11
Pockify™
Рет қаралды 3 МЛН