Tornado or a Butterfly Chart in Excel

Hello Friends,
In this video you will learn how to create a TORNADO or a BUTTERFLY chart in excel. This chart is helpful for the comparison of two Teams/Processes on different metrics/products.
You can download this excel file from below link for better understanding:
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
************ 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-m...
Laptop: amzn.to/3g1607D

[@soniakutubuddin2168]

Thank you for this wonderful, easy to follow tutorial. Hope to see and learn more from your channel.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yolindaburns3447]

I just used this chart type and love it! Thank you!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Hitman-os1sp]

Fantastic excel graphics in presenting datasets. A true wizard in excel. Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@eighttech]

Beautiful graph

[@PKAnExcelExpert]

Thanks🙏

[@TheKami300]

Thanks
for your excelent work & thanks again for knowledge sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mahendramohan4418]

Love it and thanks for sharing

[@PKAnExcelExpert]

Most welcome

[@Angexcel]

Surprised by his versatility, congratulations friend.

[@tienngotk]

Hi PK, this is the most chart I have ever seen. Thank for sharing!

[@PKAnExcelExpert]

Thanks

[@michellemcdade7016]

Very good- and helpful! :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vivekrawat1758]

Very nice, thank you

[@pandharinathjoshi6565]

Superb explanation sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@raza107]

Janab PK sb..i am greatful .Your dashboard and excel tips are awesome. Thank you

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@sol_aveiro]

Once more thanks for your help!

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@rienthongw]

Thank you for a sharing. It's helpful.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback.

[@rienthongw]

Would you please suggest me how to compare age by Excel.

[@wongcilikhd]

You are very pro, bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheKami300]

Superb

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dineshmamgain108]

maajaa aa gaya.......Mr PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nitinsingh.2107]

Bahut Badiya!

[@PKAnExcelExpert]

Thanks

[@shobanas4680]

I have a data to show 2021 vs 2022 sales per employee, the comparison point will be 2021 , 2022. The employees are from different teams , so I want to show a dynamic butterfly chart, where the names of employees should change when I select the team, names should appear in the gap between 2 charts

[@aashraynalawade]

Hi PK, this is wonderful video, just had one query, if the 2 data fields are different then? Like one would be value and other would be % then how would be the data representation

[@prabujayk]

Sir is it possible to keep same order metrix? Metrix order series is inverting to top why?

[@masudrahman8410]

What will we do if have negative percent

[@masudrahman8410]

Could you please tell me what will I do?

[@henryleonrivera7385]

Hola PK
Tengo una duda.
Si los montos son números enteros mayores a 100 cómo se haría, cual sería la forma de armarlo?

[@preetirekhapatro8701]

Can we do this chart in 3 team??