Dynamic Performance Chart in Excel

#DynamicCharts #FormControls
Hello Friends,
In this video, you will learn how to create dynamic and stylish Performance Charts. We have used excel shapes and Doughnut Chart here. To make these charts dynamic we have used Form control option buttons.
Download the practice file from below 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:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

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

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

[UpExcel]

You make some great looking charts PK and this is yet another example. So many great ideas....keep them coming ✔👍💚

[nerenlakhraj]

Hi PK - I have to admit that you are an absolute genius when it comes to Dashboard and graphs among your other skills. Like they say, "A picture is worth a thousand words" . I love your work. Keep it up.

[amirsaiftaz]

Another breakthrough PK Guru ji, well explained n designed donut chart. You are great.

[AashishVaghela]

Dear Priyendra,
Thanks for this YouTube Channel and posting such splendid Excel Videos, which are very helpful in real life. Anybody with intermediate level of knowledge on Excel, like me can make minor modifications to what you have shown and get their own work done in real-life. I had never known all these could be done with Charts in Excel and they could be made so beautiful. Thanks once again !! You Rock !!

I have noticed that lot of your Dashboards and Performance Charts are with respect to the Call-Centers/BPO industry where a Team Lead, Operations Manager and above rely heavily on such visual presentations. I simply adore and admire that. Haven't found much of similar content on YouTube. That's what makes you unique. There is Leila Gharani who closely makes your kind of videos, which are useful as well. Your's are simple and enough to understand and useful.

Keep more coming. CHEERS !!

[SyedMuzammilMahasanShahi]

Beautiful looking charts. Thanks for the share.

[khandokarnabilurrahman]

Thank you so much for this wonderful post! It will be much more appreciated if you could just slowed down a little bit while showing the charts because beginners have a very tough time to get this!

[bzb]

Awesome mind blowing !!! Thank you for this course 👍🏾👍🏾👍🏾

[mrashid]

Very impressive charts! and very impressive presentation PK-G! 👍

[kiwi_g]

Great video once again! I came across one of your videos on YouTube "weekly sales chart in excel" . I thought it was an excellent video and walk through was easy to follow. I wanted to see if you (PK) or anyone in the comments could help me combine two formulas together in one cell. Beginner excel user here! Thanks in advance! Here are the two I am trying to combine:
=countifs(D1:D94, "DR")
=countifs(E3:E91, ">="&C101, E3:E91, "<="&D101)

[prabhur]

This is really awesome .. with your permission I am going to modify these ideas and use them in my presentation/dashboard

[noeldoyle]

Another great idea and really well explained.
Cheers

[imadghomri]

You are the Boss . Yours IG from Morocco

[onamikaonitha]

Which xl version need to install for this dashboard?
Or i can create this by any xl version, pls advise.

[azadma]

Good job sir but you can add like those charts at power bi

[hussainahammed]

Dear Gentleman, I want to show month wise performance as well in above graphical presentation, can you please guide how to add.

[hariomgupta]

Sir plzz tell how make vba for auto filter when data enter header

[toofanfeizi]

Hi PK

I need your help on some chart

[rajakrishnan]

Is there any way to check whether an excel file is already opened or it remains unopen

[arunkumarnair]

What if it hits 100% or above? Like target Vs achievement?