Microsoft Office Tutorials and References
In Depth Information
SELECTING WITH THE KEYBOARD
When you move the mouse over a chart, a small “chart tip” displays the name
of the chart element under the mouse pointer. When the mouse pointer is
over a data point, the chart tip also displays the value of the data point. If you
find these chart tips annoying, you can turn them off. Select Tools
Options
and click the Chart tab in the Options dialog box. Remove the checkmark
from one or both items in the Chart tips section.
Some chart elements (such as a chart series, a legend, and data labels) consist of
multiple items. For example, a chart series is made up of individual data points. To
select a particular data point, you need to click twice: First click the series to select
it; then click the specific element within the series (for example, a column or a line
chart marker). Selecting the element enables you to apply formatting only to a
particular data point in a series.
You may find that some chart elements are difficult to select with the mouse. If
you rely on the mouse for selecting a chart element, it may take several clicks
before the desired element is actually 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 and Down arrow keys on your keyboard
to cycle among the chart’s elements. Again, keep your eye on the Name box (or on
the Chart Objects control) to determine which element is selected.
When a chart series is selected, use the Left and Right arrow keys to select an
individual data point within the series. Similarly, when a set of data labels is
selected, you can select a specific data label by using the Left or Right arrow key.
And when a legend is selected, you can select individual elements within the legend
by using the Left or Right arrow keys.
SELECTING WITH THE CHART TOOLBAR
The Chart Objects control on the Chart toolbar is a drop-down list that lets you
select a particular chart element from the active chart (see Figure 4-2). 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 one of the
other techniques to select the desired data point.
When a single data point is selected, the Chart Object control will display the
name of the selected element, even though it’s not actually available for
selection in the drop-down list.
Search JabSto ::




Custom Search