The Specify Input Variables panel of the Tornado Chart tool specifies the assumptions, decision variables, and precedents to include in the tornado and spider charts. You can include any value cell in the tornado chart calculations. However, the cells are usually:
Assumptions — Cells defined as assumptions in Crystal Ball.
Decision variables — Cells defined as decision variables in Crystal Ball.
Precedents — All cells within the active spreadsheet that are referenced as part of the formula or a sub-formula of the target cell. Precedents for this tool are handled differently than standard Microsoft Excel precedents in that they cannot trace beyond the active spreadsheet. Therefore, you can only use precedents on the active spreadsheet as input variables.
The Specify Input Variables panel includes these settings:
Input Variable List — Lists all the variables selected for the tornado and spider charts.
Add Assumptions — Adds all assumptions from all open worksheets to the input variable list.
Add Decision Variables — Adds all decision variables from all open worksheets to the input variable list.
Add Precedents — Adds all precedents of the target cell from all open worksheets to the input variable list.
Add Range — Lets you select a range of cells from the open worksheet to add to the input variable list. If you click this button, an Input panel opens, asking you to enter a cell range or to select a range of cells from the spreadsheet. You must click OK to accept the selected range.
Remove — This button removes the selected variable from the input variable list.
Remove All — Removes all of the items from the input variable list.
Back — Returns to the Specify Target panel.
Next — Opens the Specify Options panel.
When settings are complete, click Next to open the Specify Options panel.