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

Пікірлер: 158

  • @jackjimenezpereda9252
    @jackjimenezpereda92525 жыл бұрын

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

  • @nevillescott9061
    @nevillescott90613 жыл бұрын

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

  • @MarekKoppel
    @MarekKoppel3 жыл бұрын

    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

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @Angexcel
    @Angexcel5 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

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

  • @paulocezardesouzasouza2044
    @paulocezardesouzasouza20444 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Obrigado pelo seu valioso feedback

  • @nelsoneduardomartinezcano4560
    @nelsoneduardomartinezcano45605 жыл бұрын

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

  • @StarATL
    @StarATL5 жыл бұрын

    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

    @mehtacomputer

    8 ай бұрын

    Yes

  • @brcgiri
    @brcgiri4 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @rrajeshvasudevn1679
    @rrajeshvasudevn16794 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @Coco-dh1by
    @Coco-dh1by2 жыл бұрын

    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!

  • @VidyaYedavalli
    @VidyaYedavalli4 жыл бұрын

    Great learning. Very helpful. Thanks for sharing.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @Mendelyeev
    @Mendelyeev5 жыл бұрын

    Amazing videos! It helps me a lot! Thanks!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @gilsoncosta6869
    @gilsoncosta68694 жыл бұрын

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

  • @JeffersonAlvesDadosCriativos
    @JeffersonAlvesDadosCriativos5 жыл бұрын

    parabéns Pk, seu canal é Incrível

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

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

  • @gustavoecerda
    @gustavoecerda4 жыл бұрын

    Viry Nice. Thank you so much !

  • @jbkregs2766
    @jbkregs27664 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @vtunguyen
    @vtunguyen4 жыл бұрын

    Great. Thank you so much

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @thewhereisitnowgeocachingp5891
    @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

    @PKAnExcelExpert

    Жыл бұрын

    Glad it was helpful!

  • @indsun23
    @indsun233 жыл бұрын

    awesome, thanks for sharing it.

  • @varunkhanor
    @varunkhanor4 жыл бұрын

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

  • @pramilashinde631
    @pramilashinde6315 жыл бұрын

    Fabulous videos ur making

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @meetchauhan2573
    @meetchauhan25733 жыл бұрын

    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

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback and support to my channel

  • @mateoespinozaespinoza
    @mateoespinozaespinoza5 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

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

  • @BenDieselBasicAutomotive
    @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

    @PKAnExcelExpert

    Жыл бұрын

    Thanks for your valuable feedback

  • @msantosh1220
    @msantosh12205 жыл бұрын

    Happy new year PK, nice start for new year

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Happy new year Santosh. Thanks for your valuable support.

  • @AmeeraHazmar
    @AmeeraHazmar3 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @ogcombatacademy
    @ogcombatacademy4 жыл бұрын

    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?

  • @anuragtamta6563
    @anuragtamta65635 жыл бұрын

    *Very very excellentl sir . Very very helpful*

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @shakirkhan2011
    @shakirkhan20114 жыл бұрын

    Many thanks.

  • @KHK360
    @KHK3602 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks a ton

  • @Saatt79
    @Saatt795 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @santoshsapre
    @santoshsapre5 жыл бұрын

    Very nice..keep up the good work

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @timwhitemedic
    @timwhitemedic Жыл бұрын

    Excellent Video. Thank you very much

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Glad you enjoyed it!

  • @rajeshsinghjadham9899
    @rajeshsinghjadham98995 жыл бұрын

    Thanks sirji

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @SHEILA-fm5mo
    @SHEILA-fm5mo2 жыл бұрын

    Awesome. Thank You!!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    You're welcome!

  • @mfneyaz
    @mfneyaz5 жыл бұрын

    great sirji!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @jjpatter84
    @jjpatter845 жыл бұрын

    awesome video PK!!!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @birendraprasadsah5517
    @birendraprasadsah55175 жыл бұрын

    Thanks Awesome!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @ayyolcu
    @ayyolcu5 жыл бұрын

    Hello Kumar, Its like a gauge meter, very nice

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @navinagarwal6326
    @navinagarwal63264 жыл бұрын

    Excellent presentation Si8r

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @extinter
    @extinter5 жыл бұрын

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

  • @horrorlovestories
    @horrorlovestories Жыл бұрын

    This is awesome interactive and creative chart 😀

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks for your valuable feedback🙏

  • @karthikeyanp2237
    @karthikeyanp22375 жыл бұрын

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

  • @stuartsimmons956
    @stuartsimmons9565 жыл бұрын

    That is awesome

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @htayhtaywin2069
    @htayhtaywin2069 Жыл бұрын

    Thank You So Much for Your Sharing.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Most welcome

  • @mayanksakaria6238
    @mayanksakaria62385 жыл бұрын

    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

  • @mariafriend644
    @mariafriend6444 жыл бұрын

    I like your original intro. :)

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    I'm glad you like it

  • @darshitchavda8264
    @darshitchavda82644 жыл бұрын

    Awesone sirjee

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @acousticalan
    @acousticalan2 жыл бұрын

    U r brilliant bhai ... Too good

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks

  • @qutaibaaljazzar8619
    @qutaibaaljazzar86195 жыл бұрын

    An amazing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

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

  • @shakirkhan2011
    @shakirkhan20114 жыл бұрын

    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.

  • @staceyburks5143
    @staceyburks51434 жыл бұрын

    Great Job

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @samratchadha5867
    @samratchadha58674 жыл бұрын

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

  • @minelos5360
    @minelos53604 жыл бұрын

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

  • @mohdsartaj7942
    @mohdsartaj79425 жыл бұрын

    Too good boss

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @omupadhyay3578
    @omupadhyay35784 жыл бұрын

    great video

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @namluuhoai4990
    @namluuhoai49905 жыл бұрын

    amazing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @magorzatagaik2440
    @magorzatagaik24405 жыл бұрын

    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

    @PKAnExcelExpert

    5 жыл бұрын

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

  • @photocol1
    @photocol13 жыл бұрын

    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

    @PKAnExcelExpert

    3 жыл бұрын

    I will try to make a separate video for this

  • @luisrosario432

    @luisrosario432

    3 жыл бұрын

    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.

  • @aptrends3257
    @aptrends32572 жыл бұрын

    Thanku sir very much

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Most Welcome

  • @heikoheimrath7514
    @heikoheimrath75145 жыл бұрын

    Great

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @gregsasso7855
    @gregsasso78554 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

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

  • @harambegaming1383
    @harambegaming13833 жыл бұрын

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

  • @eamonndelaney7934
    @eamonndelaney79343 жыл бұрын

    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

    @gordonachtermann2161

    2 жыл бұрын

    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.

  • @grijalvaescobedo158
    @grijalvaescobedo1582 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

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

  • @anbaabdellah8022
    @anbaabdellah80224 жыл бұрын

    Waw top

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @gentle2005phir
    @gentle2005phir5 жыл бұрын

    Gr8 pk

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @enemieskiller5537
    @enemieskiller55375 жыл бұрын

    Mast ever

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @pandharinathjoshi6565
    @pandharinathjoshi65652 жыл бұрын

    Great sir

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki2 жыл бұрын

    Kia bat hi sir very very nice this video

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks for your valuable feedback🙏

  • @TechAndBest
    @TechAndBest5 жыл бұрын

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

  • @TechAndBest

    @TechAndBest

    5 жыл бұрын

    Assigned

  • @ramkumars2392
    @ramkumars23924 жыл бұрын

    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

  • @kestonmendez4290
    @kestonmendez42904 жыл бұрын

    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

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @merveilmeok2416
    @merveilmeok24165 жыл бұрын

    All the Kumars are smart :)

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @jh1544
    @jh15443 жыл бұрын

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

  • @littleangels6069
    @littleangels60694 жыл бұрын

    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

    @varunkhanor

    4 жыл бұрын

    Just change the angle

  • @jeffryan7439
    @jeffryan74399 ай бұрын

    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?

  • @hirenshukla3505
    @hirenshukla35052 ай бұрын

    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

  • @hamishrobertson6997
    @hamishrobertson69973 жыл бұрын

    Wheres the code for visual basic?

  • @photocol1
    @photocol13 жыл бұрын

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

  • @user-qz4vj4sd4t
    @user-qz4vj4sd4t5 жыл бұрын

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

  • @anbaabdellah8022
    @anbaabdellah8022 Жыл бұрын

    top

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks🙏

  • @shreyasshinde5445
    @shreyasshinde54455 жыл бұрын

    Masterstroke

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 жыл бұрын

    Thanks for your valuable feedback

  • @Khunryijduy
    @Khunryijduy8 ай бұрын

    Hong Kong's luanita yes to affirmyes American

  • @emecianejoseph2046
    @emecianejoseph20462 жыл бұрын

    Sir why we have used 200%

  • @usharanisasikumar3242
    @usharanisasikumar32423 жыл бұрын

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

  • @user-rv4zd4de3x
    @user-rv4zd4de3x5 жыл бұрын

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

  • @victorvasquez4107
    @victorvasquez41072 жыл бұрын

    fucking cool!!!!

  • @sajnapm9248
    @sajnapm92484 жыл бұрын

    Amazing but u r too fastt

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

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

  • @hemantsaini3734
    @hemantsaini37344 жыл бұрын

    Your speaking pace is too fast to catch.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

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

  • @XX-kf7mx

    @XX-kf7mx

    3 жыл бұрын

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

  • @hemantsaini3734

    @hemantsaini3734

    3 жыл бұрын

    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

    @hemantsaini3734

    3 жыл бұрын

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

  • @eternalrebel9555
    @eternalrebel95554 жыл бұрын

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