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.
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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.