Chart Preference Shortcut Keys

Double-clicking in a chart area opens the Chart Preferences dialog.

Table 22 lists key combinations that can be used to cycle through settings available in the Chart Preferences dialog. Most of these commands work on the primary distribution — the theoretical probability distribution for assumptions, and the generated values for forecasts and overlay charts. For general keys used in most charts, see General Chart Shortcut Keys. For keys used in specific charts, see Chart-specific Shortcut Keys.

Table 22. Shortcut Keys for Chart Preferences, All Supported Versions of Microsoft Excel

Shortcut key

Command Equivalent

Description

Ctrl+d

View menu; Preferences, then chartname, then chartname Window, then View

Cycles through chart views — Frequency, Cumulative Frequency, Reverse Cumulative Frequency (for assumption and forecast charts)

Ctrl+b; Ctrl+g

Preferences, then Chart, then General, then Density

Cycles through bins or group interval values to adjust the number of data bins used to create the chart

Ctrl+l

Preferences, then Chart, then General, then Gridlines

Cycles through gridline settings: None, Horizontal, Vertical, Both

Ctrl+t

Preferences, then Chart, then Chart Type, then Type

Cycles through chart types: Area, Line, Column; for sensitivity charts: Bar (direction), Bar (magnitude), Pie (in Contribution To Variance view)

Ctrl+w

Preferences, then Chart, then General, then 3D Chart

Cycles between two-dimensional and three-dimensional chart display

Ctrl+m

Preferences, then Chart, then Chart Type, then Marker Lines

Cycles through central tendency marker lines: None, Mean, Median, Mode (except for sensitivity and trend charts)

Ctrl+n

Preferences, then Chart, then General, then Legend

Toggles the legend display on and off

Ctrl+p

Preferences, then Chart, then Chart Type, then Marker Lines, then Percentiles

Cycles through percentile markers: None, 10%, 20%,…90%

Ctrl+Spacebar

View menu; Preferences, then chartname, then chartname Window, then View

Cycles through window views when Microsoft Excel is not in Edit mode: Chart, Statistics, Percentiles, Goodness Of Fit (if distribution fitting is selected — except for trend charts), and Capability Metrics (if process capability features are activated)