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 :)
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.
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.
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.
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
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.
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?
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
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.
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
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%?
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?
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
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.
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%?
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
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
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
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
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.
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.
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
“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,//
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
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
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.
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.
I love how concise and straight forward your videos are. Thank you for being such a prolific content creator.
Thanks for your kind words 😊
That was very rewarding. And at times, frustrating.
Excellent to know you can insert pie charts into each other.
Thank you.
Glad it was helpful!
I was looking for something more compact than a gauge meter, so im glad ive stayed till the end :) Thank You.
Glad it was helpful!
I've never used them. Thanks Mynda, another great video!
Thanks for watching!
Excellent tutorial. As always, Mynda's recommendations are very good. Thank you.
Glad you like it, Ivan! 🙏
Great video that is in the "save for later" to implement. Perfect expositions, as always.
Glad you liked it!
Extremely well presented. Excellent coaching - thanks.
Thanks so much!
Actually useful for making individual retail investor like me ! Thank you very much!
Glad to hear that!
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 :)
Glad it was worth your time!
I love your examples, the explanations and the pros and cons.
Great to hear 🙏
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.
Glad it was helpful 😊
Another solid gold presentation. Well done.
Thanks so much!
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
Glad it was helpful 🙏😊
Nice one. I liked the way you explained the cons of Speedometer charts.
Thanks so much 😊
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.
Sometimes you have to please the boss 👍
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.
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
Hi Mynda!Great Tutorial.Really Prefer The Stacked Column Chart Much Neater And Cleaner...Thank You :)
Cheers, Darryl 🙏
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.
Nice idea! Thanks for sharing.
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?
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
very good. Havec you got a example of project gantt charts with dependencies. Thank you
Without dependencies, yes: ruclips.net/video/ANzRp-y-iW8/видео.html but not with dependencies.
Perfect as always many thanks very helpful
Glad you liked it 🙏
Waow, the most detailed one on Guage charts
Thanks
Glad it was helpful!
Very-very useful, thanks!
Great to hear!
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.
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
Great advice! Thanks Mynda!!
Glad it was helpful!
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%?
Incredible. Thank you so much.
Glad you enjoyed it!
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?
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
Super useful gauge charts (avoid) and do a simple bar chart.
Agree 😊
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.
I'd probably switch the colours so that red was the higher number, rather than change the direction of the needle.
Thanks for all the super content. Getting a 404 error when clicking on the Download the sample file link. Thanks
Download is fixed now!
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%?
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
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
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
Thanks, finally instead of column chart with marker can it be turned into a bar chart with line marker please
How do we publish the Power BI dashboards and share it with others in the organization ?
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
Great video Mynda 👍
Thank you 🙏
great one
Glad you liked it 🙏
Interesting approach
Glad you think so!
Very well done. Good work
Thank you very much!
Interesting. As for Chris K below, the file cannot be found
Sorry @jeanpavan6816 it should be working now
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.
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.
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
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Thanks, Mynda - your dexterity with all things visual in Excel puts me to shame, time to brush-up on my homework ;-)
Absolutely..
Glad you liked it, Peter!
Which version this
Microsoft 365.
Awesome 😍
Thanks 🤗
File not found, 404 error...
Sorry Chris, should be working now
@@MyOnlineTrainingHub Great video, for your info it is still missing the file
@@MyOnlineTrainingHub , im getting 404 errors at this time.
@@MyOnlineTrainingHub Thx, Regards from Poland
thanks a lot
Happy to help 😊
Thanks!
My pleasure 😊
The link for the download file seems to point to a 404 page.
Sorry about that, the automatic blog posting didn't work. Should be fine now
brilliant
Thank you!
🤔 should I watch this video if I shouldn't build speedo charts ?
😁 I'm hoping those who think they want a Speedometer chart, will realise they shouldn't, but you can't always convince people!
👍
“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,//
Nice quote!
Mynda's two pieces of advice: never make speedos and never wear speedos.
😁 exactly!
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
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
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.
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.