When you create a chart in PowerPoint, the default data labels often show only the value or the category name. This can make it hard for your audience to quickly grasp both the raw number and the proportional share of each data point. PowerPoint lets you customize data labels to display values, percentages, or both at the same time. This article explains how to add and format data labels in PowerPoint charts so you can show exactly what your audience needs.
Key Takeaways: Customizing Data Labels in PowerPoint Charts
- Chart Tools > Design > Add Chart Element > Data Labels > More Data Label Options: Opens the Format Data Labels pane where you can enable Value, Percentage, and other label content.
- Right-click a data series > Add Data Labels > Format Data Labels: A faster way to access the same pane for customizing label content and position.
- Label Options > Label Contains checkboxes: Allows you to show Value, Percentage, Category Name, Series Name, and even Leader Lines in a single label.
How Data Labels Work in PowerPoint Charts
Data labels are text elements attached to each data point in a chart. They can display the numeric value, the percentage of the total, the category name, or any combination of these. PowerPoint uses the same chart engine as Excel, so the options for customizing labels are extensive.
To show percentages, the chart must first be set to display a percentage axis or the data must be part of a 100% stacked chart. For other chart types like pie, doughnut, or bar charts, you can enable the percentage option directly in the label settings without changing the chart type. The percentage is calculated automatically based on the sum of all values in the selected data series.
You can control the number format, decimal places, separator character, and label position from the Format Data Labels pane. Labels can be placed inside the end of bars, outside the end, centered, or above data markers. Leader lines connect labels to their data points when labels are placed outside the chart area.
How to Add and Format Data Labels to Show Values and Percentages
The following steps work for all chart types in PowerPoint, including column, bar, line, pie, and doughnut charts. You can add labels to one data series at a time or to all series in the chart.
- Select the chart and open the Format Data Labels pane
Click the chart to select it. Right-click any data point in the series you want to label. Choose Add Data Labels from the context menu. Right-click one of the newly added labels and select Format Data Labels. The Format Data Labels pane opens on the right side of the window. - Enable Value and Percentage in Label Contains
In the Format Data Labels pane, make sure the Label Options tab is selected (the chart icon with bars). Under Label Contains, check the boxes for Value and Percentage. Uncheck any other boxes you do not want, such as Category Name or Series Name. The chart updates immediately to show both the raw number and the percentage for each data point. - Choose the label position and separator
Below the Label Contains section, find Label Position. Select Outside End for pie and doughnut charts, or Inside End for bar and column charts. For the separator between the value and percentage, click the Separator dropdown and choose a comma, semicolon, newline, or space. A newline separator places the value on one line and the percentage below it, which is often easier to read. - Format the number of decimal places
Scroll down in the Format Data Labels pane to Number. Click the arrow to expand the section. From the Category list, choose Number. Set the Decimal places value to 0 for whole percentages, or 1 for one decimal place. For currency values, choose the Currency category instead. Click Close when done. - Apply the same labels to other data series
If your chart has multiple series, repeat steps 1 through 4 for each series. You can also select the chart, go to Chart Tools > Design > Add Chart Element > Data Labels > More Data Label Options, and then choose the series from the dropdown at the top of the Format Data Labels pane.
Common Data Label Problems and How to Avoid Them
Labels overlap or are cut off
When you show both value and percentage, labels can become long and overlap, especially in dense charts. To fix this, change the label position to Inside End or Center for bars and columns. For pie charts, use Best Fit or manually drag individual labels. You can also reduce the font size of the labels by selecting them and using the Home tab font controls.
Percentage shows 0% for small values
If a data point is very small relative to the total, the percentage may display as 0% even when the value is not zero. This happens because the default percentage format has zero decimal places. In the Format Data Labels pane, under Number, set the decimal places to 1 or 2. The percentage will then show as 0.5% or 0.05% instead of 0%.
Labels show the same percentage for every point
This occurs when the chart is not using the correct data source. Make sure the chart is linked to a data table that contains the actual values. If you manually typed numbers into the chart data sheet, the percentages will be calculated from those numbers. Check the data by right-clicking the chart and choosing Edit Data. The values in the Excel-like sheet must add up to the total that you expect.
Value and percentage appear in the wrong order
PowerPoint does not allow you to reorder the items within a label. The order is fixed: Value, Percentage, Category Name, Series Name. If you need a specific order, create a custom label by entering text manually. Click a label twice (not double-click) to select it, then press F2 and type your own text. This overrides the automatic label for that one data point only.
PowerPoint Chart Types and Default Label Behavior
| Chart Type | Default Label Content | Percentage Available |
|---|---|---|
| Column / Bar | Value only | Yes, if data is part of a 100% stacked chart or if you enable it manually |
| Line | Value only | No, percentage is not available for line charts |
| Pie / Doughnut | Category name and value | Yes, available by default in Label Contains |
| 100% Stacked Bar | Percentage only | Yes, percentage is the default display |
| Scatter / Bubble | Value (X and Y) | No, percentage is not available for scatter or bubble charts |
For line, scatter, and bubble charts, you cannot display a percentage because these chart types do not represent parts of a whole. If you need percentages for a line chart, consider switching to a 100% stacked area chart or adding a secondary data series that shows the percentage manually.
You can now add data labels that show both values and percentages in any compatible PowerPoint chart. Use the Format Data Labels pane to control the content, position, and number format. For charts with many data points, reduce font size or change the separator to a newline to keep labels readable. If you work with financial data, consider using the Currency number format for values and the Percentage format with one decimal place for the proportion.