To display additional label entries for all data points of a series, click a data label one time to select all data labels of the data series. Select the existing text and then type the replacement text. The cell values will now display as data labels in your chart.Ĭhange the text displayed in the data labelsĬlick the data label with the text to change and then click it again, so that it's the only data label selected. When you do that, the selected range will appear in the Data Label Range dialog box. When the Data Label Range dialog box appears, go back to the spreadsheet and select the range for which you want the cell values to display as data labels. You can use cell values as data labels for your chart.Ĭlick Label Options and under Label Contains, select the Values From Cells checkbox. Right-click the data series or data label to display more data for, and then click Format Data Labels.Ĭlick Label Options and under Label Contains, pick the options you want. 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.
