Adding and Removing Assumptions and Forecasts

When you create a new scatter chart, all assumptions and forecasts in the model are available to use as targets, secondary variables, or matrix variables. Some variables may be closely related to the target or other elements in the matrix and some variables may be completely unrelated.

You can include up to 25 variables, but scatter charts are easier to interpret with smaller numbers of variables. It can be helpful to edit the chart, removing some secondary variables or matrix elements that show little relationship to each other or a target and adding others that might relate more closely.

In complex models with lots of assumptions and forecasts, you might find it helpful to begin by creating a sensitivity chart and then creating a scatter chart from the data included within it. For example, you could open a forecast chart and choose Forecast, then Open Sensitivity Chart to view a sensitivity chart. Then, within the sensitivity chart, you could choose Sensitivity, then Open Scatter Chart to create a scatter chart using that forecast as the target.

  However you create a scatter chart, you can follow these steps to remove or change the variables (forecasts and assumptions) included in it:

  1. In the Scatter Chart window, choose Scatter, then Choose Data.

    The Choose Data dialog opens.

  2. Check the assumptions or forecasts to add to the scatter chart and uncheck those to remove from the chart.

  3. If you want, set a different target.

    Click the variable name and then click Set As Target.

  4. Click OK to display the edited chart.

If you set a new target or remove a target, the view changes when the chart opens again. If you set a new target, the scatter chart is displayed in Scatter view with selected variables plotted against the new target. If you remove an existing target and do not set a new one, the chart is displayed in Matrix view.