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
Feliz año mi buen amigo. Excelente trabajo el que compartes con mucho entusiasmo.!! Un abrazo
Thanks for the video. It was very helpful. Particularly the level of detail of the steps you walk through and demonstrate.
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
3 жыл бұрын
Thanks for your valuable feedback
Excelente, como siempre marcando la diferencia, gracias por compartir el conocimiento.
@PKAnExcelExpert
5 жыл бұрын
Gracias por sus valiosos comentarios. Te deseo un año nuevo muy feliz
Top Dez. Obrigado por compartilhar. Continua, vamos aprender muito
@PKAnExcelExpert
4 жыл бұрын
Obrigado pelo seu valioso feedback
Hola PK... Sorprendente, ya buscando aplicaciones para el. Muchas gracias
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
8 ай бұрын
Yes
Splendid, thanks is not enough for the work you do.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Woow amazing, good one, thanks. Real excel expert.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
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!
Great learning. Very helpful. Thanks for sharing.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Amazing videos! It helps me a lot! Thanks!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Excellent, how sad in Brazil, show de bola, congratulations.
parabéns Pk, seu canal é Incrível
@PKAnExcelExpert
5 жыл бұрын
Obrigado pelo seu valioso feedback. Desejo a você um ano novo muito feliz.
Viry Nice. Thank you so much !
I am addicted to this channel. Great learning tool! Thank you for these.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Great. Thank you so much
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
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!
awesome, thanks for sharing it.
Beautiful use of Excel. Please make one on powerpoint as well and share
Fabulous videos ur making
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
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
3 жыл бұрын
Thanks for your valuable feedback and support to my channel
You help me a lot dude tnks!!!!!!!!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your appreciation. Request you to please share this with your friends and colleagues.
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
Happy new year PK, nice start for new year
@PKAnExcelExpert
5 жыл бұрын
Happy new year Santosh. Thanks for your valuable support.
Amazing.. admire about your knowledge in excel :) :) Keep it up
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
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?
*Very very excellentl sir . Very very helpful*
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Many thanks.
Brilliant Sir! The pie chart within the doughnut was too good 👌👌👌🙏🙏🙏
@PKAnExcelExpert
2 жыл бұрын
Thanks a ton
Good One.....Great start for 2019 👍👍
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Very nice..keep up the good work
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Excellent Video. Thank you very much
@PKAnExcelExpert
Жыл бұрын
Glad you enjoyed it!
Thanks sirji
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Awesome. Thank You!!
@PKAnExcelExpert
2 жыл бұрын
You're welcome!
great sirji!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
awesome video PK!!!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Thanks Awesome!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Hello Kumar, Its like a gauge meter, very nice
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Excellent presentation Si8r
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Hello, question: If you want to use the result from a Pivot Table instead enter the percentage manually.. how can you do this change?
This is awesome interactive and creative chart 😀
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
Great sir ji. Can you also help me for automatic email from excel thru lotus notes.
That is awesome
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Thank You So Much for Your Sharing.
@PKAnExcelExpert
Жыл бұрын
Most welcome
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
I like your original intro. :)
@PKAnExcelExpert
4 жыл бұрын
I'm glad you like it
Awesone sirjee
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
U r brilliant bhai ... Too good
@PKAnExcelExpert
2 жыл бұрын
Thanks
An amazing
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback. Please share this with your friends and colleagues.
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.
Great Job
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Sir unable to find the excel link to download..Kindly share it on my comment box.. Appreciate your help
thank's, very useful, is it possible to get the file ?
Too good boss
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
great video
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
amazing
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
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
5 жыл бұрын
Thanks for your valuable feedback. I will definitely try to make such video.
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
3 жыл бұрын
I will try to make a separate video for this
@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.
Thanku sir very much
@PKAnExcelExpert
2 жыл бұрын
Most Welcome
Great
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
This is great..but please slow down a little. Thanks!
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will take care of this in upcoming videos
the smile still has a border of it even when i try to make it no outline it is still visible , help please
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
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.
gracias amigo de dónde eres u como te llamas excelente videos , fantásticos saludos 🤝👏👏👏
@PKAnExcelExpert
2 жыл бұрын
Gracias por sus valiosos comentarios. Mi nombre es PK y soy de la India.
Waw top
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Gr8 pk
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Mast ever
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Great sir
@PKAnExcelExpert
2 жыл бұрын
Thanks
Kia bat hi sir very very nice this video
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
Sir, can excel automatically allocate the cases to employees in excel, if I paste data that automatically should be signed
@TechAndBest
5 жыл бұрын
Assigned
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
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
4 жыл бұрын
Thanks for your valuable feedback
All the Kumars are smart :)
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
this is such a clever technique - but I had to pause and re-watch constantly to spot his cursor movement's...
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
4 жыл бұрын
Just change the angle
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?
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
Wheres the code for visual basic?
What if we want it “bad” if it goes over 100%?
May I know what is the excel version you are demonstrating? It seems that my excel version does not have some of the functions.
top
@PKAnExcelExpert
Жыл бұрын
Thanks🙏
Masterstroke
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
Hong Kong's luanita yes to affirmyes American
Sir why we have used 200%
It's great , but clearity is not good ..to recon
Делай стрелку из границы, а не как отдельный сектор
fucking cool!!!!
Amazing but u r too fastt
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will take care of this in upcoming videos
Your speaking pace is too fast to catch.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will take care of this in upcoming videos
@XX-kf7mx
3 жыл бұрын
You are too stupid to catch. You have a choice to pause his video and follow his steps.
@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
3 жыл бұрын
Ohhh, I was unaware of this that there is option to pause. LOL.
But you are not explaining the reason for anything. This is not teaching. Sorry!