Microsoft Office Tutorials and References
In Depth Information
Selecting with the keyboard
If these chart tips annoy you, you can turn them off. Choose File
Options and click
the Advanced tab in the Excel Options dialog box. Locate the Chart section and
deselect either or both of the check boxes labeled Show Chart Element Names On
Hover or Show Data Point Values On Hover.
Some chart elements (such as a series, legend, or data label) consist of multiple items. For
example, a chart series element is made up of individual data points. To select a particular data point,
click twice: First click the series to select it; then click the specific element within the series (such
as a column or a line chart marker). Selecting the element enables you to apply formatting to
only a particular data point in a series.
You might find that some chart elements are difficult to select with the mouse. If you rely on the
mouse for selecting a chart element, you might have to click it several times before the element
you want is selected. Fortunately, Excel provides other ways to select a chart element, and it’s
worth your while to be familiar with them.
Selecting with the keyboard
When a chart is active, you can use the up-arrow and down-arrow keys on your keyboard to
cycle among the chart’s elements. Again, keep your eye on the Chart Elements control, to ensure
that the selected chart element is what you think it is.
When a chart series is selected, use the left-arrow and right-arrow keys to select an individual
item within the series. Similarly, when a set of data labels is selected, you can select a specific
data label by pressing the left-arrow or right-arrow key. And, when a legend is selected, you can
select individual elements within the legend by using the left-arrow or right-arrow key.
Selecting with the Chart Element control
The Chart Element control is so useful, that it’s available in three locations:
h In the Chart Tools
Current Selection group of the Ribbon
h In the Chart Tools
Current Selection group of the Ribbon
h In the Mini Toolbar that appears when you right-click a chart element
This control displays the name of the selected chart element. Because it’s a drop-down control,
you can also use it to select a particular element in the active chart. Figure 134-2 shows the Chart
Element control in the Mini Toolbar.
This control lists only the top-level elements in the chart. To select an individual data point within
a series, for example, you need to select the series and then use the left and right arrow keys (or
your mouse) to select the data point.
Search JabSto ::

Custom Search