Pie Chart in Excel: How to Create, Format, and Label It

To create a pie chart in Excel for Microsoft 365 on Windows, select a column of category names and the matching values, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Select the chart and use Chart Design > Add Chart Element > Data Labels to show values, category names, or percentages.

What a pie chart shows—and when it fits

A pie chart divides one whole into slices. Each slice represents a category’s share of the total, so the visual works best when the categories are parts of the same meaningful total and there are only a few of them. Examples include the share of a department’s budget spent on four expense types, or the proportion of survey responses in five answer categories.

Excel calculates each slice’s angle from its value relative to the sum of the values in the series. The values do not have to add up to 100: if they add up to 200, Excel still displays each category as a share of that 200 total. A pie chart is therefore not proof that the figures represent a complete real-world whole. You must decide whether the categories are mutually exclusive and collectively cover the total you want to explain.

Pie charts are less suitable for comparing values that are close together, showing change over time, or displaying many categories. People generally compare lengths more accurately than angles, so a bar chart often makes small differences easier to see.

Prepare the data before inserting a chart

Keep the source data simple: one column for category names and one adjacent column for numeric values. Put a clear heading at the top of each column, and avoid blank rows or totals within the data range. For example:

Travel — 42
Supplies — 30
Training — 18
Other — 10

Here, the values total 100, so they can also be read directly as percentages. If they totaled 250 instead, Excel would still calculate each category’s share correctly, provided every number belongs in the same total. Check that values are numeric rather than numbers stored as text; text values may be ignored or cause an unexpected chart. Also check for duplicate categories that should be combined and categories that are missing from the source.

For a simple chart, select the category labels and values together, including the headings. If the columns are not next to one another, select the first range, then hold Ctrl on Windows while selecting the second range. On Mac, use Command while selecting the additional range. A clean, adjacent two-column layout is usually easier to manage and less likely to produce a chart with the wrong labels.

Create a basic pie chart in Excel

Select the data range, including the category names and values. For the example above, that means selecting both columns and their four category rows, plus the headings if present.
Open the Insert tab on the ribbon.
Choose Insert Pie or Doughnut Chart in the Charts group, then select 2-D Pie. A 2-D chart is generally easier to read than a 3-D version because it does not distort the apparent slice sizes.
Excel inserts the chart on the worksheet. Click the title to edit it, for example, to read “Department expenses.”
Review the legend and category order. If the chart has the wrong categories or values, use Chart Design > Select Data to inspect the chart’s source range.

Excel may choose a default layout and colors, but those are only starting points. The chart is linked to its source cells, so changing a source value normally updates the slices. If you add new rows, whether the chart includes them depends on how the source range is set up. Converting the source range to an Excel table with Insert > Table can make expanding data easier to manage, though you should still check the chart after adding categories.

On Mac, the ribbon also has an Insert tab and a pie-chart option; names and placement can vary slightly by Excel build. Excel for the web supports creating and editing charts, though some formatting controls may be arranged differently or offer fewer options than the desktop app. If a named command is not visible, select the chart first to reveal its chart-specific tabs.

Add percentage, value, and category labels

A legend can identify slices, but data labels put information next to the slices themselves. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position such as Best Fit or Outside End. To choose exactly what appears, open Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, enable or clear options such as Category Name, Value, and Percentage.

For the example values 42, 30, 18, and 10, the total is 100, so percentage labels show 42%, 30%, 18%, and 10%. If the values were 42, 30, 18, and 20, the total would be 110 and the percentages would be approximately 38.2%, 27.3%, 16.4%, and 18.2%. Excel calculates percentages from the series total; they are not simply the raw values with a percent sign added.

When you want a label to show both the category and its share, enable Category Name and Percentage. Avoid showing category name, value, and percentage all at once if the chart becomes crowded. You can also format the number of decimal places in the label options. Rounded percentages may add to 99% or 101% even when the underlying shares total exactly 100%; that is a rounding effect, not necessarily a data error.

Format the chart for readability

A clear title should say what the whole represents and, where useful, include a timeframe. A title such as “2025 survey responses” is more informative than “Pie Chart.” Keep category names short enough to read, and use a legend if labels around the slices would overlap. If the chart has only a few slices, direct labels can make comparisons and identification quicker.

To change the palette, select the chart and use Chart Design > Change Colors. To choose a different overall style, use the Chart Styles gallery on the same tab. Make sure neighboring slices remain distinguishable and that color is not the only way readers can identify an important category. Data labels and a legend provide additional cues. Avoid adding shadows, 3-D effects, or separated slices just for decoration; these can make the proportions harder to judge.

You can emphasize one slice by selecting the pie once and then selecting that slice again, before dragging it slightly away from the center. Use this sparingly: pulling out several slices weakens the sense that the chart represents one whole. For a report or presentation, resize the chart so labels are legible, and check it at the size at which readers will actually see it.

Common problems and practical fixes

The chart shows the wrong labels. Excel may have interpreted a heading or column incorrectly. Select the chart and review Chart Design > Select Data. Confirm that the category labels point to the name cells and that the series values point to the numeric cells.
Only one slice appears. Check whether the selected range contains several numeric values. A common mistake is selecting only one value column or including data in a layout Excel interprets as multiple series. A pie chart is intended to display one data series.
Some categories are missing. Check for blank or text-formatted values, and review the chart’s source range for omitted rows. A zero has no visible slice, and negative values are not suitable for a pie chart. Correct the data or use a chart type designed for the question.
The percentages do not match expectations. Excel calculates each share against the sum of the plotted values. Confirm that the range excludes subtotals or an overall total; including a total as another category changes every slice’s percentage.
Labels overlap or become unreadable. Show fewer label fields, move labels outside the pie, enlarge the chart, or combine small categories when that is analytically appropriate. Do not combine categories merely to hide an inconvenient result.

When to use a bar chart or another alternative

Use a pie chart when the question is “How is this whole divided?” and the categories are few enough to distinguish. If the question is “Which category is larger?” or the values are close, a bar or column chart is usually clearer. With a bar chart, readers compare the lengths of bars along a common scale, which makes ranking and small differences easier to assess.

A doughnut chart also represents one series as parts of a whole, with a blank center. It can work when the hole has a purpose, but it does not solve the difficulty of comparing similar slice sizes. A stacked bar can be useful for comparing parts of a whole across several groups, such as expense shares in multiple departments. For trends over time, a line chart is generally more appropriate than a series of pies.

If there are many small categories, consider sorting a bar chart from largest to smallest, or grouping minor categories into “Other” only when that grouping is meaningful and disclosed. There is no universal maximum number of slices, but as a practical matter, a chart with numerous thin wedges and a long legend is difficult to interpret.

Frequently Asked Questions

How do I show percentages on a pie chart in Excel?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Percentage. Clear Value if you want percentages without the original numbers.

Can I make a pie chart from non-adjacent cells?
Yes. On Windows, select the first range and hold Ctrl while selecting the other range; on Mac, hold Command. Then insert the chart. Because non-adjacent selections can be interpreted unexpectedly, check the category labels and values after Excel creates it.

Why do my pie chart percentages add up to 99% or 101%?
Displayed percentages may be rounded to a set number of decimal places. The exact underlying shares can total 100% even if the rounded labels do not. Increase the displayed decimal places in the data-label formatting options if precision matters.

Can a pie chart show multiple data series?
A standard pie chart shows one series at a time. If you have several groups to compare, use a different chart type, such as a clustered or stacked bar chart, rather than trying to place multiple series in one pie.

How do I update a pie chart when I change the data?
Edit the source cells and the chart should update automatically. If you add categories, confirm that the chart’s source range includes the new rows. An Excel table can help the data range expand as you add rows, but verify the chart after changing its source data.

Final check before sharing

Before using the chart in a report, verify that its categories really make up the stated whole, the source range excludes totals, and the labels are readable. Check the title, units, timeframe, and rounding. If readers need to compare precise values or many categories, choose a bar chart instead. The best chart is the one that makes the intended comparison clear without asking the reader to guess what the slices mean.

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.