This page demonstrates a few different ways that you can make tornado diagrams and waterfall charts from a scenario analysis. Issues include how to sort the tornado diagram so it shows the highest risks at the top; how to create a tornado diagram from a two way table; how to set-up scenario analysis for making a waterfall chart and how to create flexible tornado diagrams that can show different output variables.
Sorting the Tornado Diagram from the Highest from the Lowest
Making a Flexible Tornado Diagram that can Select Different Variables over Time from a Financial Model
Creating a Tornado Diagram with a Two-Way Data Table
The file associated with this video is attached to the button below and you can download the file by clicking on the button.