Excel Pie Chart Tutorial: Create and Format One

To make a pie chart in Excel for Microsoft 365 on Windows, select your category names and numeric values, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Add a chart title and data labels from Chart Design > Add Chart Element, then format the labels so readers can see the categories, values, or percentages they need.

When a pie chart is a good choice

A pie chart represents categories as slices of one whole. It works best when the categories are mutually exclusive, their values add up to a meaningful total, and there are only a few slices. For example, a small business could show how 100 monthly orders were split among four product lines. If the counts are 42, 28, 18, and 12, the slices correspond to 42%, 28%, 18%, and 12% of the total.

Use a pie chart when the reader’s main question is “How is this total divided?” It is less useful for comparing precise values, showing changes over time, or displaying many categories. People can judge the largest slice fairly quickly, but comparing two similar angles is harder than comparing the lengths of bars. A chart with many narrow slices can become difficult to read even if every value is correct.

Prepare the source data

Put each category in one column and its value in the next, with a clear heading in the first row. For the order example, the data might have Product in A1 and Orders in B1, followed by four product names and the values 42, 28, 18, and 12 in rows 2 through 5. Use one row per category, and make sure the values are numeric rather than numbers stored as text.

Include only the categories that belong to the same whole and the same reporting period.
Use positive values that can sensibly be treated as parts of a total. A pie chart is not a suitable way to represent negative amounts.
Check for duplicate categories, blank labels, and accidental total rows. Including a total as another slice counts the same data twice.
Decide what to do with a long tail of very small categories. Grouping them as Other can improve readability, but only when that grouping is meaningful and clearly explained.

Excel calculates the slice proportions from the selected values; you do not have to calculate percentages first. In the example, the total is 100 orders, so each count happens to equal its percentage. With values that total 250, Excel would still calculate each slice as a share of 250. Keep the source range simple, because blank rows or unrelated values can cause Excel to select an unintended range.

Create a 2-D pie chart

Select the category labels and values, including their headings. In the example, select A1:B5. If the columns are next to each other, selecting any cell in the data can also allow Excel to infer the range, but selecting the exact range gives you more control.
Open the Insert tab. In the Charts area, choose Insert Pie or Doughnut Chart, then select 2-D Pie. The chart appears in the worksheet.
Click the chart title and type a descriptive title, such as Monthly Orders by Product. If the title placeholder is missing, use Chart Design > Add Chart Element > Chart Title > Above Chart.
Move or resize the chart by dragging its border or corner handles. Keep it close enough to the source data that it is easy to find, while leaving room for labels and a legend.

For categories and values in separate, nonadjacent ranges, select the first range and then hold Ctrl while selecting the second range on Windows. On Mac, use Command instead of Ctrl. Excel’s chart selection can be sensitive to how separated ranges are selected; if the slices or labels are wrong, create a chart from a contiguous two-column table instead. You can also select the chart and use Chart Design > Select Data to inspect or adjust the source range.

Add and choose data labels

Labels make a pie chart easier to interpret without asking readers to match every color to a legend. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position such as Outside End. To control the label contents, right-click a data label and choose Format Data Labels. The Format Data Labels pane lets you select items such as Category Name, Value, and Percentage; the available choices depend on the chart and Excel version.

For a chart intended to show shares, Percentage is usually more useful than Value alone. For a chart used to report counts, Value may be the clearest choice. Category Name can make the slices self-explanatory, but showing category, value, and percentage together can crowd the chart. Choose the smallest set of labels that answers the reader’s question. If you show percentages, check that rounding does not make the displayed values appear to total something misleading; rounded percentages can add up to 99% or 101% even when the underlying proportions total 100%.

You can also use a legend instead of putting category names beside each slice. A legend conserves label space, but readers must match each color to the legend entry. If you use one, keep its colors distinct and its placement close to the chart. Avoid relying on color alone when the chart will be viewed in grayscale or by people with color-vision differences.

Format colors, legend, and slice appearance

Use the Chart Design tab to apply a chart style or change the chart colors. These built-in options can create a consistent look without manually formatting every slice. For more control, select a slice and use the formatting options to adjust its fill or border. Keep the palette restrained: a different color for every category is conventional, but very similar shades can make adjacent slices hard to distinguish.

To emphasize one category, select the pie and then select the individual slice before dragging it slightly away from the center. This is called exploding a slice. Use it sparingly: pulling several slices apart can make the chart look fragmented and can make comparisons less clear. A 3-D pie chart may look more decorative, but perspective can distort the apparent size of slices. A 2-D pie is generally easier to read and compare.

Formatting should support the data rather than suggest a conclusion the values do not support. Give the chart a specific title that identifies the measure and period. If the data cover a partial year or a selected sample rather than the entire population of interest, make that scope clear in the title or a nearby note.

Fix common pie chart problems

If the chart shows the wrong categories, select it and go to Chart Design > Select Data. Check that the chart data range contains the intended labels and values, and that a total row or unrelated column has not been included. If Excel has interpreted categories as separate series or arranged the data in the wrong direction, try Chart Design > Switch Row/Column. With a basic two-column list, each row should normally produce one slice.

If labels overlap, first remove unnecessary label items or move labels outside the pie. You can also make the chart larger or group genuinely minor categories into Other. Avoid shrinking the font until it is unreadable. If the legend is confusing, verify that the category labels in the source are descriptive and that the slices have distinguishable colors.

If one slice seems unexpectedly large, inspect the source values and confirm the chart’s data range. Check for a duplicated row, a mistakenly included subtotal, or values from different periods. A pie chart always expresses each included value as a share of the included total, so changing the selected categories changes every percentage. A zero value has no visible slice; it may still appear in a legend or label depending on the chart settings. For data that include negatives, use a chart type designed for the question rather than trying to interpret negative amounts as pie slices.

If you edit a category name or value in the source cells, the chart normally updates because it is linked to those cells. If it does not, check the selected data range and whether calculation or workbook links are affecting the displayed data. When the chart is copied to another workbook, consider whether the copy should remain linked to its original source or use a self-contained data range.

Pie charts versus other chart types

A bar or column chart is usually better when readers need to compare values precisely, especially when categories are close in size. Its common baseline makes differences easier to judge than slice angles. A line chart is a better fit for a trend over ordered time periods. A stacked bar chart can show parts of totals across several groups, though comparing middle segments across groups may still be difficult.

Excel also offers doughnut charts, which resemble pie charts with a hole in the center. A doughnut chart can show one series of category shares and may leave room for a central label, but it does not solve the problem of comparing many similar slices. A chart with multiple pie series is not a reliable way to compare several totals; for that task, grouped or stacked bars are often clearer. Choose the chart type based on the comparison the reader needs to make, not just on which design looks most striking.

Print, copy, and use the chart elsewhere

Before sharing, check the chart at the size at which people will view it. Labels that look fine on a large monitor may be too small in a printed report or pasted into a presentation. Select the chart and use the sizing handles to adjust it; if the worksheet is being printed, use Print Preview to check that the chart and its labels fit on the page. If the chart is hard to read at the intended size, simplify the labels or choose another chart type rather than compressing it further.

To put the chart in another Office document, select the chart and copy it, then paste it into the destination. The paste options can affect whether it remains linked to the workbook, becomes an embedded chart, or is pasted as a picture; choose based on whether the recipient needs to edit the data. Excel for Mac has similar chart-creation and formatting capabilities, though some ribbon labels and pane layouts can differ. Excel for the web supports creating and editing charts, but some advanced formatting controls may be more limited than in the Windows desktop app.

Frequently Asked Questions

How do I show percentages on an Excel pie chart?
Select the chart, choose Chart Design > Add Chart Element > Data Labels, and add labels. Right-click a label, choose Format Data Labels, and select Percentage. Clear Value if you do not want both figures displayed.

Can an Excel pie chart use more than one data series?
A standard pie chart represents one data series as parts of one whole. If you have several groups to compare, use a bar, column, or stacked chart instead of trying to combine multiple pie series.

Why does my pie chart show the wrong percentages?
Excel calculates each slice as a proportion of the values in the chart’s selected range. Check for a total or subtotal included as a category, duplicated data, or extra rows in the range. Also confirm that all included values belong to the same whole.

How many categories should a pie chart have?
There is no fixed maximum that makes every chart readable, but a pie is clearest with a small number of distinct categories. If labels overlap or several slices are tiny, combine appropriate minor categories or use a bar chart.

Can I make a pie chart in Excel for the web?
Yes. You can select the data and insert a pie chart in Excel for the web. The basic task is similar, although some chart-formatting choices and pane layouts may differ from Excel for Microsoft 365 on Windows.

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.