How to Use Excel & Tornado Diagrams

Written by kara page
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Excel & Tornado Diagrams
A tornado chart is particularly useful for sensitivity analysis. (Kick Images/Photodisc/Getty Images)

A tornado diagram is a type of bar chart in which the data is displayed with vertical bars, with the largest at the top and the smallest at the bottom, giving the appearance of a tornado. While Microsoft Excel does not offer a specific "tornado chart" in its selection of graphs and charts, creating one within Excel is simple. Before you begin, you should enter all of the data you want displayed in your tornado diagram into a spreadsheet.

Skill level:
Moderately Easy


  1. 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. 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. 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. 4

    Click one of the bars to open a pane labelled "Series Options" and slide the button under "Series Overlap" over to the far right. Click "Finish."

Tips and warnings

  • The add-in software "TM Tornado" allows you to easily create tornado diagrams within Microsoft Excel, and is available as both a self-installing version or a zip version (see Resources).

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.