Rating Meter Chart in Excel || Five Performance Buckets || Show Process or Portfolio Health

#RatingMeterChart #PerformanceRatingVisual #PortfolioHealthChart
Hello Friends,
In this video you will learn how to create a beautiful and Innovative Rating meter chart to show the Process or Portfolio level health in five buckets - Worst, Bed, Average, Good and Best.
Please download this excel file from below given link:
www.pk-anexcelexpert.com/rati...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert

[@MarekKoppel]

Thank you! I will learn a lot from you! I live with my family in the Republic of Estonia. Lots of peace and joy to you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nevillescott9061]

Thanks for the video. It was very helpful. Particularly the level of detail of the steps you walk through and demonstrate.

[@paulocezardesouzasouza2044]

Top Dez. Obrigado por compartilhar. Continua, vamos aprender muito

[@PKAnExcelExpert]

Obrigado pelo seu valioso feedback

[@Angexcel]

Excelente, como siempre marcando la diferencia, gracias por compartir el conocimiento.

[@PKAnExcelExpert]

Gracias por sus valiosos comentarios. Te deseo un año nuevo muy feliz

[@jackjimenezpereda9252]

Feliz año mi buen amigo. Excelente trabajo el que compartes con mucho entusiasmo.!! Un abrazo

[@rrajeshvasudevn1679]

Woow amazing, good one, thanks. Real excel expert.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JeffersonAlvesDadosCriativos]

parabéns Pk, seu canal é Incrível

[@PKAnExcelExpert]

Obrigado pelo seu valioso feedback. Desejo a você um ano novo muito feliz.

[@VidyaYedavalli]

Great learning. Very helpful. Thanks for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@brcgiri]

Splendid, thanks is not enough for the work you do.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@StarATL]

Cannot say how much I appreciate showing us how this was done. I have wanted to do meters in Excel for quite sometime. It is not as easy as one would expect and requires practice. Despite this being ~12 minutes, the video is presented too fast to consume and follow along. I must have stopped and backed up ~50 or more times just to duplicate what was being taught. Easy 30 minute teaching topic in a classroom setting. Again, awesome video!

[@mehtacomputer]

Yes

[@jbkregs2766]

I am addicted to this channel. Great learning tool! Thank you for these.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Mendelyeev]

Amazing videos! It helps me a lot! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Coco-dh1by]

Hi, great video, thank you. I only found that you went a bit fast and in some instances I needed to stop and rewind over and over in order to catch what you were doing, with all the stops and rewinds I took almost 3 hours to follow along. It is an awesome tool and I thank you for sharing!

[@nelsoneduardomartinezcano4560]

Hola PK... Sorprendente, ya buscando aplicaciones para el. Muchas gracias

[@gustavoecerda]

Viry Nice. Thank you so much !

[@pramilashinde631]

Fabulous videos ur making

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gilsoncosta6869]

Excellent, how sad in Brazil, show de bola, congratulations.

[@thewhereisitnowgeocachingp5891]

After watching several other video's and failing, this one gave me an easy way to create a beautiful chart. Subscribed and upvoted!

[@PKAnExcelExpert]

Glad it was helpful!

[@meetchauhan2573]

Salute sir. I have learn new things from your video. I call you a Master and will learn new things forward.. I will share my learning to others to improve themselves .. Thanks.
Keep learning..

[@PKAnExcelExpert]

Thanks for your valuable feedback and support to my channel

[@anuragtamta6563]

*Very very excellentl sir . Very very helpful*

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KHK360]

Brilliant Sir! The pie chart within the doughnut was too good 👌👌👌🙏🙏🙏

[@PKAnExcelExpert]

Thanks a ton

[@BenDieselBasicAutomotive]

Our genius Professor..... Very interesting topic!... I tried to copy your style and my Supervisors were very amazed wt my presentation.... I gained their respect.... Lot of thanks..... GOD BLESS.... and more brain power to you...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@indsun23]

awesome, thanks for sharing it.

[@timwhitemedic]

Excellent Video. Thank you very much

[@PKAnExcelExpert]

Glad you enjoyed it!

[@vtunguyen]

Great. Thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shakirkhan2011]

Many thanks.

[@santoshsapre]

Very nice..keep up the good work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@varunkhanor]

Beautiful use of Excel. Please make one on powerpoint as well and share

[@mateoespinozaespinoza]

You help me a lot dude tnks!!!!!!!!

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@Saatt79]

Good One.....Great start for 2019 👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@navinagarwal6326]

Excellent presentation Si8r

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@msantosh1220]

Happy new year PK, nice start for new year

[@PKAnExcelExpert]

Happy new year Santosh. Thanks for your valuable support.

[@SHEILA-fm5mo]

Awesome. Thank You!!

[@PKAnExcelExpert]

You're welcome!

[@horrorlovestories]

This is awesome interactive and creative chart 😀

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@mfneyaz]

great sirji!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AmeeraHazmar]

Amazing.. admire about your knowledge in excel :) :) Keep it up

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@birendraprasadsah5517]

Thanks Awesome!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@htayhtaywin2069]

Thank You So Much for Your Sharing.

[@PKAnExcelExpert]

Most welcome

[@stuartsimmons956]

That is awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@darshitchavda8264]

Awesone sirjee

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@staceyburks5143]

Great Job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajeshsinghjadham9899]

Thanks sirji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jjpatter84]

awesome video PK!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@qutaibaaljazzar8619]

An amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share this with your friends and colleagues.

[@ogcombatacademy]

Excellent. Can data from multiple excel inputs from different users reflect on this spedometer in real time or do you create one specially for each user?

[@mariafriend644]

I like your original intro. :)

[@PKAnExcelExpert]

I'm glad you like it

[@ayyolcu]

Hello Kumar,
Its like a gauge meter, very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@omupadhyay3578]

great video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohdsartaj7942]

Too good boss

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@acousticalan]

U r brilliant bhai ... Too good

[@PKAnExcelExpert]

Thanks

[@aptrends3257]

Thanku sir very much

[@PKAnExcelExpert]

Most Welcome

[@AftabAhmed-uw4ki]

Kia bat hi sir very very nice this video

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@karthikeyanp2237]

Great sir ji. Can you also help me for automatic email from excel thru lotus notes.

[@namluuhoai4990]

amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Great sir

[@PKAnExcelExpert]

Thanks

[@anbaabdellah8022]

Waw top

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@extinter]

Hello, question: If you want to use the result from a Pivot Table instead enter the percentage manually.. how can you do this change?

[@heikoheimrath7514]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@minelos5360]

thank's, very useful, is it possible to get the file ?

[@gentle2005phir]

Gr8 pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@enemieskiller5537]

Mast ever

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mayanksakaria6238]

Hie sir.. Youre videos are really helpful... If you could help me understand how i can make automat a letter using excel macros.. Example: there is a template given at a location i need excel to go there and fill the empty fills or required fills and create a letter.. Please assist

[@samratchadha5867]

Sir unable to find the excel link to download..Kindly share it on my comment box.. Appreciate your help

[@gregsasso7855]

This is great..but please slow down a little. Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@grijalvaescobedo158]

gracias amigo de dónde eres u como te llamas excelente videos , fantásticos saludos 🤝👏👏👏

[@PKAnExcelExpert]

Gracias por sus valiosos comentarios. Mi nombre es PK y soy de la India.

[@shakirkhan2011]

How can we group all elements of speedometer if I want to shift/show in other sheet? I tried to show in other sheet but the black rim and the imoticon did not appear.

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks🙏

[@magorzatagaik2440]

Hello PK, I love your videos, and may I ask you to prepare speedometer or rating meter chart with the target and values not percentage?

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video.

[@photocol1]

That’s fantastic. How would you handle values that are less than zero? I’d like these to be counted as worst, but not sure how to effect this in the dial?

[@PKAnExcelExpert]

I will try to make a separate video for this

[@luisrosario432]

You could try to add to your formula a max formula and adjusted so when the numbers are less than zero, it bumps it up to 0. That way your graph or table will look more professional.

[@eamonndelaney7934]

Great video. In Cell E4, what is the logic of putting in the 200% formula? I am trying to do this with $ amounts rather than %, and this step is proving difficult. Thanks!

[@gordonachtermann2161]

The range of percentages is 1-100, so using 200and subtracting from that creates a half circle range for the arrow. If you want to be able to input a range up to 25 (for instance, you would replace 200 with 50.

[@kestonmendez4290]

All I have to say is great job teaching us but when moving the mouse and showing us what to do you have to slow it down so we can catch on. Display the mouse on to the area so we can see it also not only communicate it. Voice was a little hard to understand sometime my friend. Other than that awesome!!! I do thank you and continue to show us the way. Now, Back to class hahahahah.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@merveilmeok2416]

All the Kumars are smart :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TechAndBest]

Sir, can excel automatically allocate the cases to employees in excel, if I paste data that automatically should be signed

[@TechAndBest]

Assigned

[@hirenshukla3505]

Hello PK Ji, after creation of half donut chart I want to use it on top of my Excel data but as the chart area is full I want to use only top part of chart and below hided chart want to hide below the data is it possible? Please help and support. Thanks

[@harambegaming1383]

the smile still has a border of it even when i try to make it no outline it is still visible , help please

[@jh1544]

this is such a clever technique - but I had to pause and re-watch constantly to spot his cursor movement's...

[@shreyasshinde5445]

Masterstroke

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jeffryan7439]

I love these Speedo charts but I’m stuck, I have a max range of 5 and the data I want to present is .01 through 5, so my data can be 2.57 for example, how can I do this?

[@ramkumars2392]

How can we move all the chart once score meter is prepare
I am not able move all the chart at a time - group function

[@littleangels6069]

this chart starts from 20% what if I want to start with 0% and whatever percent i type the needle should go there instead of defined 20, 50 75, 95

[@varunkhanor]

Just change the angle

[@user-qz4vj4sd4t]

May I know what is the excel version you are demonstrating? It seems that my excel version does not have some of the functions.

[@photocol1]

What if we want it “bad” if it goes over 100%?

[@hamishrobertson6997]

Wheres the code for visual basic?

[@Khunryijduy]

Hong Kong's luanita yes to affirmyes American

[@victorvasquez4107]

fucking cool!!!!

[@emecianejoseph2046]

Sir why we have used 200%

[@user-rv4zd4de3x]

Делай стрелку из границы, а не как отдельный сектор

[@usharanisasikumar3242]

It's great , but clearity is not good ..to recon

[@sajnapm9248]

Amazing but u r too fastt

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@hemantsaini3734]

Your speaking pace is too fast to catch.

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@XX-kf7mx]

You are too stupid to catch. You have a choice to pause his video and follow his steps.

[@hemantsaini3734]

Seems you are too busy to reply, why are you feeling offended. I posted my view on your video. If you are not ready to take feedback than I am sorry you should opt out For feedback. Feedbacks could be positive or negative it depends upon the viewer perception. In this video you are just pacing that the drawback.

[@hemantsaini3734]

Ohhh, I was unaware of this that there is option to pause. LOL.

[@eternalrebel9555]

But you are not explaining the reason for anything. This is not teaching. Sorry!