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.
