Excel 2019 Bible

Part III: Creating Charts and Other Visualizations

FIGURE 21.2

Using the Chart Elements control in the Mini toolbar

The Chart Elements control enables you to select 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 navigation keys (or your mouse) to select the desired data point.

When a single data point is selected, the Chart Elements control will display the name of the selected element even

though it’s not actually available for selection from the drop-down list.

If you do a lot of work with charts, you may want to add the Chart Elements control to your Quick Access toolbar. That

way, it will always be visible regardless of which Ribbon tab is showing. To add the control to your Quick Access tool-

bar, right-click the down arrow in the Chart Elements control in the Ribbon and choose Add to Quick Access Toolbar.

Exploring the User Interface Choices for Modifying

Chart Elements

You have four main ways of working with chart elements: the Format task pane, the icons

that display to the right of the chart, the Ribbon, and the Mini toolbar.