Tornado Chart Maker

What Is a Tornado Chart?

A tornado chart is a sorted bar chart that shows which inputs move a result the most. Each bar is one variable, tested at a low and a high value while every other input stays at the base case, and the bars are sorted with the widest on top, so the chart narrows like a funnel cloud. It's also called a tornado diagram, tornado plot, tornado graph or sensitivity chart, and it's the standard way to show a one-way sensitivity analysis in a presentation. SlideModel's free Tornado Chart Maker draws one from your numbers and downloads it as an editable PowerPoint slide.

A vertical line marks the base case. For each input, one bar runs from the base case to the result when that input is at its low value, and another runs to the result at its high value. The total width of a row is its swing: how far that one input can move the outcome. Sorting by swing puts the inputs that matter most at the top.

How to Read a Tornado Chart

1. Start at the top. The widest bar is the input your result is most sensitive to. Those are the assumptions to research, negotiate or hedge first.
2. Compare the two sides. A bar that reaches further right than left means the upside from that input is bigger than the downside.
3. Check the colors. Green means a better outcome and red a worse one, whichever direction the input moved. A higher cost that lowers profit is red.
4. Read the ranges. The text under each label shows the low and high values that were tested. A chart is only as fair as those ranges.

Tornado Chart Example: NPV Sensitivity

The NPV example in the tool tests eight inputs of a product launch against a base-case NPV of $12.4M. The numbers are illustrative. These are the four widest rows:

Input	Tested range	NPV at low	NPV at high	Swing
Unit price	$90 to $110	$6.1M	$18.7M	$12.6M
Sales volume	80k to 120k units	$7.9M	$16.9M	$9.0M
Unit cost	$44 to $56	$15.8M	$9.0M	$6.8M
Discount rate	8% to 12%	$14.6M	$10.4M	$4.2M

Unit price sits on top: a 10% change either way moves NPV by about $6.3M, more than any other input. Unit cost runs the other way, because a higher cost lowers NPV, so its bar for the high cost is red and points left. The other four inputs, from launch delay to marketing spend, each swing NPV by less than $4M, which is the kind of detail a footnote can carry when the slide shows only the top rows.

When to Use a Tornado Chart

Use a tornado chart when one result depends on several uncertain inputs and your audience needs to know which of them matter. It turns a sensitivity table into a single picture, so it shows up wherever a forecast has to be defended in a meeting:

Presentation	Output tested	Typical inputs
Business case or investment committee deck	NPV, IRR, payback period	Price, volume, unit cost, discount rate
Project risk review	Total cost, finish date	Cost estimates, durations, risk events
Pricing or strategy recommendation	Profit, margin	Price, churn, acquisition cost
Startup pitch deck or board update	Revenue, runway, break-even month	Growth rate, burn, conversion
Engineering or research report	A model's output	Parameters and assumptions

If the question is how a total builds up, or how two groups compare, another chart fits better. SlideModel's guide to chart types for presentations covers how to choose.

How to Make a Tornado Chart

1. Pick the output and the base case. For example, a project NPV of $12.4M with every input at its expected value.
2. Test each input at a low and a high value. Change one input at a time, record the result, then reset it. Use realistic ranges, such as the 10th and 90th percentiles, or the same plus or minus percent for every input.
3. Paste the results here. The tool sorts the rows by swing, centers them on the base case, colors them by outcome and labels the ranges. If you only have changes from the base case, or percents, switch the table to read those instead.
4. Download. Take a PNG, or download a PowerPoint slide where every bar and label is an editable shape, ready to drop into your deck.

How to Present a Tornado Chart in a Slide Deck

A tornado chart works best on a slide of its own, with a title that states the finding instead of naming the chart. "Price and volume drive most of the NPV risk" tells the room what to look at; "NPV sensitivity" leaves them to work it out.

1. Write the takeaway as the slide title. Use the subtitle for the output and the base case, such as "NPV in $M, base case $12.4M".
2. Show the top 8 to 10 inputs. Test everything, chart what matters and name the rest in the footnote. Set Show to Top 8 or Top 10 and the tool hides the smaller rows and writes that footnote for you.
3. Keep the base case and the tested ranges visible. "Plus or minus what?" is usually the first question, and the range under each label answers it.
4. Explain the colors once. The legend says which color is better and which is worse. Say it out loud when the slide comes up.
5. Put the response on the next slide. The chart shows where the risk is, not what to do about it. Follow it with a risk and mitigation slide or the decision it supports.

In a business case presentation or a financial presentation, the tornado chart usually follows the base-case numbers and comes before the scenarios, so the audience sees which assumptions the scenarios are built on.

Tornado Chart vs. Butterfly Chart

Both use bars that extend left and right from a center line. A tornado chart ranks the influence of several inputs on one result, so it's always sorted by size. A butterfly chart compares two groups across the same categories, such as women and men by age band or this year and last year by region, and usually keeps the categories in their natural order. Switch the tool to Butterfly to make one. SlideModel's guide also shows how to build a butterfly chart in PowerPoint by hand.

Tornado Diagrams in Risk Management and the PMP Exam

In project risk management, the tornado diagram is the usual way to show sensitivity analysis during quantitative risk analysis: which risks or uncertain estimates move cost or schedule the most. The longer the bar, the greater the sensitivity, so the top bars are where risk responses should focus. That's why it appears in PMP exam prep alongside expected monetary value, decision trees and Monte Carlo simulation. Load the project cost example, which uses total project cost as the output with "higher is better" turned off, because lower cost is better.

Tornado Chart Best Practices

Practice	Why
Sort by swing	Alphabetical or model order hides the message
Color by outcome, not direction	Readers see good and bad at a glance
Show the tested ranges and the base case	The chart is only as fair as its ranges
Keep it to 4 to 12 variables	Test everything, chart the top ten, mention the rest in a footnote
Use comparable ranges	Mixing ±5% and ±50% makes the ranking meaningless

The checks under the preview flag these as you work, and most come with a one-click fix.

Limitations

A tornado chart varies one input at a time, so it doesn't show what happens when two inputs move together, such as a price cut that also raises volume. For correlated inputs, run scenarios or a Monte Carlo simulation and use the tornado chart as the summary of individual sensitivities. To compare a few whole scenarios across many inputs at once, a parallel coordinates plot draws each scenario as one line.

Tornado Charts in Excel and PowerPoint

Neither Excel nor PowerPoint has a tornado chart type. The usual workaround is a stacked bar chart with negative values for one side or a hidden spacer series, a custom number format such as 0;0 to hide minus signs, a reversed category axis and manual sorting. It takes half an hour or more and breaks when the data changes.

This maker does that work for you. Paste the same numbers and the chart is drawn on a 16:9 slide immediately, so what you see is what you download. The PowerPoint export writes real shapes rather than a picture, so you can restyle the chart to match your presentation, and the slide's speaker notes keep your data so you can paste it back into the tool to update the chart. For a designer-made slide around it, browse SlideModel's chart templates, editable in PowerPoint, Google Slides and Keynote.