The following tables list shortcut keys for specific charts. For general keys used in most charts, see General Chart Shortcut Keys. For chart preferences keys, see Chart Preference Shortcut Keys.
Tables:
Table 23, Assumption-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 24, Forecast-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 25, Overlay-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 26, Sensitivity-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 27, Trend-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 28, Scatter-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 23. Assumption-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 24. Forecast-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Table 25. Overlay-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Command | Command Action | Keystrokes |
---|---|---|
Overlay, then Choose Forecasts | Displays the Choose Forecasts dialog to add or remove forecasts from the active overlay chart | Alt+o, c |
Overlay, then Remove All | Removes all forecasts from the active overlay chart | Alt+o, r |
Overlay, then Fit Probability Distribution | Uses the default or currently selected distributions and ranking method to fit a distribution to all forecasts on the active overlay chart | Alt+o, f |
Preferences, then Overlay | Opens the Overlay Preferences dialog for controlling chart display and distribution fitting specifications | Alt+p, o |
Help, then Overlay Help | Displays online help about the overlay chart | Alt+h, o |
Table 26. Sensitivity-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Command | Command Action | Keystrokes |
---|---|---|
View, then Contribution To Variance Chart | Displays the sensitivity chart in terms of percentage of variance contributed by each assumption | Alt+v, c |
View, then Rank Correlation Chart | Displays the sensitivity chart in terms of rank correlation of the assumptions in their effect on the forecast | Alt+v, r |
View, then Sensitivity Data | Displays contribution to variance and rank correlation sensitivity measures for each assumption | Alt+v, s |
Sensitivity, then Choose Target Forecast | Opens the Choose Forecast dialog so you can choose a forecast for sensitivity analysis | Alt+s, t |
Sensitivity, then All Assumptions | Uses all assumptions in creating the sensitivity chart | Alt+s, a |
Sensitivity, then Choose Assumptions | Displays the Choose Assumptions dialog so you can choose one or more assumptions for the sensitivity chart | Alt+s, c |
Sensitivity, then Open Scatter Chart | Opens a scatter chart using the current target forecast and assumptions | Alt+s, s |
Preferences, then Sensitivity | Opens the Sensitivity Preferences dialog for choosing a view, controlling chart display, and more | Alt+p, s |
Help, then Sensitivity Help | Displays online help about the sensitivity chart | Alt+h, s |
Table 27. Trend-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Command | Command Action | Keystrokes |
---|---|---|
View, then Centered On Median | Displays certainty bands centered on the median of each forecast value | Alt+v, m |
View, then Cumulative | Displays certainty bands anchored at the lower end of the forecast range; shows the certainty that the forecast values will be at or below a given value | Alt+v, c |
View, then Reverse Cumulative | Displays certainty bands anchored at the higher end of the forecast range; shows the certainty that the forecast values will be at or above a given value | Alt+v, r |
Trend, then Choose Forecasts | Opens the Choose Forecasts dialog so you can choose forecasts to use in the trend chart | Alt+t, f |
Trend, then Remove All | Removes all forecasts from the active trend chart | Alt+t, r |
Preferences, then Trend | Opens the Trend Preferences dialog for choosing a view and controlling chart display | Alt+p, t |
Help, then Trend Help | Displays online help about the trend chart | Alt+h, t |
Table 28. Scatter-specific Chart Menu Commands, All Supported Versions of Microsoft Excel
Command | Command Action | Keystrokes |
---|---|---|
View, then Scatter View (1xN) | Plots selected assumptions and/or forecasts against a target assumption or forecast | Alt+v, s |
View, then Matrix View (NxN) | Plots selected assumptions and/or forecasts against each other | Alt+v, m |
Scatter, then Choose Data | Opens the Choose Data dialog so you can choose assumptions and forecasts to use in the scatter chart | Alt+s, d |
Scatter, then Remove All | Removes all assumptions and forecasts from the active scatter chart | Alt+s, r |
Preferences, then Scatter | Opens the Scatter Preferences dialog for choosing a view and controlling chart display | Alt+p, s |
Help, then Scatter Help | Displays online help about the scatter chart | Alt+h, t |