The following are basic steps for creating trend charts. The steps are illustrating using an example spreadsheet, Sales Projection.xls, shipped with Crystal Ball.
To create a trend chart:
Run a simulation in Crystal Ball.
To produce a meaningful trend chart, the simulation should have more than one forecast.
When the simulation stops, choose Analyze, then Trend Charts.
(If you are using Crystal Ball in Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Trend Charts.)
The Trend Charts dialog opens. If no trend charts have been created for the open workbooks or restored results files, the dialog is blank.
To create a new trend chart, click New.
The Choose Forecasts dialog opens.
By default, this dialog opens in a hierarchical Tree view. If you prefer, click the List button to change to List view.
Select two or more forecasts to include in the trend chart.
To select a forecast, check the box in front of its name. For this example, select all forecasts in the Sales Projection worksheet.
To select all forecasts in this example, you can click the Select All button or check the box in front of Sales Projection.xls or the Model tab name.
The trend chart is displayed as shown in Figure 42, Upward Trending Sales Figures, By Quarter.
As with overlay charts, you can change the scale and proportions of the chart by dragging its edges. For other customization possibilities, see the next section.