How to Use Excel Tornado Diagrams

1. Open your spreadsheet and highlight the data you want to include in your tornado diagram. Go to 'Insert' and select 'Bar,' then 'Clustered Bar.'
2. Right-click on the horizontal axis and select 'Format Axis.' Select 'Axis Value' under 'Vertical Axis Crosses,' then enter your base case value.
3. Select the vertical axis for your diagram, then check next to 'Categories in Reverse Order' and click 'Low' on the 'Axis Labels' menu.
4. Click one of the bars to open a pane labeled 'Series Options' and slide the button under 'Series Overlap' over to the far right. Click 'Finish.'