Tornado Chart Maker, Create Sensitivity Analysis Charts Free

Built for DCF valuations, M&A models, budget assumption testing, and any time you need to show which variable moves your forecast most. Free to start.

Everything You Need to Create Tornado Charts

  • Easy Data Input: Paste from Excel or Google Sheets. One row per variable with a low and high value. AECharts sorts and sizes the bars automatically.
  • Auto-Sorted Bars: Variables are ranked automatically by the size of their swing, largest at top, so the most important assumption is always obvious.
  • Export Straight to PowerPoint: Export and drop it directly into PowerPoint, Google Slides, or reports.
  • Custom Colors: Color positive and negative swings separately. Match your brand palette or use a built-in color scheme.
  • Real-time Preview: See every change instantly. What you see in the editor is exactly what exports.
  • No Design Skills Needed: Templates are professionally designed. Paste your data, adjust colors, and export, most users are done in under a minute.

When to Use a Tornado Chart

Tornado charts work best when you're testing how sensitive one output is to several input assumptions, and want to show which ones matter most at a glance.

  • DCF Valuation Sensitivity: Show how discount rate, terminal growth, and margin assumptions each move enterprise value. Standard in investment committee memos.
  • M&A Deal Sensitivity: Show which deal assumptions, synergies, multiple, financing cost, swing the return most. Used in board decks and IC presentations.
  • Budget Assumption Testing: Show which line items (headcount cost, pricing, churn) move the annual budget most if they miss plan.
  • Product Pricing Analysis: Show which pricing or cost assumptions move margin the most before a pricing decision.
  • Risk Assessment: Rank risk factors by potential impact on a project or forecast outcome.
  • Scenario Planning: Communicate which inputs are worth stress-testing further versus which barely move the outcome.

Tornado Chart vs Bar Chart

Both use horizontal bars, but they answer different questions.

Tornado Chart

  • Best for: Ranking how much each variable swings one output metric.
  • Strength: Auto-sorted by impact, so the reader sees what matters most without hunting for it.
  • Use when: Sensitivity analysis, valuation, risk ranking.

Bar Chart

  • Best for: Comparing independent values across categories.
  • Strength: Familiar and flexible for any category comparison.
  • Use when: Rankings, comparisons, or time series that aren't about sensitivity.

AECharts supports both. Switch between chart types to find the right format for your data.

How to Create a Tornado Chart

  1. Choose a Template. Browse tornado chart templates and pick one that fits your data.

  2. Paste Your Data. Copy from Excel or Google Sheets. One row per variable with a low and high value. AECharts sorts and builds the chart automatically.

  3. Customize Colors & Style. Assign colors to positive and negative swings and match your brand. Adjust fonts and background.

  4. Export. Export and drop it directly into PowerPoint, Google Slides, or reports.

Frequently Asked Questions About Tornado Charts