A tornado chart compares two groups side-by-side using mirrored bars. It highlights differences in size, proportion, or impact at a glance.
Drag the dimension to plot on the axis (e.g., Sub Category).
Drag the measure to analyze (e.g., Actuals, Plan).
Select the Tornado bar option from the Special charts section of the Chart Type dropdown menu.
Best suited for side-by-side analysis, Tornado charts help stakeholders instantly identify the categories that contribute to the overall outcome.
Here are the other settings that help you refine your Tornado chart.
Number
Configure number formatting (decimals, units)
Legend
Show/hide and customize the legends
Data Label
Show exact values for each data point
Trellis
Create small multiples using category split
Conditional Formatting
Apply color rules to highlight values
Sorting
Sort axis order
Ranking
Limit to top/bottom N categories
Last updated 8 months ago
Was this helpful?
