Dynamic Sales Score Meter Chart with Form Control Combo box and List box

#Speedometer #FormControls
In this video, you will learn how to create a dynamic sales score meter chart. In this chart we have displayed the sales core on a speedometer chart. We have displayed the sales rating also as Worst, Bad, Average, Good and Best. We have created 2 different version of this chart. We have used Form control combo box and list box to make it dynamic.

Please download the practice file from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

************* Suggested Books *********

************* My Stuff ****************

[nedalsholi]

going through the comments, you only answer the complements, but when there is something wrong with your video and people have questions about it you don't answer.. ill unfollow you. have a good day

[tracigriffin]

I have the same problem. The Doughnut is behind the pie chart. I can't select it and format it.

[apandita]

Sir, Could you please help me ..as while adding the data for Colour Ratings and Ratings...i always get the Colour Ratings on the top, due to which i am not able to move further, Please help me on

[migpir]

Hi PK. I love this video. You did not leave ANYTHING to chance misinterpretation. You created a THOROUGH, CLEAR and easy to follow video on a fairly complex topic. Thank you!

[BenDieselBasicAutomotive]

new learning again. Thanks so much, I've been waiting for this kind of topic.

[manishrawal]

Super duper Excel format


Most powerful and popular on YouTube...


Kindly create Excel with vba and more design for SCHOOL MANAGEMENT....

[ericaunzo]

Such an amazing video PK. I love your videos.

[srinivaskumar]

Hi sir, I didn’t get the option of doughnut size tweak option. I had just got the first 2 options and I tried it on excel 2021 version. In Which version have you done this ?

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

[paulocezardesouzasouza]

Wonderful, I never think this would be possible.. pure magic. I had to wacht several times to complete my chart. Thanks

[songokurah]

Excellent presentation! You're an Excel chat guru.

[ATHUMANIMNGUMBA]

I take this Godsend opportunity to thank you for the good work you are doing to educate. Please I need your assistance. Make for me a Score Meter Chart like the Dynamic one but mine is for my students and let it have the following parameters-0%-39% Fail with Grade E, 40%-49% Fail with Grade D, 50%-64% Pass with Grade C, 65&-74% Pass with Grade B (Credit), 75%-100% Pass with Grade A (Distinction). I will really appreciate

[sakale]

Your explanation are so easy to understand. Instead just try to download templates this learning is very interested. Thank Yo!

[rakibulhasan]

Nice, we want to a video or series that Will show when we make a transaction it will automatic update ledger, trial balance, balance sheet.

[horrorlovestories]

I have question : In a donut chart or pie chart why we click on secondary axis at times i feel stuck when it comes to chart visibility please help

[nedalsholi]

when i change Ratings to Doughnut and select it as secondary it disappears

[noorm]

Thank you very much. You are the best 👌

[ashrafulalam]

Hi sir if you copy and paste then how can a new learner will know to create those data table

[sachingrpl]

Very Interesting sir…. 👍💐👌But when we have number name its very difficult to pull out the name. So kindly make it searchable drop down.

[charlesthamba]

Dear Sir
There's any Android app can run excel macro vba file?? If "yes", please I need.

Thank you