# How to create a tornado chart in Excel for sensitivity analysis

Build a tornado chart in Excel for sensitivity analysis: set low and high values for each input, use a stacked bar chart, and sort bars by swing to rank drivers.

A tornado chart in Excel shows which input variables in a spreadsheet model move a result the most, by displaying each variable's low and high values as horizontal bars sorted by swing. You build it from a small table of low and high outputs, plotting the two series as a stacked bar chart and then sorting the bars so the widest swing sits at the top or bottom. The page explains the data to prepare, the chart settings that produce the tornado shape, and how to read the finished diagram during a sensitivity analysis. 

## Prepare the low and high table 

A tornado chart starts with a table that lists each input variable beside its low and high result values. You change one input at a time in the spreadsheet model while holding the others at their base case, then record the output for the low and high ends. The gap between those two numbers is the swing, and the base case value sits somewhere inside that range. Keep the table free of formulas that link inputs to each other, so each row reflects a single change. 

## Plot the series as a stacked bar chart 

The tornado shape comes from plotting the low values and the swing as two stacked bar series on a horizontal axis. A plain bar chart of low and high values shows two separate bars, which does not produce the floating effect a tornado diagram needs. Add a helper column that subtracts the low value from the high value, then stack that column on the low series. Set the low series to no fill so only the swing remains visible as a bar. 

## Sort bars by swing and clean the axis 

Sorting bars by swing puts the variable with the widest range at one edge and the narrowest at the other, which gives the chart its tapered tornado outline. Excel plots bar categories in reverse order by default, so check the axis setting that controls category order before you read the ranking. Hide the low series fill, remove the chart border and gridlines you do not need, and label the value axis in the units of the output. A reader should see the ranking of input variables without extra decoration. 

## Tornado chart questions in Excel 

### How do I create a tornado chart in Excel? 

You create a tornado chart in Excel by building a table of low and high values for each input, adding a swing column, and plotting low and swing as a stacked horizontal bar chart. Setting the low series to no fill leaves floating bars, and sorting by swing completes the tornado shape. Excel has no tornado chart type, so the stacked bar chart is the route to build one. 

### Why use a tornado chart for sensitivity analysis? 

A tornado chart supports sensitivity analysis by ranking input variables according to how far each one moves the output between its low and high values. The ranking tells you which inputs deserve attention when you test a spreadsheet model. Bars are ordered by swing, so the variable with the widest range appears first and the effect of each input is visible at a glance. 

### What is the difference between a tornado diagram and a bar chart? 

A tornado diagram differs from a plain bar chart because each input variable gets one floating bar that spans its low to high range rather than a single value. The bars are sorted by swing and centered on a base case, which produces the tapered outline that gives the chart its name. A bar chart shows magnitudes, while a tornado diagram shows the spread of outcomes for each input. 

### Which values go into a tornado diagram for sensitivity analysis in Excel? 

The values in a tornado diagram are the output results from changing one input variable to its low and high ends while the other inputs stay at their base case. Each row of the table holds one input, its low result, its high result, and the swing between them. Testing inputs one at a time keeps the chart readable, and the swing column drives the sorting of the bars.
