You want data labels on your PowerPoint chart to show values from specific cells in your Excel worksheet, but the default data label options only show series values, category names, or percentages. PowerPoint’s chart engine reads data from an Excel data sheet, and the standard label choices do not let you pull text from arbitrary cells. This article explains how to use the Value From Cells feature to link each data point’s label to a separate range of cells, giving you full control over the text that appears on each bar, column, or pie slice.
Key Takeaways: Reference a Custom Cell Range for Data Labels
- Format Data Labels > Label Options > Value From Cells: Lets you select a cell range in the linked Excel sheet to use as label text.
- Chart Tools > Design > Select Data: Opens the data source dialog where you can verify or change the Excel range used by the chart.
- Right-click a data point > Add Data Labels > Add Data Labels: Inserts default labels before you switch them to Value From Cells.
How PowerPoint Data Labels Normally Work
When you create a chart in PowerPoint — either by inserting a chart directly or by pasting one from Excel — PowerPoint opens an embedded Excel worksheet that holds the chart’s source data. By default, data labels can display the series value, the category name, the series name, or a combination of those. None of these options lets you show a custom string, such as a regional name, a code, or a calculated note, without altering the chart’s actual value or category structure.
The Value From Cells option was added to Excel charts several versions ago and is also available in PowerPoint charts because PowerPoint shares the same charting engine. This option reads text from a separate column or row in the same Excel data sheet and assigns each cell’s content to the corresponding data point. The cell range must have the same number of cells as there are data points in the chart series.
Steps to Set Data Labels From a Cell Range
The process requires an existing chart in PowerPoint and an Excel data sheet that already contains the custom labels you want to use. You will add default data labels first, then replace them with the cell reference.
- Insert or select the chart
Click the chart on your slide to select it. If you have not added a chart yet, go to Insert > Chart, choose a chart type, and click OK. PowerPoint will open an Excel window with sample data. - Add the custom labels to the Excel data sheet
In the Excel window that appears, locate an empty column or row. Type the label text you want for each data point. Make sure the number of cells matches the number of data points in your chart series. If your chart has four bars, you need four cells, one per bar. - Add default data labels to the chart
Right-click any data point in the chart series. From the context menu, choose Add Data Labels then Add Data Labels. Default labels — usually the series value — will appear next to each data point. - Open the Format Data Labels pane
Right-click any of the newly added data labels and select Format Data Labels. The pane opens on the right side of the PowerPoint window. - Enable Value From Cells
In the Format Data Labels pane, under Label Options, check the box for Value From Cells. A small dialog titled Excel Data Range appears. Click inside the range selector box, then switch to the open Excel data sheet and select the cells that contain your custom labels. Click OK. - Disable unwanted default options
Uncheck any other label options you do not want, such as Value, Category Name, or Series Name. Only the Value From Cells text will remain on the chart. - Close the pane and adjust label position
Click outside the chart to apply the changes. You can reposition individual labels by dragging them, or change all label positions from the Label Position drop-down in the Format Data Labels pane.
Common Mistakes and Limitations
The Value From Cells option is grayed out
This happens when no data labels are currently applied to the chart series. You must add at least one data label to the series before the Value From Cells checkbox becomes active. Add default labels first, then open the Format Data Labels pane.
Labels show #REF! or an error
The cell range you selected no longer exists or the Excel sheet was closed and the reference was lost. Reopen the Excel data sheet by right-clicking the chart and choosing Edit Data. Verify that the custom label column is still present and that the range you selected in step 5 is correct. If the range was deleted, select a new range.
Labels do not update when the source cells change
PowerPoint charts do not update automatically when you edit the embedded Excel sheet unless you trigger a refresh. After changing the text in the Excel data sheet, right-click the chart and select Edit Data. Close the Excel window. The chart labels will refresh to show the new cell values.
The range selector does not appear when using PowerPoint on a Mac
The Value From Cells feature is available in PowerPoint for Microsoft 365 on Windows and Mac. On Mac, the dialog may appear differently. After checking Value From Cells, a field labeled Select Range appears. Click the field, then select the cells in the embedded Excel sheet. Press Return to confirm.
PowerPoint Data Label Options: Value From Cells vs Standard Labels
| Item | Value From Cells | Standard Label Options |
|---|---|---|
| Source of text | Any cell range in the same Excel data sheet | Series values, category names, series names, or percentages |
| Custom text allowed | Yes, any string you type in the cells | No, only predefined numeric or name fields |
| Number of data points | Must match the selected cell range exactly | Always matches the chart series |
| Update behavior | Manual refresh required after editing cells | Updates automatically when source data changes |
| Available in | PowerPoint for Microsoft 365 and PowerPoint 2019 or later | All PowerPoint versions |
The Value From Cells option gives you the ability to show any text — including notes, codes, or formatted strings — without changing the chart’s underlying data structure. Standard labels are limited to the numeric or category data that drives the chart itself.
You can now create PowerPoint charts that display custom data labels pulled directly from a cell range in the embedded Excel sheet. After setting up the labels, try using the Label Position setting to place them above bars or inside pie slices for better readability. For presentations that require frequent updates, consider linking the chart to an external Excel workbook so the labels refresh when the source file changes.