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
Choose a Template. Browse tornado chart templates and pick one that fits your data.
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.
Customize Colors & Style. Assign colors to positive and negative swings and match your brand. Adjust fonts and background.
Export. Export and drop it directly into PowerPoint, Google Slides, or reports.