Tornado Chart in Excel
Tornado charts compare characteristics of two populations.
Ways to Create a Tornado Chart in Excel
There are many different ways to create a tornado chart in Excel. However, most take several steps and lots of time. QI Macros add-in for Excel provides two ways to create tornado charts in just seconds.
- Tornado chart macro
- Tornado chart fill-in-the-blanks template.
Instructions for using the Tornado Chart Macro
- QI Macros installs a new tab on Excel's menu.
To create a tornado chart, just select your data and click on: QI Macros | Box, Dot, Scatter Plot | Tornado Chart.
- QI Macros will perform all of the calculations and create a tornado chart for you.
- That's it. Its really that simple.