Show or hide chart labels in Excel

This article provides a detailed guide on how to display or hide chart labels in Excel 2013.

For example, imagine a chart created as follows:

1. To add detailed revenue for employees directly on the chart, follow these steps:

- Select the chart -> Design -> Add Chart Element -> Data labels -> choose the data placement, for example, select Outside End:

- The revenue figures display after the end of the data column:

2. Display additional Legend labels.

2.1 Show Legend labels.

- Select the chart -> Design -> Add Chart Element -> Legend -> choose the label placement, for example, select Top:

- The labels result in displaying the chart content:

2.2 Adjust the labels.

To adjust the labels -> click on the label name, for example, adjust the revenue label.

Step 1: Click on the label to be adjusted -> Format -> Shape Styles -> choose features to adjust the label frame:

+ Shape Fill: Color the background of the label frame.

+ Shape OutLine: Color the border of the label frame.

+ Shape Effects: Create effects for the label frame.

Step 2: Adjust the text content within the label:

Click on the label to be adjusted -> Format -> WordArt Styles -> choose the following formatting styles:

+ Text Fill: Color the text.

+ Text Outline: Color the text border.

+ Text Effects: Create effects for the text.

- In addition to the above method, double-click on the label name -> the Format Legend dialogue appears -> customize properties for the label in this dialogue:

Step 3: Change the font, font size for the label. If you find the label size too small or want to change the font, do the following:

- Right-click on the label -> Choose Font:

- The Font dialogue appears -> modify options for the label in the dialogue -> finally, click OK to finish.

- After performing the above steps, the result is as follows:

- If you don't want to display the Legend, click on the chart -> Design -> Add Chart Element -> Legend -> None to automatically remove labels from the chart:

Here is a detailed guide on how to show/hide labels on Excel 2013 charts.

Wishing you all success!