You can use several commands on the Analyze menu and Crystal Ball toolbar to:
If you are using Crystal Ball in Microsoft Excel 2007 or later, choose Analyze, then View Charts and then choose a command.
You can click a chart button (shown below) to open all windows for that chart type, or use one of the following commands:
Analyze, then Open Selected Cells (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Open From Selection) — Opens charts for all assumption and forecast cells in the selected range. [xxx confirm command names; may be the same now]
Analyze, then Assumption Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Assumption Charts) — Opens a dialog so you can choose which assumption charts to open or close.
Analyze, then Forecast Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Forecast Charts) — Opens a dialog so you can choose which forecast charts to open or close.
Analyze, then Overlay Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Overlay Charts) — Opens a dialog so you can choose which overlay charts to open or close, create, or delete.
Analyze, then Trend Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Trend Charts) — Opens a dialog so you can choose which trend charts to open or close, create, or delete.
Analyze, then Sensitivity Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Sensitivity Charts) — Opens a dialog so you can choose which sensitivity charts to open or close, create, or delete.
Analyze, then Scatter Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Scatter Charts) — Opens a dialog so you can choose which scatter charts to open or close, create, or delete.
Analyze, then OptQuest Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then OptQuest Charts) — If OptQuest is available and you have just run an optimization, opens a dialog so you can choose which OptQuest charts to open or close, create, or delete.
Analyze, then Predictor Charts (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Predictor Charts) — If you have just run an time series forecast, opens a dialog so you can choose which Predictor charts to open or close, create, or delete.
Analyze, then Close All (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Close All) — Closes all chart windows and clears the current simulation results and stored results from memory.
Analyze, then Cascade (In Microsoft Excel 2007 or later, choose Analyze, then View Charts, then Cascade) — Neatly stacks all windows in front of Microsoft Excel.
Note: | OptQuest and Predictor chart buttons are not available in Microsoft Excel 2003. |
See Setting Speed Preferences for ways to control whether and how often chart windows display and redraw.