Selecting chart elements

Abstract

In this video, we’ll look at how to select chart elements.

After you’ve created a chart, you have several options for selecting and customizing individual chart elements.

First, you’re able to use the Chart Elements menu on the Format tab of the ribbon.

After you select a chart, this menu will contain a list of the main chart elements.

Once an element is selected, you’ll see the name displayed here.

you’re free to also click directly on a chart element to select.

For example, I can click directly on a bar in this chart to opt for data series.

With a chart selected, the up and down arrow keys will move through the main chart elements.

Watch the menu on the ribbon or the format task pane change as you go.

Some elements, like the data series, legend, and data labels can have sub-elements.

Use the right and left arrow keys to move between individual elements.

Again, with Excel 2016, you’ll need to hold down the control key.

For more chart shortcuts, watch the video on this topic.

If you right-click directly on an element, you’ll see the mini toolbar appear.

you might also select an element and use the keyboard shortcut Control + 1.

For more information on the Format Task Pane, see the video on that topic.