Dynamic Comparison Analysis Chart in Excel

#DynamicChart #PivotChart
Hello Friends,
In this video, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other. We have used Pivot Chart and Slicers to create this chart. In this chart, we have used dynamic legend and dynamic Chart Title.
Download the practice file from below link:
www.pk-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

[@eddiewilsoncokar5478]

The moment I saw this video I paused whatever I was working on till I was done watching and trying my hands on it. Each time I watched any of your videos my analytics skill in excel moves up exponentially. great video, great content. Thank you PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abhisekpanda236]

Very same.. This channel has potentially a great back up in taking me up in corporate ❤

[@mkajiwala1]

Great, you have covered all topics like chart, slicer, title everything, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@md.arafat7403]

Always like your tutorials.Thank you very much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@madhavtewary2421]

a very very simple and extremely helpful video sir, thanks a lot for demonstrating step by step

[@PKAnExcelExpert]

You are most welcome

[@yednekfikru5902]

u just make things easy !!! God bless u

[@PKAnExcelExpert]

Thanks a lot 😊

[@martinargimon730]

Excellent PK, Thanks very much for this tutorial. Regards . Martin ( South Africa)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@martinargimon730]

@@PKAnExcelExpert pleasure Pk. I always follow your tutorials. Extremely informative... !!

[@gregorytaylor2749]

Very educational! Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dataprorawat1788]

Liked without even watching because you always make out of the box

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@juluisbuga-ay6900]

i really love youe tutorial..
many thanks
very respectful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ukemeisaac]

Always giving valuable contents and great teaching. Thank you Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deniskarani9953]

Thank you

[@PKAnExcelExpert]

You're welcome

[@Saad.PS2009]

Thank you so much Mr PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@peternganga9371]

Very informative. Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@sandeepchamoli1083]

How you make looks easy bt most of the ppl don't know thx this is useful

[@ramdashwant2024]

You are simply Great... 🎊💗💖

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SyedMuzammilMahasanShahi]

Beautiful work. Thanks for the share.

[@pandharinathjoshi6565]

Sir your all videos good idea., excellent think

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nadermounir8228]

Very informative. Thank u PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@itdata11]

you are amazing man i love your work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@CMKCreations]

Its a great tutorial, thankz mate

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dhinagaransiva8052]

Very informative!

[@chkader87]

Thanks a lot it is really helpfull

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sandeepchamoli1083]

I like your knowledge

[@vamsikrishnamuthyala2434]

Thank you brother, it releally helped me

[@PKAnExcelExpert]

Glad it helped

[@vamsikrishnamuthyala2434]

@@PKAnExcelExpert Yes bro, I have a dought actually for can we create a graph with 2 different tables coloum graph or bar graph not the line graph, If have time can you let me know

[@temyraverdana6421]

Thank, very useful

[@PKAnExcelExpert]

Most welcome

[@neerajkumaryadav6013]

Thanks you.......

[@PKAnExcelExpert]

Most welcome🙏

[@gauravkumarsingh837]

Very good sir!

[@PKAnExcelExpert]

Many thanks!

[@atinmukherjee7533]

Loved it👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jhakridos2017]

very impressive idea..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@robertakwasiadjei8223]

Great Video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arjasarkar13]

Toog Good PK Sir 👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gutto192]

Fantastic. How about to increase the comparison by 2 employees, and still have the option All?

[@pgkannan]

Thanks PK

[@PKAnExcelExpert]

Most Welcome

[@paruvasant1]

PK the chart is very elegant and your explanation is very lucid. Thanks

[@edivisionalmanagerkavali-n4745]

Nice Sir, i am 6th viewer sir, please prepare more vedios on Google Sheets also sir 👍

[@PKAnExcelExpert]

Thanks for watching. I will definitely try to create a series of videos on Google sheets

[@mohittyagi2049]

Very nice Video Sir
Please make some videos other than sales i.e. supply chain, procurement related

[@PKAnExcelExpert]

We will try

[@RohitKumar-uy7cx]

Nice vedio sir

[@PKAnExcelExpert]

Thanks and welcome

[@Excel-Bari]

Nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lorinelson5725]

I learned so much from this video. Thank you. Can you demonstrate how to maintain this dashboard when a user selects between years? Can this type of comparison be shown as a daily comparison from one employee to all employees?

[@PKAnExcelExpert]

Yes, It can. we need to make the changes accordingly

[@user-yj8lh4gn9x]

I love this chart how can I use it to show minute by minute productivity?

[@thekushwaharahul]

It is great video.. please suggest how to connect you if in case we need to get some suggestions or help on your videos

[@lorinelson5725]

In the helper table that displays the comparison in a graph, I was able to do one year, no problem. Now I want to add 2023 to the helper table but cannot get the index match function to pull in the correct data from Jan 2022 and Jan 2023. Please provide clarification as to how to get this to work.

[@arjasarkar13]

1st viewer

[@PKAnExcelExpert]

Yes you are.. Thanks for watching

[@shijicsam6043]

Hi PK, if possible to show the actual outstanding received against Sales with this graph chart

[@yednekfikru5902]

Dear, i tried to copy some text from excel into text box by linking with formula but in the text box the text is cut...i cant get the full text in the text box. tried to google and its due to some character limit...so how can i get the full text copied to the text box? need your help.

[@SanviPatil2019]

Selected data export and save in csv file.. plz make add ins sir.. pk utility tools

[@tarunoberoi8829]

Hi PK - Any comparison chart which can sent over email with working slicers in email itself

[@zeroskiing]

I am confused.....why the average line is changing Everytime when you change the emp name.....it should be constant?

[@dharanim6570]

Hi average line remains constant until you change the region.

[@prateeksrivastava400]

Sir i need a help because I got an error

[@sandeepchamoli1083]

Omg

[@rahulskale]

Hi, your videos are very good and nicely explained 👍. Can you help to create dashboard for employees trainings status video?, it will be great support!