Excel Pie Chart: Show Values, Percentages, or Both

Yes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add Chart Element > Data Labels and pick a label position. To control whether labels show the underlying values, percentages, category names, or a combination, right-click a label and select Format Data Labels.

What Excel pie-chart labels can show

A pie chart’s slices represent parts of one whole, but the labels can communicate that information in several ways. The actual value is the number in your worksheet, such as 42 orders. The percentage is that value divided by the total of all plotted values, such as 28% of orders. A category name identifies the slice, such as North or Online. You can show one of these details or combine them, depending on what readers need.

For example, a label could read “Online, 42, 28%.” That gives a reader the category, count, and share without requiring a separate legend. It can also make a small chart crowded, so more label detail is not automatically better. If the chart’s purpose is to compare exact counts, show values; if it is to communicate each category’s share, show percentages. For many reports, showing both is useful when the number of slices is modest.

Excel does not change the source data when you add labels. It displays information from the chart’s data range, with percentages calculated from the values represented in the pie. Changing a label’s number format changes how it is displayed, not the underlying worksheet value.

Prepare the data for a clear pie chart

A pie chart works best with one series of nonnegative values and a short list of categories. Put category names in one column and their corresponding values in the next. For instance, cells A1:B4 might contain a heading row followed by Online—42, Store—35, Phone—18. Select the category and value cells, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. The chart represents the values as portions of their combined total.

Check the source range before adding labels. A heading accidentally included as a value, blank rows, or unrelated columns can make the chart confusing. Pie charts are intended for a single data series; if you have multiple measures or want to compare the same categories across periods, a bar or column chart is often a better fit. A pie chart also cannot communicate negative values as meaningful portions of a whole. Zero values have no visible slice, and a set of values totaling zero cannot produce useful proportions.

Use category names that are concise enough to fit beside or inside slices.
Keep the number of categories manageable; many narrow slices are difficult to compare.
Check that the plotted values match the intended total, especially if the source range includes hidden or extra rows.

Add values to an existing pie chart

On Windows, click the chart so that the chart tabs appear on the ribbon. Choose Chart Design > Add Chart Element > Data Labels, then select a position such as Outside End, Inside End, or Center. The choice adds labels, but Excel’s initial label contents may not be the exact combination you want. Use the formatting pane to specify them.

Right-click one of the chart’s data labels and choose Format Data Labels. If labels are not yet present, first add them using the ribbon steps above.
In the Format Data Labels pane, find Label Options. Select Value to show the worksheet numbers.
Select Percentage if you also want each slice’s share of the pie. Clear any options you do not want, such as Category Name, to keep the label concise.
Close the pane when the labels look right. If needed, click a label once to select all labels, then click again to select an individual label for a one-off adjustment.

To show only numbers, select Value and clear Percentage. To show a category and its number, select Category Name and Value. The available options are shown in the Format Data Labels pane; the exact arrangement of controls can vary slightly with window size and Excel updates.

Choose the label position and number format

Label position affects readability. Inside End or Center places text on the slice, which can work for large slices with strong contrast. Outside End puts labels beyond the pie and is often easier to read when slices are narrow. Excel may draw leader lines between outside labels and slices; in the Format Data Labels pane, the leader-line option can be used when available. Dragging a label can also help with a specific collision, though the chart may need further adjustment after data changes.

To change how values appear, use the Number section in the Format Data Labels pane. For example, a count might be displayed with no decimal places, while currency should use an appropriate currency format. If the source cells already have the intended format, the labels may follow it; if they do not, check whether the labels are linked to the source formatting and adjust the number format for the labels. A displayed value rounded to one decimal place can look different from the full-precision number in the worksheet, even though the underlying chart value has not changed.

Percentage labels are also a formatting choice. You can set the number of decimal places so labels read 28% rather than 28.4%, for instance. Avoid unnecessary decimal detail: a pie chart is a visual summary, and a long string of decimals can be harder to interpret than the chart itself.

Show values, percentages, or both?

The right choice depends on the question the chart answers. Values are useful when the reader needs the actual number of items, dollars, or units. Percentages are useful when the focus is the composition of the total, especially if the total itself changes between reports. Showing both helps when readers need to understand scale as well as share, but it takes more space and can make labels overlap.

Imagine a chart of 150 customer responses: 75, 45, and 30. The slices represent 50%, 30%, and 20%. A value-only chart tells readers how many responses each group received; a percentage-only chart emphasizes the distribution. Showing both makes the relationship explicit. If comparing two months with different totals, percentages can make the shares easier to compare, while values reveal whether the overall volume rose or fell. In that situation, a separate total or a different chart type may be needed to tell the full story.

A related misconception is that a pie-chart percentage is a value stored in the worksheet. It is normally calculated for display from the plotted slice and the chart’s total. If you need percentages in worksheet cells for further calculations, calculate them in the data table separately; chart labels do not create those worksheet results.

Fix labels that are missing, crowded, or incorrect

If values do not appear, first make sure you added data labels and then selected Value in Format Data Labels. A chart can have labels that show only category names or percentages, so merely seeing text around the pie does not confirm that values are enabled. Also inspect the chart’s source range: the chart can only label the data it is actually plotting.

If labels overlap, try these practical fixes:

Choose Outside End instead of placing every label inside the slices.
Show fewer details, such as values without category names, or reduce percentage decimal places.
Enlarge the chart or its plot area, or make the chart wider to give labels more room.
Move a label manually or use a legend for category names when labels are crowded.
Group very small categories only when that grouping is meaningful and accurately represented in the source data.

If a label seems to show the wrong number, compare it with the worksheet cell and verify the plotted range and number format. A displayed rounded number may not equal the exact source value. Also remember that a pie chart displays proportions of its plotted total, not necessarily a grand total elsewhere in the workbook. If the chart excludes a row or includes an unintended one, its percentages will reflect that different total.

Excel on Mac and Excel for the web

In Excel for Mac, select the chart and use the Chart Design tab to add data labels; the label-position and formatting controls are available through the chart’s formatting options. Ribbon labels and pane placement can differ from Windows, but the basic choices—value, percentage, and category name—work in a similar way. If a step’s command is not visible, select a label and open its formatting pane from the chart’s contextual controls.

Excel for the web can display and edit many chart elements, including data labels, but some detailed formatting controls may differ from the desktop app or be less convenient to locate. For fine control over label contents, number formats, and individual label positions, open the workbook in the Microsoft 365 desktop app. On Windows, Ctrl+Z undoes a recent formatting change; on Mac, use Command+Z.

When a pie chart is not the best choice

Showing exact values does not solve every weakness of a pie chart. People generally compare lengths more accurately than angles or slice areas, so a horizontal bar chart can be clearer when categories have similar values or when there are many of them. A bar chart also makes it easier to read long category names and sort values from largest to smallest. A pie chart is most effective when the categories form a meaningful whole and the number of slices is small enough to distinguish.

Consider a 3-D pie chart cautiously. Perspective can make slices at the front look larger than comparable slices at the back, which can make comparisons harder. A standard 2-D pie with direct labels is usually easier to read. If the goal is to compare shares across several groups, a 100% stacked bar chart may provide a more direct comparison than several separate pies.

Frequently Asked Questions

How do I show numbers instead of percentages on an Excel pie chart?
Right-click a data label, choose Format Data Labels, select Value, and clear Percentage. If labels are not visible yet, add them first from Chart Design > Add Chart Element > Data Labels.

Can Excel show the value and percentage together?
Yes. In the Format Data Labels pane, select both Value and Percentage. You can also include the category name, but several fields may crowd the chart.

Can I use custom text from worksheet cells as pie-chart labels?
In supported desktop versions, select Value From Cells in the Format Data Labels pane and choose the worksheet range to use. This is useful for labels that combine names and other text. Keep the range aligned with the chart’s categories, and check the available controls in your Excel version.

Why do my pie-chart values add up to a different total than expected?
The chart calculates percentages from the values in its plotted range. Check for omitted categories, extra rows, filters, or values that are not part of the intended total. Also distinguish the displayed rounded labels from the underlying precise values.

Can I show values inside every pie slice?
Usually, yes. Set the data-label position to Center or Inside End. Small slices may not have enough room, so outside labels or a different chart type can be more readable.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.