Тёмный

Dynamic Performance Chart in Excel 

PK: An Excel Expert
Подписаться 270 тыс.
Просмотров 35 тыс.
50% 1

#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:
www.pk-anexcelexpert.com/dyna...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
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
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

Опубликовано:

 

5 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 65   
@reslin7286
@reslin7286 2 года назад
Great video. I could solve my problem
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Glad I could help
@Up4Excel
@Up4Excel 4 года назад
You make some great looking charts PK and this is yet another example. So many great ideas....keep them coming ✔👍💚
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@bzb23
@bzb23 4 года назад
Awesome mind blowing !!! Thank you for this course 👍🏾👍🏾👍🏾
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 4 года назад
Beautiful looking charts. Thanks for the share.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@saleem6r7
@saleem6r7 4 года назад
Yet another great learning. Thanks pk
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@nerenlakhraj5252
@nerenlakhraj5252 4 года назад
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.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@noeldoyle2477
@noeldoyle2477 4 года назад
Another great idea and really well explained. Cheers
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@chandrur5172
@chandrur5172 4 года назад
Thx for sharing your knowledge...
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@amirsaiftaz
@amirsaiftaz 4 года назад
Another breakthrough PK Guru ji, well explained n designed donut chart. You are great.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@lukev730
@lukev730 4 года назад
Amazing PK Thank you
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@albanoteles4924
@albanoteles4924 4 года назад
Excellent. Thanks
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@hussainahammed9227
@hussainahammed9227 2 года назад
Excellent 👏 👏
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thank you! Cheers!
@mrashid229
@mrashid229 4 года назад
Very impressive charts! and very impressive presentation PK-G! 👍
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@AashishVaghela
@AashishVaghela 4 года назад
Dear Priyendra, Thanks for this RU-vid 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 RU-vid. 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 !!
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@rkmbalaa
@rkmbalaa 3 года назад
Simply awesome
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@pandharinathjoshi6565
@pandharinathjoshi6565 2 года назад
Excellent sir
@prabhur6820
@prabhur6820 4 года назад
This is really awesome .. with your permission I am going to modify these ideas and use them in my presentation/dashboard
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback. It is absolutely free. You can use it according to your requirements
@kiwi_g
@kiwi_g 4 года назад
Great video once again! I came across one of your videos on RU-vid "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,"
@discoverystudio3998
@discoverystudio3998 4 года назад
Good work. Keep it up.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@fathirinchi7822
@fathirinchi7822 4 года назад
thank you very match
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@coolag74
@coolag74 4 года назад
Excellent Idea...
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@khandokarnabilurrahman4080
@khandokarnabilurrahman4080 4 года назад
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!
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback. I will take care of this in upcoming videos.
@imadghomri4010
@imadghomri4010 4 года назад
You are the Boss . Yours IG from Morocco
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@caducarteiro
@caducarteiro 4 года назад
parabens, brazil
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for watching
@fabiolalmeida3164
@fabiolalmeida3164 4 года назад
Very good your videos
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@azadma6427
@azadma6427 4 года назад
Good job sir but you can add like those charts at power bi
@onamikaonitha4722
@onamikaonitha4722 3 года назад
Which xl version need to install for this dashboard? Or i can create this by any xl version,pls advise.
@toofanfeizi1353
@toofanfeizi1353 4 года назад
Hi PK I need your help on some chart
@hussainahammed9227
@hussainahammed9227 2 года назад
Dear Gentleman, I want to show month wise performance as well in above graphical presentation, can you please guide how to add.
@hariomgupta4677
@hariomgupta4677 4 года назад
Sir plzz tell how make vba for auto filter when data enter header
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
I will try to make such video
@rajakrishnan01
@rajakrishnan01 4 года назад
Is there any way to check whether an excel file is already opened or it remains unopen
@arunkumarnair001
@arunkumarnair001 4 года назад
What if it hits 100% or above? Like target Vs achievement?
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
This chart is applicable only till 100%
@arunkumarnair001
@arunkumarnair001 4 года назад
@@PKAnExcelExpert thank you. But will it not look akward if it hits 100%. Have not tried it. But liked the look
@bssgiridhar
@bssgiridhar 11 месяцев назад
Auto count when visitor click sir
@PKAnExcelExpert
@PKAnExcelExpert 11 месяцев назад
will try to create
@bestofx9013
@bestofx9013 4 года назад
developer option kaise aata hai
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Please watch below given video to learn how enable the developer tab ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q8AZ2TGbY7M.html
@muhammadrinoemir8416
@muhammadrinoemir8416 4 года назад
The picture not clear
@laxmankuwar641
@laxmankuwar641 4 года назад
why excel charts is so complicated??
Далее
Info-graphics: Timer Chart Visualization in Excel
11:22
Dynamic Variance Arrows Chart with Check Boxes
18:49
Просмотров 126 тыс.
Conquering fears and slippery slops on two wheels!
00:18
Все кругом Миланы... 🤣
00:12
Просмотров 119 тыс.
⚡️Uylanishim kerak, sovchilikka borasizmi?...😅
00:50
Progress Circle Chart in Excel as NEVER seen before!
10:31
Beautiful 3D Visualization in Excel
19:13
Просмотров 94 тыс.
Innovation: Focus Chart in Excel
10:53
Просмотров 43 тыс.
Progress Circle chart in Excel 2010
14:15
Просмотров 53 тыс.
3D Container Pivot Chart with Slicers and Timeline
14:24
Conquering fears and slippery slops on two wheels!
00:18