Pie Chart in Excel: How to Create and Format One

To make a pie chart in Excel for Microsoft 365 on Windows, place category names in one column and their values in the next, select both columns, then choose Insert > Insert Pie or Doughnut Chart and pick a 2-D Pie option. Add a descriptive title and data labels so readers can tell what each slice represents.

What a pie chart shows—and when to use one

A pie chart divides a circle into slices to show how each category contributes to a single total. Each slice represents a share of the whole, so the chart works best when the categories are mutually exclusive, add up to a meaningful total, and are few enough to distinguish at a glance.

For example, imagine a shop records 48 sales of apples, 32 of oranges, and 20 of pears during one day. The total is 100 sales, so the slices represent 48%, 32%, and 20%, respectively. This makes the overall distribution easy to grasp without reading every number.

A pie chart is less effective when there are many categories, values are close together, or the purpose is to compare small differences. It also does not show trends across time particularly well. In those cases, a bar or line chart may communicate the data more clearly. A pie chart is not a general-purpose picture of any selected numbers: it is specifically a comparison of parts of one whole.

Prepare the data before inserting the chart

Use a simple two-column layout: one column for category names and one for the values. Put a clear heading at the top of each column, such as Product and Sales. Keep the category labels next to their corresponding values, and avoid blank rows within the data range. Excel uses the labels to identify slices and the numeric values to determine their relative sizes.

Use one data series. A pie chart represents one set of values, not several independent series.
Make sure the categories describe parts of the same total, such as expense types within one monthly budget.
Use nonnegative numbers. Negative amounts do not represent ordinary shares of a whole; investigate or transform them appropriately before charting.
Decide how to handle categories such as Other. Combining several tiny categories can make a chart easier to read, but the grouping should remain meaningful.
Check that values are numeric rather than text. A value imported with an apostrophe or stored as text may not behave as expected.

For a budget example, categories might be Rent, Food, Transport, and Utilities, with one month’s spending beside each name. If the figures are 1,200, 600, 200, and 400, they total 2,400. The slices therefore represent 50%, 25%, about 8.3%, and about 16.7%. The chart describes the proportions of that listed spending; it does not establish whether the spending is appropriate or complete.

Create the pie chart in Excel for Windows

Arrange the category names and values in adjacent columns, including their headings.
Select the complete range, including the headings. For example, if the headings are in A1:B1 and four categories occupy rows 2 through 5, select A1:B5.
Open the Insert tab on the ribbon.
In the Charts group, choose Insert Pie or Doughnut Chart.
Select 2-D Pie for a straightforward chart. Excel inserts the chart into the worksheet.
Click the chart title and replace the default text with a title that explains the categories and period, such as Monthly Spending by Category.

If Excel places the categories in the legend but assigns the slices unexpectedly, check the selected range. A pie chart should be based on one column or row of values and the matching category labels. If the source has a heading row, include it so Excel can identify the series name, but do not select unrelated totals or notes beside the data.

Excel on Mac has a similar ribbon-based workflow: select the data, open Insert, and choose a pie chart from the chart options. Ribbon wording or the arrangement of chart buttons can vary by build, but the same principles apply. In Excel for the web, use the Insert tab and its chart options; some detailed formatting controls may be arranged differently from the Windows desktop app.

Add percentages, values, and category labels

Labels make a pie chart much more useful, especially when a reader needs exact figures rather than a visual estimate. Select the chart and use the Chart Elements button (the plus sign beside the chart) to turn on Data Labels. You can also use the chart ribbon: Chart Design > Add Chart Element > Data Labels, then choose a position such as Center, Inside End, or Outside End.

To choose what a label displays, right-click a data label and select Format Data Labels. In the formatting pane, enable options such as Category Name, Value, or Percentage, and turn off items you do not need. The available choices can depend on the chart and Excel build. A percentage label communicates each slice’s share of the plotted total; a value label communicates the underlying amount. Showing both can be helpful, but too many label elements can clutter a small chart.

Percentages are calculated from the values included in the chart, not necessarily from a separate grand total elsewhere on the sheet. If labels appear to add up to 99% or 101%, that can be a rounding effect. For example, several shares rounded to whole percentages may not sum to exactly 100%, even though the underlying shares do.

Format the chart for readability

Keep the design restrained. Choose colors that distinguish adjacent slices, use a readable font, and avoid effects that make slice size harder to judge. Select the chart and use Chart Design > Change Colors to review color palettes. The Chart Design and Format tabs also provide options for chart styles, outlines, text, and layout. Exact controls can vary with the selected chart element.

Use a specific title: identify the measure and time period rather than leaving a generic title such as Sales.
Keep the legend only if it helps: if each slice has a clear category label, a separate legend may repeat information.
Use consistent colors: do not imply a ranking or meaning with colors unless that meaning is explained.
Limit the slices: labels on many tiny slices overlap or become difficult to read.
Check contrast: make sure text remains legible against the slice colors and chart background.

You can move or resize the chart by dragging its border or corner handles. To move it to a dedicated sheet, select the chart and use Chart Design > Move Chart. This is useful when the chart needs more space or should be presented separately from the source table.

Choose among pie, doughnut, and specialty charts

A standard 2-D pie chart is usually the clearest starting point. A doughnut chart uses a hole in the center but still represents one series of parts of a whole. The open center can make room for a short central label, though it does not automatically make a chart easier to compare. A 3-D pie chart adds perspective that can distort the apparent size of slices, so it is generally a poor choice when accurate visual comparison matters.

Excel also offers variations such as Pie of Pie and Bar of Pie, which separate smaller values into a secondary pie or bar. These can help when a few small categories are hard to see beside a dominant category, but they require a clear explanation of how the secondary group is formed. For a simple set of categories, do not use a specialty chart just for decoration.

Common problems and how to fix them

The chart shows the wrong categories or values. Select the chart and use Chart Design > Select Data to inspect the chart’s source range. Confirm that the labels and values are paired correctly and that only the intended series is included. If necessary, edit the chart data range or rebuild the chart from a clean two-column selection.

The chart has too many slices. Combine minor categories into a clearly defined Other group when that is analytically fair, or switch to a bar chart. A long legend with similar colors is a sign that the pie chart is not serving the reader well.

Some categories are missing or appear as zero. Check for blank cells, text-formatted numbers, and actual zero values. A zero has no visible slice, while a text value may not be treated as a number. Correct the source data and check the chart again.

The chart does not show the expected total. A pie chart shows the proportions of the values in its plotted series. If a total row is included as another category, it becomes an extra slice and changes the proportions. Exclude grand totals from the selected range; the total is not itself one of the parts.

The labels are crowded. Try displaying only category names or only percentages, move labels outside the slices, enlarge the chart, or choose a bar chart. Reducing font size too far may technically fit the labels but make the graphic difficult to use.

When a bar chart is a better alternative

Use a bar or column chart when readers need to compare category values precisely, especially if many categories are involved or their values are similar. Bars share a common baseline, which makes small differences easier to judge than differences between angles or areas. A bar chart is also more suitable for comparing categories across several months or across multiple groups.

Use a line chart when the main question concerns change over time. Use a pie chart when the question is simply how one total is divided among a small set of categories. A useful test is to ask what the reader should learn in a few seconds: if the answer is “which category is larger?” or “how did it change?”, a pie chart may not be the best choice.

Frequently Asked Questions

How do I show percentages on a pie chart in Excel?
Select the chart, turn on Data Labels using the Chart Elements plus button, then right-click a label and choose Format Data Labels. Select Percentage in the pane. You can deselect Value if you want percentages without raw numbers.

Can an Excel pie chart show more than one data series?
A pie chart is designed to show one data series at a time. If you need to compare two or more series, use a clustered bar or column chart, or create separate pie charts only if each one represents a clearly comparable whole.

Why does my pie chart include a total as a slice?
The total row was probably included in the chart source range. Edit the source data through Chart Design > Select Data, or select the category rows again without the total row. A grand total summarizes the parts and should not be charted as another part.

Can I make a pie chart from non-adjacent cells?
It is usually easier and less error-prone to place labels and values in adjacent columns, then select that continuous range. Non-adjacent selections can be awkward to define and may produce an unexpected chart, so make a small helper table if the source data is spread across the worksheet.

How many categories should a pie chart have?
There is no universal cutoff, but a pie chart is easiest to read with a small number of clearly distinct categories. If labels overlap, slices are too small to distinguish, or readers must repeatedly consult a long legend, combine categories appropriately or choose a bar chart.

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.