How to Create a Tornado Chart in Excel

Use a stacked bar graph to make a tornado chart.
Make sure you have two columns of data set up for the tornado chart.
1. We’ll need one of the columns of data to be negative.
Type in “-1” in any cell, Ctrl+C to copy it, then select one column of data and right-click the selection. Choose Paste Special from the menu.
2. Change the operation to Multiply and click OK.
3. To get a tornado-style look, select your data and go to the Data tab.
Click Sort and choose Largest to Smallest in the Order drop-down and hit OK.
4. Go to the Insert tab, open the Bar Graphs drop-down and choose the Stacked Bar Graph option.
5. You can also choose a more fitting style.
6. Double-click the top of the chart to open the right-side menu.
Choose the Format Axis button and open the Labels portion of the menu.
Choose Low as the Label Position.
7. The data on the left-side are still negative, click them to select them.
Open the Number portion of the menu, and change the Category to Custom.
Type in a new Format Code: ###0;###0 and click Add.
This will change the numbers to show up as positive.
❓ What do you use tornado charts for? Please let us know in comments.
#HowTech #MicrosoftExcel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here t.me/howtechtv
✅ Commercial questions [e-mail]
✅ Instagram / howtechprojects
✅ Twitter / howtechprojects

[@reggierosario4708]

Very helpful !! Thank you !!

[@richaunfacey5447]

This was a great well explained tutorial thank you!

[@raffeuddin3522]

Thank you so much, it is very help full. smile.

[@maryamgd3878]

that was great, thanks

[@wandateree]

Thank you!

[@ogagaogheneesosuakpo8853]

This is very helpful
Thank you

[@rockersherman]

Thanks a lot!

[@elements8630]

very nice video. easy method

[@idontreallylikeyoutube]

Looks great, but what if I don't what my centre axis at 0? Is there anyway to have it at 100, say? and bars representing a change from that?

[@sena-oral]

thnk you

[@jamesperry3837]

*Interesting........*

[@ducktails99]

-98 is smaller than -16, which is why it was filtering that way

[@Rcasasverde]

You sound kinda like Mr. Fantastik

[@scotthandley3854]

I'm surprised you don't even know to sort data with column headers.