Chart-specific Shortcut Keys

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

Command

Command Action

Keystrokes

Edit, then Add To Gallery

Adds the active assumption to the Distribution Gallery in the specified category

Alt+e, a

Parameters, then Show Cell References

Shows cell references instead of values when cell references are entered into parameter fields

Alt+m, c

Preferences, then Assumption

Opens the Assumption Preferences dialog for choosing a view and controlling chart display

Alt+p, a

Help, then Assumption Help

Displays online help about assumptions

Alt+h, a

Table 24. Forecast-specific Chart Menu Commands, All Supported Versions of Microsoft Excel

Command

Command Action

Keystrokes

Forecast, then Open Sensitivity Chart

Creates or displays a sensitivity chart for the active forecast

Alt+f, s

Forecast, then Fit Probability Distribution

Uses the default or currently selected distributions and ranking method to fit a distribution to the active forecast chart

Alt+f, f

Preferences, then Forecast

Opens the Forecast Preferences dialog for controlling chart display, distribution fitting specifications, and more

Alt+p, f

Help, then Forecast Help

Displays online help about the forecast chart

Alt+h, f

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