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 😊

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!

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

@MyOnlineTrainingHub

Жыл бұрын

Glad you like it, Ivan! 🙏

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!

Again, highly fun and educational with lots of practical info. Much appreciated!

@MyOnlineTrainingHub

Жыл бұрын

Glad you enjoyed it!

Extremely well presented. Excellent coaching - thanks.

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much!

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

@MyOnlineTrainingHub

Жыл бұрын

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.

@MyOnlineTrainingHub

Жыл бұрын

Glad it was helpful 😊

Another solid gold presentation. Well done.

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much!

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

@MyOnlineTrainingHub

Жыл бұрын

Thanks for watching!

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

@MyOnlineTrainingHub

Жыл бұрын

Glad you liked it!

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

8 ай бұрын

Glad it was helpful 🙏😊

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

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much 😊

Great advice! Thanks Mynda!!

@MyOnlineTrainingHub

Жыл бұрын

Glad it was helpful!

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

@MyOnlineTrainingHub

11 ай бұрын

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 :)

@MyOnlineTrainingHub

Жыл бұрын

Glad it was worth your time!

Perfect as always many thanks very helpful

@MyOnlineTrainingHub

Жыл бұрын

Glad you liked it 🙏

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

@MyOnlineTrainingHub

Жыл бұрын

Cheers, Darryl 🙏

Very-very useful, thanks!

@MyOnlineTrainingHub

20 күн бұрын

Great to hear!

Incredible. Thank you so much.

@MyOnlineTrainingHub

8 ай бұрын

Glad you enjoyed it!

Very well done. Good work

@MyOnlineTrainingHub

Жыл бұрын

Thank you very much!

Waow, the most detailed one on Guage charts Thanks

@MyOnlineTrainingHub

Жыл бұрын

Glad it was helpful!

Great video Mynda 👍

@MyOnlineTrainingHub

Жыл бұрын

Thank you 🙏

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.

Awesome 😍

@MyOnlineTrainingHub

Жыл бұрын

Thanks 🤗

Interesting approach

@MyOnlineTrainingHub

Жыл бұрын

Glad you think so!

great one

@MyOnlineTrainingHub

Жыл бұрын

Glad you liked it 🙏

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

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

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

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

thanks a lot

@MyOnlineTrainingHub

Жыл бұрын

Happy to help 😊

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 👍

Thanks!

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 😊

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

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

@MyOnlineTrainingHub

11 ай бұрын

Agree 😊

brilliant

@MyOnlineTrainingHub

Жыл бұрын

Thank you!

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

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

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

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!

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

@MyOnlineTrainingHub

Жыл бұрын

Without dependencies, yes: kzread.info/dash/bejne/c4KutNJmqZDPh5s.html but not with dependencies.

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.

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

6 ай бұрын

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

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

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

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

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

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

3 ай бұрын

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

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

@MyOnlineTrainingHub

Жыл бұрын

Sorry @jeanpavan6816 it should be working now

👍

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!

Which version this

@MyOnlineTrainingHub

Жыл бұрын

Microsoft 365.

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

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

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

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

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

@MyOnlineTrainingHub

Жыл бұрын

😁 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

@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

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.