To identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update automatically when changes are made to these values.
Step-by-step explanation:
Data labels make a chart easier to understand because they show details about a data series or its individual data points.
Add data labels to a chart
- 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 Add Chart Element Chart Elements button > Data Labels.
- Chart Elements > Data Labels > label choices
- 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.
Pie chart with data callouts
- 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.