To create a scatter chart:
When the simulation stops, choose Analyze, then Scatter Charts.
(If you are using Crystal Ball in Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Scatter Charts.)
The Scatter Charts dialog opens. If you have not yet created any scatter charts for the open workbooks or restored results files, the dialog is blank.
By default, this dialog opens in a hierarchical Tree view. If you prefer, click the List box to change the view from a tree to a list. For more information on the Choose Data dialog, click the Help button.
Check the box in front of an assumption or forecast name to include it in the scatter chart.
You can include up to 25 variables in a scatter chart. A warning message is displayed if you select more. If you try to create a scatter chart including an assumption but Store Assumption Values For Sensitivity Analysis was not checked in the Run Preferences dialog, check it, and then reset the simulation and run the simulation again.
To create a scatter chart in Scatter view, set a single assumption or forecast as the target. You do not need to set a target to display the chart in Matrix view.
To set a target, check the box in front of the target assumption or forecast, click its name, and then click Set As Target. In this case, Material 3 Reliability is set as the target and all assumptions are selected as secondary variables.
Click OK to create the new scatter chart shown in Figure 49, Scatter Chart for the Selected Target, Scatter View.
Only a portion of the chart is shown here. For a view of the complete chart, see Figure 47, Scatter chart, Scatter view, with Optional Lines and Correlations.
Here is some information about features shown in Figure 49, Scatter Chart for the Selected Target, Scatter View:
You can choose Preferences, then Chart Preferences to change the chart title.
To change the number of trials displayed in the plots, choose Preferences, then Scatter, then Criteria.
The Y-axis labels indicate the scatter chart target. Each X-axis label indicates the secondary variable plotted against the target.
The Ordered Fit line shows where the pairwise points would be displayed if they were sorted in ascending order. You can choose Preferences, then Chart Preferences, then Chart Type to change it to a Linear Regression line, which uses a least-squares technique to show the linear relationship of the points.
Auto is the default color for all symbols. With color set to Auto, plots are colored according to the combination of variables included in them:
You can use the Plot Sizer to increase or decrease the size of all plots and the amount of detail shown within them. To focus on a single plot, drag the Plot Sizer pointer toward the right to enlarge the plot, and then use the scroll bars to center it.
In Scatter view, plots move to fill available window space when they are resized. In Matrix view, plots keep the same NxN configuration. You can scroll to view any plots that are not currently displayed onscreen.
Frozen forecasts and assumptions are not included in scatter charts.