Create a Tornado (Butterfly) Chart

The term Tornado chart evokes some kind of wild or natural images and the butterfly chart give you the sense of serenity. Whether you use one term or another, the chart is basically a bar chart that goes both ways. If you're into data visualization or infographic charts, you might have seen these type of bar charts to flare out to the left and right sides. It's not too hard to create these charts so check out the video to learn how.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@SpotlightImpact]

Nice excel hack! Thanks for the tutorial!

[@DougHExcel]

Glad you like it!

[@excelisfun]

Very cool video! Love all the chart tricks!

[@sarveshtwit]

Very lucidly explained. the first how to video which I could actually use to make a excel chart. love you KZbin as well as this fantastic user and his super helpful video.

[@DougHExcel]

Hi sarveshtwit, thanks for the comment!

[@SandeepKumar-vx9kv]

i wish i had a teacher like you @ school...you're awesome

[@DougHExcel]

Hi Sandeep Kumar, thanks for the kind words!

[@wassdepp1]

I received some good compliments today at work while making a presentation to quantify the impact of new credit sales plans here in El Salvador, I didn't take the credit for myself and referenced it to your youtoube channel. Thank you Doug H.

[@DougHExcel]

Hi Willian Serrano, thanks for the comment!

[@aydasforough7797]

This is exactly what I was looking for! Thanks for the helpful video!

[@DougHExcel]

Glad it was helpful!

[@anonimous1739]

Very nice video. Right after i watched this video i created my own Tornado Chart according to my work needs. Thank you so much Doug.

[@olly1803]

You Doug are a damn saviour!!! It was so easy to follow you step by step!!!!!!

[@DougHExcel]

Hi Olly, thanks for the comment!

[@wttthm]

I've watched lots of videos on tornado charts. comparative histograms, etc, but this is the only one that uses the label in the middle. Very cool!

[@DougHExcel]

Hi Matt Wells, thanks for the comment!

[@TongSattrawut]

You are so clever. Thanks a lot Doug.

[@H.j.f.g.h.j]

Thank u so much, may God bless u for a life ❤️

[@DougHExcel]

Hi Melek Ali, thanks for the kind words!

[@cuteONE22]

Thank you very much!!! you are an amazing teacher! I hardly ever use excel and don't remember anything from school, but you are amazing and I was able to follow you step by step and make my own tornado chart. It helped me tremendously with my masters dissertation.

[@DougHExcel]

Wow, thank you!

[@martincarnegie6242]

Hi Doug, this demo was excellent. I know that this is a few years old now, so thought I would add a comment about something I noticed in O365 in the hopes it saves someone else a bit of time. When doing the scatter chart step, I followed the steps, but it kept converting the entire chart to a scatter chart rather than just the series. In O365 when the "Change Chart Type" dialog appears, it will be set to "Combo" by default. When I click on "X Y (Scatter)" like your demo, that is when it converts the entire chart to a scatter. What I had to do, is in the "Combo", scroll to the "X-axis" and change that to a "X Y (Scatter)". After that, everything is the same as you stated. Thanks for the great demo!

[@DougHExcel]

Hi Martin Carnegie, thanks for adding to the thread!

[@marthamix2241]

Hi Doug why the tick mark on the chart does not point to 0 on the new label? is it something wrong with the second table I created? Thank you in advance

[@arashakbarzadeh1381]

Thank you so much. So cool Mister Doug!

[@DougHExcel]

You're welcome!

[@hmdabir]

Awesome. Very helpful. Thanks.

[@kapamagicman]

Awesome video!!!

[@judyblair9570]

Thank you! Very helpful, you saved me!

[@DougHExcel]

You're Welcome!

[@SteveSwanson999]

Great tutorial - SUPER COOL CHART!

[@DougHExcel]

Hi Steve Swanson, glad you liked it, thanks for commenting!

[@joannapatricialibatique3728]

THANK YOU VERY MUCH!!!

[@DougHExcel]

You're Welcome!

[@jay55patel]

great to see your lesson thank you

[@DougHExcel]

Hi Jay Patel, you're welcome!

[@sathyasorub9022]

Really Fantastic. Will try ..Thank u

[@DougHExcel]

Hi Sathya Sorub, thanks for the comment!

[@Mu00lia]

Thanks for this nice presentation.

[@saikarthik8181]

Hello, It was very helpful. But I am facing problem in inserting standard error bars for left side bars of the graph. Could you please help with it?

[@DougHExcel]

Hi Sai Karthik, sorry I don't do consulting :-( ....but try to post on the mrexcel.com forum!

[@AnnRungsinee]

Thank you! You just saved my life!!

[@DougHExcel]

Hi Rungsinee Chaiyakoon, glad you liked it, thanks for commenting!

[@nanditaagarwal8347]

Thanku Doug H...very nice..its very useful.....superlykk

[@NaniFatimana]

thank you

[@DougHExcel]

Welcome!

[@poonamjayant1686]

CREATIVE USE OF EXCEL

[@DougHExcel]

Hi Poonam Jayant, thanks for the comment!

[@michwarn]

Awesome! thank you!

[@amermahmoud1903]

great.thanks

[@mabelwongting]

Very informative, thanks!

[@alansewell6439]

Wonderful!

[@israelrangel6063]

Woah!! Nice trick!

[@DougHExcel]

Hi Israel Rangel, glad you liked it, thanks for commenting!

[@van18mimimi]

THANK YOU SO MUCH YOU'LL SAVE MY PAPER

[@DougHExcel]

Thanks Vanessa Ferreira de Almeida, glad it helped!

[@pickmeisha]

This works but the gap set at 25 isnt even on my chart; im using values 0-100. Can’t figure out the problem.

[@DougHExcel]

Dunno what happen but try other ways? kzbin.info/www/bejne/h3rOlYuZedh4pNE or kzbin.info/www/bejne/iXjVXqiwdqylepY

[@TheAmazingPunjab]

Hi Sir, need your help, when i am trying to convert x -axis to scatter diagram, the whole chart is converting into scatter instead of just x axis. M I missing something here. Thanks

[@DougHExcel]

maybe it's the steps sequence on how it's created. Maybe this can give some insight kzbin.info/www/bejne/nnSkk6uqoL-ijMk

[@kellenober9609]

How can you make the labels in the center align to the left?

[@sheaadelson2006]

This is amazing. Thank you. Hope I can execute on it!

[@stillmanjunior1985]

Just a quick question - at 8.31 the data totals suddenly change to something different, have I missed something? Probably me being daft. After amending the Scatter Graph I seem to end up with the values at the bottom being too far to the left. Really useful guide though once I get to grips with it!

[@stillmanjunior1985]

No worries, I worked that out soon after! Thanks, it's really useful

[@nurmahizamdisa2809]

Hi, do you have MAC version?

[@alm9707]

Amazing!

[@DougHExcel]

:-) Glad you liked!

[@alexrosen8762]

Wow! Thanks a lot :-)

[@DougHExcel]

You're welcome!

[@rienthongw]

May I ask about how can I manage lots of data such as a thousand or ten thousand (compare budget year 2016 and 2017)in main categories, it may 5-6 categories). Thank you for your help

[@DougHExcel]

You might want to use PowerPivot or PowerQuer to summarize the data. I've got a few videos to peruse PP - kzbin.info/aero/PL-n8f1cY_Qw_jKRDz5hAlZfHx7iysYtiG PQ - kzbin.info/aero/PL-n8f1cY_Qw9v3Y-jSrPy8-ctFw2yJjLZ

[@rienthongw]

Thank you so much.

[@vipersting9527]

Good, but it doesn't work in Microsoft word 360.

[@vipersting9527]

Your Also Set the numbers to 10,000, but said it was at 1,000

[@alancrook1034]

I wanted to learn NOT to be bored to death.

[@DougHExcel]

Alan Crook, that is very interesting...thanks for letting me know.

[@swaraj44]

Swallow your spit before speaking man!

[@DougHExcel]

Swaraj, that is very interesting...thanks for letting me know.