Tornado Chart in Excel
Tornado charts compare characteristics of two populations.
How to Make a Tornado Chart Using QI Macros Add-in for Excel
Click on the QI Macros Menu and select, SPC Charts, Tornado Chart. This will open the QI Macros Tornado Chart Template.
Input your data in columns B and C and your data labels in column A. Next click on the "Sort and Filter Tornado Chart" button to create a Tornado Chart.
In the tornado chart above, the distribution of males and females is shown for a set of populations.