Tornado Chart Options

By default, the labels on the tornado chart and spider chart show the absolute values of the input variable’s test range (Figure 52, Tornado Chart) In the example figure, the absolute values are 46,800 and 53,200 for the top variable. You can use the Chart Options dialog to show the data labels in terms of the forecast’s test range, or show a difference amount from the base case (net impact) instead of an absolute amount.

Table 10. Tornado Chart Option Settings

ChartOption Settings

Chart with absolute test range values.

Tornado chart variable showing absolute values of the input variable's test range.

Chart with absolute forecast values.

Tornado chart variable showing absolute values of the target forecast.

Chart with test range difference values.

Tornado chart variable showing difference values of the input variable's test range.

Chart with forecast difference values.

Tornado chart variable show difference values of the target forecast.

You can also customize the chart legend labels from Upside and Downside to labels that suit your data better.

  To set tornado chart options:

  1. In the Tornado Analysis wizard, open the Options panel.

  2. Click Chart Options.

  3. Review and edit chart content as follows:

    • Indicate whether to show labels in terms of:

      • The test range of the Input variables (the default)

      • The Target forecast or cell

        Note:

        Refer to table above for examples.

    • Indicate whether to show labels as:

      • Absolute values (the default)

      • Differences from base case

  4. Optionally: enter custom legend labels for Downside (negative impact on the target) and Upside (positive impact).