Advanced Tornado Diagrams and Waterfall Charts for Sensitivity Analysis

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

 

Excel File with Illustration of How to Create a Tornado Diagram where Risks are Sorted from Highest to 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.

Excel File with Illustration of How to Create a Torando Diagram from a Financial Model and a Two Way Data Table