Dynamic Comparison in Butterfly Chart

#DynamicChart #FormControl
Hello Friends,
In this video, you will learn how to create a Dynamic Comparison in Butterfly Chart in Microsoft Excel. Dynamic Comparison in Butterfly Chart is useful when you want to compare the Sales or any other parameter for two employees or two Teams for multiple dates. We have used Form Control Combo boxes to select the Employee name to compare the Sales. To make the dynamic and rolling dates, we have used Form Control Scroll Bar.
Download the practice file from the below link:
www.pk-anexcelexpert.com/dyna...
Watch the video for Comparative Analysis Dashboard in Power BI:
• Comparative Analysis D...
Power Pivot tutorials:
• Power Pivot
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
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...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@nsanch0181]

PK thank you for showing how to make that beautiful butterfly chart. That is a nice visual comparison between 2 employees, and it was fun to learn. Thank you!

[@pgkannan]

Thank you so much PK after long time. Worth for watching 15 minutes...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cesarsaldana3429]

Master pk, it is a pleasure to see your videos, it is great what you share with us.
Greetings from Mexico.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@macubanana5105]

I love you PK. Learned a lot from you love - phil ❤️

[@PKAnExcelExpert]

Thanks a lot 🙏

[@arjasarkar13]

PK Dada I am your big time Fan.

[@PKAnExcelExpert]

Thanks a lot

[@saloriasaxon7323]

One word - SUPERB!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ukemeisaac]

Thank you Sir. Always a great learning time.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@relax9286]

You're work is amazing! Thank you!!

[@PKAnExcelExpert]

Most welcome

[@gurucool80]

Thank you so much PK. Its awesome.. keep sharing more n more tips n tricks 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chalmerilexus2072]

You are a star....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vipulDJhaveri]

Excellent and very well explained for everyone’s immediate use thanks a lot pk ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Waiting for your video, since from few days your videos not seen... great sir

[@PKAnExcelExpert]

Thanks a lot

[@mariadesousavalerio]

Adorei. Muito obrigada (I loved it. Thank you) 👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@temyraverdana6421]

Thanks, very useful!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pawansharma-wo3xh]

Excellent job PK. Good visualization after long time. Keep it up

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RajendraPatel.]

Very nice explain Sir .!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sursinhparmar6519]

Superb work sir
Please school management in Excel and vba

[@OyeitsAmitSharma]

Superb PK SIR

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@narendiranarumugam3475]

Super

[@PKAnExcelExpert]

Thanks

[@stevereed5776]

Another great video PK, I have adapted it for my own use. The only issue is that the center section (white area) does not stay central and it starts to look lop sided. Very nice looking chart though and I have to admit, I have stolen a few ideas from you over the recent months!

[@Michael_Alaska]

PK's charts are as artistic as they are functional. I also enjoy his work very much. If you want the white area to stay centered change the Left Padding column to =MAX(Data!$B$2:$K$49)-B2; or if you know the maximum value for each day (say 100), then Left Padding to =100-B2 and copy down.

[@harshbahal5761]

Your explanation are good but very lengthy...suggest please drastically shorten it for more acceptablity

[@vishalsinghrajput143]

Sir please make next version pk utility add-in

[@hammatlili6384]

Plz u can do it in user form or no