Tornado Chart

A tornado chart compares two groups side-by-side using mirrored bars. It highlights differences in size, proportion, or impact at a glance.

Chart setup to build a tornado chart:

1

Axis

Drag the dimension to plot on the axis (e.g., Sub Category).

2

Values parameter

Drag the measure to analyze (e.g., Actuals, Plan).

3

Chart type

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.

Tornado chart

Additional formatting options

Here are the other settings that help you refine your Tornado chart.

Feature	Description	Link
Number	Configure number formatting (decimals, units)	Charts - number settings
Legend	Show/hide and customize the legends	Charts - legend settings
Data Label	Show exact values for each data point	3.6. Data label customizations
Trellis	Create small multiples using category split	6. Trellis customizations
Conditional Formatting	Apply color rules to highlight values	9. Conditional formatting
Sorting	Sort axis order	Sorting data
Ranking	Limit to top/bottom N categories	Ranking for charts