How to select an invisible element in the chart

Excel 365
Some chart elements are hard to find for customization, or they are not visible at all. For example, added or updated data series may not be visible due to chart settings: located in an invisible data range, displayed with invisible markers, with disabled fill color, or because of the background image:
Invisible elements in chart Excel 365

You can select any chart element for customization using the ribbon tab command or from the Format *** pane.

Using the ribbon tab

   1.   Select the chart to display the Chart Design and Format tabs:

Chart Design and Format tabs in Excel 365

   2.   On the Chart Format tab, in the Current Selection group, click the arrow of the Chart Elements dropdown list, then select the chart element you need.

For example:

Select elements in Chart Format tab Excel 365

If you need to open the Format *** pane to customize the selected element, click the Format Selection button in the Current Selection group:

Format Selection button in Excel 365

Using the Format pane

   1.   Open the Format *** pane for any of the chart elements.

For example, right-click the chart plot area and select Format Plot Area... in the popup menu:

Format Plot Area in popup menu Excel 365

   2.   In the Format *** pane, click the arrow next to *** Options (Plot Area Options in this example) and choose the element you need to customize from the dropdown list:

Select elements in Format pane Excel 365

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more