Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point.
- Click the data series or chart. To label one data point, after clicking the series, click that data point.
- In the upper right corner, next to the chart, click Chart Elements > Data Labels.
- To change the location, click the arrow, and choose an option.
- If you want to show your data label inside a text bubble shape, click Data Callout.
To make data labels easier to read, you can move them inside the data points or even outside of the chart. To move a data label, drag it to the location you want.
If you decide the labels make your chart look too cluttered, you can remove any or all of them by clicking the data labels and then pressing Delete.
Tip If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want.
Change what is displayed in the data labels
- Right-click the data series or data label to display more data for, and then click Format Data Labels.
- Click Label Options and under Label Contains, pick the options you want.
Tip You can change the look of the data labels, add connecting lines, create a custom data label, or change the position of the data labels.
Top of Page