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

[@HadesDownUnder]

I love how concise and straight forward your videos are. Thank you for being such a prolific content creator.

[@MyOnlineTrainingHub]

Thanks for your kind words 😊

[@jc7671]

That was very rewarding. And at times, frustrating. Excellent to know you can insert pie charts into each other. Thank you.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@panplusk9539]

I was looking for something more compact than a gauge meter, so im glad ive stayed till the end :) Thank You.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@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]

Glad it was worth your time!

[@chrism9037]

I've never used them. Thanks Mynda, another great video!

[@MyOnlineTrainingHub]

Thanks for watching!

[@IvanCortinas_ES]

Excellent tutorial. As always, Mynda's recommendations are very good. Thank you.

[@MyOnlineTrainingHub]

Glad you like it, Ivan! 🙏

[@douglasteachout1958]

Another solid gold presentation. Well done.

[@MyOnlineTrainingHub]

Thanks so much!

[@peterdobrijevic3107]

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]

Glad it was helpful 🙏😊

[@notesfromleisa-land]

Great video that is in the "save for later" to implement. Perfect expositions, as always.

[@MyOnlineTrainingHub]

Glad you liked it!

[@johners2006]

Extremely well presented. Excellent coaching - thanks.

[@MyOnlineTrainingHub]

Thanks so much!

[@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]

Glad it was helpful 😊

[@gatsbyliu1084]

Actually useful for making individual retail investor like me ! Thank you very much!

[@MyOnlineTrainingHub]

Glad to hear that!

[@pvrameshbabu]

Nice one. I liked the way you explained the cons of Speedometer charts.

[@MyOnlineTrainingHub]

Thanks so much 😊

[@Pfupfi59]

I love your examples, the explanations and the pros and cons.

[@MyOnlineTrainingHub]

Great to hear 🙏

[@darrylmorgan]

Hi Mynda!Great Tutorial.Really Prefer The Stacked Column Chart Much Neater And Cleaner...Thank You :)

[@MyOnlineTrainingHub]

Cheers, Darryl 🙏

[@HenricAndersen]

Great video Mynda 👍

[@MyOnlineTrainingHub]

Thank you 🙏

[@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]

Nice idea! Thanks for sharing.

[@arshpreetsingh9416]

Waow, the most detailed one on Guage charts Thanks

[@MyOnlineTrainingHub]

Glad it was helpful!

[@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]

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

[@wayneedmondson1065]

Great advice! Thanks Mynda!!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@GeorgeAJululian]

Perfect as always many thanks very helpful

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@Yool69]

very good. Havec you got a example of project gantt charts with dependencies. Thank you

[@MyOnlineTrainingHub]

Without dependencies, yes: kzbin.info/www/bejne/d3_dg6NjrpKcjZo but not with dependencies.

[@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]

Sometimes you have to please the boss 👍

[@beltvq841]

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]

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

[@rasoulkhoshravan5912]

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]

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

[@willgreen2284]

Very well done. Good work

[@MyOnlineTrainingHub]

Thank you very much!

[@elijahd.spragueph.d8905]

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]

I'd probably switch the colours so that red was the higher number, rather than change the direction of the needle.

[@ntlknight]

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]

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

[@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]

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]

Thanks, finally instead of column chart with marker can it be turned into a bar chart with line marker please

[@ankushkhosla]

How do we publish the Power BI dashboards and share it with others in the organization ?

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

[@jeffryan7439]

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]

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

[@chrisk.9765]

File not found, 404 error...

[@MyOnlineTrainingHub]

Sorry Chris, should be working now

[@ScalpingForexWithTelegram]

@@MyOnlineTrainingHub Great video, for your info it is still missing the file

[@dwarfusinterruptus9314]

@@MyOnlineTrainingHub , im getting 404 errors at this time.

[@chrisk.9765]

@@MyOnlineTrainingHub Thx, Regards from Poland

[@m.ssharma535]

Super useful gauge charts (avoid) and do a simple bar chart.

[@MyOnlineTrainingHub]

Agree 😊

[@tibibara]

Very-very useful, thanks!

[@MyOnlineTrainingHub]

Great to hear!

[@jeanpavan6816]

Interesting. As for Chris K below, the file cannot be found

[@MyOnlineTrainingHub]

Sorry @jeanpavan6816 it should be working now

[@sivaprakash8518]

Which version this

[@MyOnlineTrainingHub]

Microsoft 365.

[@alexanderbaranov5418]

Interesting approach

[@MyOnlineTrainingHub]

Glad you think so!

[@TinaLillelundAndersen]

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%?

[@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]

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.

[@okoroudonsi1035]

great one

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@ilkersarkici7461]

Incredible. Thank you so much.

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@RayKanner]

Thanks for all the super content. Getting a 404 error when clicking on the Download the sample file link. Thanks

[@MyOnlineTrainingHub]

Download is fixed now!

[@GurayVural-nz1lk]

Excellent !

[@MyOnlineTrainingHub]

Glad you like it!

[@putrop.langit763]

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]

Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@peterscobbie3230]

Thanks, Mynda - your dexterity with all things visual in Excel puts me to shame, time to brush-up on my homework ;-)

[@steven.h0629]

Absolutely..

[@MyOnlineTrainingHub]

Glad you liked it, Peter!

[@AndrewRandall-ih8hm]

The link for the download file seems to point to a 404 page.

[@MyOnlineTrainingHub]

Sorry about that, the automatic blog posting didn't work. Should be fine now

[@ahlamfraij5312]

Awesome 😍

[@MyOnlineTrainingHub]

Thanks 🤗

[@AbdulrahmanMuslih-b5j]

thanks a lot

[@MyOnlineTrainingHub]

Happy to help 😊

[@ПашенныхПавел]

Thanks!

[@MyOnlineTrainingHub]

My pleasure 😊

[@donnakel8809]

brilliant

[@MyOnlineTrainingHub]

Thank you!

[@chris35932]

🤔 should I watch this video if I shouldn't build speedo charts ?

[@MyOnlineTrainingHub]

😁 I'm hoping those who think they want a Speedometer chart, will realise they shouldn't, but you can't always convince people!

[@drsteele4749]

Mynda's two pieces of advice: never make speedos and never wear speedos.

[@MyOnlineTrainingHub]

😁 exactly!

[@mmjjagon5419]

👍

[@dynamics9000]

“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]

Nice quote!

[@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]

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]

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]

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.