Tornado chart is useful for those who want to analyze their data for better decision making. It’s a useful tool for sensitivity analysis, but you can use it for comparison purpose as well.
It’s like a two-sided bar chart (looks like a tornado) where we have two data bars opposite to each other. It makes it easy to compare both of them. It’s a useful tool for sensitivity analysis.
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.
In Excel, there is no default option to create a tornado chart but we can use a bar chart and customize it accordingly.
So today, in this post, I’d like to share with you a 7-steps process to create a tornado chart in Excel.
So let’s get started.
Steps To Create a Tornado Chart
Here we are using following data table of two stores for comparing their product wise sale.
First of all, we need to convert data of store-1 into the negative value. This will help you to show data bars in different directions. Just multiply data with -1 or you can also use paste special option for this.
Now, insert a bar chart using this data table. Go to Insert Tab -> Charts -> Bar Chart. You will get a chart like below.
Select the axis label and open formatting options. Go to axis options -> Labels -> Label Position. Change label position to “Low”.
Next, you have to change axis position in reverse order. Go to Axis options -> Axis position -> tick mark “Category in reverse order”.
Next step is to change series gap and gap width. This will help to streamline data bars with each other. Go to series options -> Change series overlap to 100% and gap width to 10%.
Now, you have to change number formatting of the horizontal axis. Go to Axis Options -> Number -> select custom -> paste following format and click add.
Same like this you have to change the format for data labels for store-1. Go to label options -> Number -> select custom -> paste following format and click add.
Congratulations, your tornado chart is ready.
Download this sample file from here to learn more.
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.