@Risk: Cell references in Tornado Graphs (RiskResultsGraph)

RiskResultsGraph( ) displays both input names and cell locations in some @RISK versions, and this behavior cannot be changed. For a one-time need, use Browse Results. • Tornado graphs there show only input names. For automated reporting, Quick Reports (and Custom Reports in @RISK 7.0.0+) also omit cell references in tornado charts. Starting in @RISK 6.2.0, you can generate tornado graphs through VBA. You can also place your chart-generation code in a macro and register it in Simulation Settings » Macros to run automatically at the end of each simulation.

déc. 4, 2025
Knowledge

Titre

Answer

Applies to: @RISK 5.x and Up

Cell References in a tornado graph - RiskResultsGraph( )

RiskResultsGraph( ) displays both input names and cell locations in some @RISK versions, and this behavior cannot be changed.

For a one-time need, use Browse Results.

Tornado graphs show only input names.
Customize the graph as desired, right-click to Copy Graph, then paste it into your worksheet.

For automated reporting, Quick Reports (and Custom Reports in @RISK 7.0.0+) also omit cell references in tornado charts.

Starting in @RISK 6.2.0, you can generate tornado graphs through VBA.

These charts label bars with input names and allow extensive customization.
- See the example included with the software.
To get started, open Help » Developer Kit (XDK) » Automation Guide, especially the section Displaying Graphical Results of a Simulation.
Be sure to set the required library references (see Setting Library References).

You can also place your chart-generation code in a macro and register it in Simulation Settings » Macros to run automatically at the end of each simulation.

All Articles about Tornado Charts

Attachments:
KB1264_GraphsFromVBA.xlsm

Nom de l'URL

cell-references-in-tornado-graphs-riskresultsgraph