Tornado Chart
The Tornado chart is an advanced version of the horizontal bar chart, specifically designed for sensitivity analysis and comparisons between two datasets. It is primarily used in scenario analysis, risk assessments, and financial modeling, as it allows for a clear visualization of how different variables impact the results. In this chart, the bars are placed in opposite directions (from left to right and vice versa), making it easier to compare two factors or variables in a single chart. Like other types of charts, Tornado charts offer various customization options that allow users to adjust their appearance and functionality according to specific needs. In the Menu option, you can configure settings such as axis modifications, colors, labels, legends, and more. The following sections will detail these options:
COMMON
The options vary depending on the type of chart. In the Tornado chart, the user has the following option in the "COMMON" section.
| Options | Values | Description |
|---|---|---|
| ROTATED | ON/OFF | This option allows the user to enable or disable chart rotation. If rotated, the X axis is positioned vertically, while the Y axis is oriented horizontally. |
AXIS Y
The options vary depending on the type of chart. In the Tornado chart, the user has the following option in the "AXIS Y" section.
| Options | Values | Description |
|---|---|---|
| REVERSE | ON/OFF | This option allows the user to reverse or not the Y axis. If reversed, the values of the Y axis are ordered from top to bottom. |
| VISIBLE | ON/OFF | This option allows the user to enable or disable the visibility of the Y axis. |
| TITLE | ON/OFF | This option allows the user to enable or disable the visibility of the title of the Y axis. |
| TITLE TEXT | Insert a title | This option allows the user to enter the desired title on the Y axis. |
| ENABLE ZOOMING | ON/OFF | This option allows the user to enable or disable zoom for the Y axis. |
AXIS Y (PANE 1)
The options vary depending on the type of chart. In the Tornado chart, the user has the following option in the "AXIS Y (PANE 1)" section.
| Options | Values | Description |
|---|---|---|
| ALWAYS SHOW ZERO LEVEL | ON/OFF | This option allows the user to enable or disable the visibility of the zero level of the axis in PANE 1. If this option is disabled, the visible range of the axis in PANE 1 will be determined based on the values plotted on the chart. |
| REVERSE | ON/OFF | This option allows the user to reverse or not the PANE 1. If reversed, the values are ordered from right to left. |
| GRID LINES | ON/OFF | This option allows the user to enable or disable grid lines to enhance the clarity of the chart's visual information. |
| VISIBLE | ON/OFF | This option allows the user to enable or disable the visibility of the axis in PANE 1. |
| TITLE | ON/OFF | This option allows the user to enable or disable the visibility of the title of the axis in PANE 1. |
| TITLE TEXT | Insert a title | This option allows the user to enter the desired title on the axis in PANE 1. |
| LOGARITHMIC SCALE | ON/OFF | This option allows the user to enable or disable a logarithmic scale to display the axis in PANE 1. |
| LOGARITHMIC SCALE BASE | Select a value | This option allows the user to define the base of the logarithmic scale. |
FORMAT
The Numeric Format section provides options for defining the numeric display formats for axis data in PANE 1.
| Options | Values | Description |
|---|---|---|
| FORMAT TYPE | Select a value | This option allows the user to define the format type for numerical values. |
| UNIT | Select a value | This option allows the user to specify the unit for converting numerical values. |
| PRECISION | Select a value | This option allows the user to define the number of decimals to display. |
| INCLUDE GROUP SEPARATOR | ON/OFF | This option allows the user to enable or disable separators between digit groups. |
| CURRENCY | Select a value | This option allows the user to define the currency symbol and format to be used. |
AXIS Y (PANE 2)
The options vary depending on the type of chart. In the Tornado chart, the user has the following option in the "AXIS Y (PANE 2)" section.
| Options | Values | Description |
|---|---|---|
| ALWAYS SHOW ZERO LEVEL | ON/OFF | This option allows the user to enable or disable the visibility of the zero level of the axis in PANE 2. If this option is disabled, the visible range of the axis in PANE 2 will be determined based on the values plotted on the chart. |
| REVERSE | ON/OFF | This option allows the user to reverse or not the PANE 2. If reversed, the values are ordered from right to left. |
| GRID LINES | ON/OFF | This option allows the user to enable or disable grid lines to enhance the clarity of the chart's visual information. |
| VISIBLE | ON/OFF | This option allows the user to enable or disable the visibility of the axis in PANE 2. |
| TITLE | ON/OFF | This option allows the user to enable or disable the visibility of the title of the axis in PANE 2. |
| TITLE TEXT | Insert a title | This option allows the user to enter the desired title on the axis in PANE 2. |
| LOGARITHMIC SCALE | ON/OFF | This option allows the user to enable or disable a logarithmic scale to display the axis in PANE 2. |
| LOGARITHMIC SCALE BASE | Select a value | This option allows the user to define the base of the logarithmic scale. |
FORMAT:
The Numeric Format section provides options for defining the numeric display formats for axis data in PANE 2.
| Options | Values | Description |
|---|---|---|
| FORMAT TYPE | Select a value | This option allows the user to define the format type for numerical values. |
| UNIT | Select a value | This option allows the user to specify the unit for converting numerical values. |
| PRECISION | Select a value | This option allows the user to define the number of decimals to display. |
| INCLUDE GROUP SEPARATOR | ON/OFF | This option allows the user to enable or disable separators between digit groups. |
| CURRENCY | Select a value | This option allows the user to define the currency symbol and format to be used. |
LEGEND
The options vary depending on the type of chart. In the Tornado chart, the user has the following option in the "LEGEND" section. A legend is a chart component that identifies chart series and data points.
| Options | Values | Description |
|---|---|---|
| SHOW LEGEND | YES/NO | This option allows the user to enable or disable the display of the legend. |
| POSITION | Select a value | This option allows the user to adjust the position and orientation of the legend. |
COLOR SCHEME
The options vary depending on the type of chart. In the Tornado chart, the user has the following option in the "COLOR SCHEME" section. This option allows the user to edit the colors of the specific palette for the selected color scheme type.
| Options | Values | Description |
|---|---|---|
| DIMENSIONS | Global/Local | This option provides the client with two choices for coloring dashboard item elements: Global - Applies consistent colors for identical values throughout the dashboard. Local - Utilizes a unique set of colors for each individual dashboard item. |
How to Apply the Settings of the 'Menu' Option
To apply the settings in a chart, first enter your username and password, then click the Login button. Once logged in, navigate to the report you want to run and double-click it to open. Next, click the Apply button to display the report. Once the report is loaded, click on the Menu option located at the top right of the chart; the icon is a gear. The available options for configuring the chart will then be displayed.
Tornado Chart
