How to Create a Tornado Chart in Excel

What is an Excel Tornado Chart

The Excel Tornado Chart is like a two-sided bar chart (looks like a tornado) where you have two data bars which are opposite to each other and makes it easy to compare both of them. As I said, it’s a useful tool for sensitivity analysis, but you can use it where you need to compare values.

According to Wikipedia:

It’s a special type of bar chart in which data is sorted vertically from highest to lowest. With this type of shape, it looks like a tornado.

How to Create a Tornado Chart in Excel

In Excel, there is no default option to create a tornado chart but you can use the default bar chart and customize it. Today, in this post, we will learn to create it. Make sure to download this sample file from here to follow along.

To create a tornado chart in Excel you need to follow the below steps:

Congratulations, now you have your first tornado chart in your worksheet, just like below.

tornado chart using bar chart

Sample File

Conclusion

Some people call it tornado diagrams, a useful tool for decision making by comparison. You can compare two different items or a single item for the different periods.

So that’s the entire story about tornado chart and YES, you just need 7 STEPS to create it.

One thing I just forget to tell you that you can also use conditional formatting or a REPT function to create an in-cell tornado chart.

I hope you found it useful and it will help you take your skill to next level.

Now tell me one thing. Have you ever used a tornado chart? Please share with me in the comment section, I’d love to hear from you. And, please don’t forget to share this tip with your friends. I’m sure they will appreciate it.



About the Author

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

12 thoughts

Leave a Comment

Your email address will not be published.

  1. HI,

    How did we get positive values for Store 1 in the chart number area left hand side. As we converted to negative values the same negative values are displaying in the chart too

  2. Excelente, diseño bastante fácil para desarrollar, en cuanto a su presentación nos detalla un panorama mas claro de existencias en almacenes

  3. Funnel Chart and Tornado Chart are synonymous. However, the chart you have given above is a variation of tornado chart for comparing two data sets. Hence, i think that it should be named a bit differently to highlight its usage.

      • @Oz
        Yes, you are right.
        @Ramana
        There is a basic difference between Funnel chart and tornado chart. A stage in a funnel chart can’t be larger than the previous one. Tornado chart works on two different ways of comparison.