Excel Pie Chart: Create, Format, and Fix One

To make a pie chart in Excel for Microsoft 365 on Windows, select a table with one category column and one numeric-value column, then choose Insert > Insert Pie or Doughnut Chart and pick a pie style. Excel creates a chart showing each category as a share of the total; the steps below explain how to prepare the data, label the slices, and deal with common problems.

What an Excel pie chart shows

A pie chart represents one whole divided into categories. Each slice’s angle and area correspond to that category’s proportion of the total. For example, if a monthly budget table assigns $500 to rent, $250 to food, and $250 to transport, a pie chart shows rent as half of the total and each of the other categories as one quarter. The chart is useful when the main question is how parts compare with the whole.

Pie charts work best when the data contains a small number of meaningful categories and each value is nonnegative. They are less effective when readers need to compare similar values precisely. People can usually judge a long bar more accurately than the difference between two slices that are nearly the same size. A pie chart is also not a good way to show changes over time: separate pies for each month make it difficult to see trends.

Prepare the source data

Set up the source as a simple two-column list. Put category names in the first column and the values to compare in the second. Include a header row, such as Category and Amount, and avoid blank rows or merged cells inside the list. Excel uses the category labels to name the slices and the numeric values to calculate their proportions.

For example, a small survey summary might look like this:

Choice | Responses
Option A | 18
Option B | 12
Option C | 6

These values total 36, so the chart would show Option A as half of the responses, Option B as one third, and Option C as one sixth. The values do not have to be percentages; Excel calculates each value’s share of the total. If you already have percentages, check that they describe parts of the same whole and that their total is sensible. Rounding can make displayed percentages add to 99% or 101% even when the underlying proportions are valid.

Before charting, check that the values are numbers rather than text that merely looks numeric. Also decide how to handle categories that are not relevant, missing, or recorded as zero. A zero contributes no visible slice; a blank cell is not the same as a confirmed zero and may point to incomplete data.

Create a pie chart in Excel

Select the category labels and their corresponding values, including the headers if present. Do not select unrelated totals or notes.
On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
Choose 2-D Pie for a standard flat chart, or select another available pie style if it suits the purpose.
Click the chart title and replace the placeholder with a clear description of what the figures represent.

Excel inserts a chart linked to the selected cells. If you edit a source value or category name, the chart normally updates to reflect the change. To change the data range later, select the chart and use Chart Design > Select Data. If the categories and values have been interpreted in the wrong direction, try Chart Design > Switch Row/Column; for a simple two-column list, each row should generally represent one category.

On Excel for Mac, the Insert tab also provides chart choices, although the arrangement and wording can vary with the app version. Excel for the web supports creating and editing charts, but some formatting controls may be more limited or arranged differently than in the Windows desktop app.

Choose the right pie-chart type

For most comparisons, start with 2-D Pie. It displays slice sizes without perspective effects, making proportions easier to judge. A 3-D pie chart can make slices look larger or smaller depending on their position and viewing angle, so it is generally a poor choice when accurate comparison matters. A pie chart with separated slices, often called an exploded pie, can draw attention to a category, but separating too many slices makes the whole harder to read.

A doughnut chart uses a ring instead of a filled circle. It can show the same one-series part-to-whole relationship and leaves space in the center for a total or brief label, if the layout remains uncluttered. It does not solve the problem of comparing many similarly sized categories. A pie-of-pie or bar-of-pie chart can move small values into a secondary plot, but the extra structure can confuse readers if the relationship between the main and secondary sections is not clear. Use these variants only when the detail is important and the chart can be explained plainly.

As a rule of thumb, a pie chart is easiest to interpret with a handful of categories. There is no universal maximum that makes every chart readable: the number of slices, label length, and differences in size all matter. If a table has many small categories, consider grouping genuinely related items into Other, while keeping the underlying data available for readers who need the detail.

Add labels and make the chart readable

Labels reduce the need to guess what each color means. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position. You can also use the Chart Elements button beside a selected chart in Windows Excel. Available label positions and options can depend on the chart type and version. To control what appears, right-click a data label and choose Format Data Labels. Options can include category name, value, percentage, and a legend key.

Choose only the information that readers need. Category names and percentages are often enough for a part-to-whole chart. Including category, value, and percentage on every slice can make a small chart crowded. If exact amounts matter, include them in a nearby table or use a bar chart with value labels. A legend is useful when labels cannot fit beside the slices, but it forces readers to match colors to names; direct labels are often quicker to scan.

Use a specific title, such as Survey responses by choice, rather than a generic title such as Pie Chart. Keep category names short where possible, use colors with clear contrast, and do not rely on color alone to communicate meaning. If the chart will be printed in grayscale or viewed by people with color-vision differences, test whether slices and labels remain distinguishable. Avoid decorative effects that obscure boundaries or make the chart look more precise than the data supports.

Fix common pie-chart problems

The chart has one slice. Excel may have selected only one numeric value, or the source range may be arranged unexpectedly. Use Chart Design > Select Data to check that the range includes all category labels and values.
Categories appear as separate series. The chart may be reading rows and columns in the wrong orientation. Try Chart Design > Switch Row/Column, then check that each slice corresponds to one category.
Some categories are missing. Check for blanks, text values, filtered rows, or values outside the selected range. Confirm the chart’s data range includes the intended rows.
A slice is not visible. Its value may be zero, blank, negative, or extremely small compared with the total. Pie charts are designed for nonnegative parts of a whole; investigate negative or missing values instead of treating them as ordinary slices.
Percentages do not seem right. Excel calculates a slice’s share from the plotted values. Confirm that the selected values are the figures meant to make up the whole, and that an overall total row has not been included as an additional category.
The labels overlap. Move labels, reduce the amount of label text, enlarge the chart, or use a legend. If the chart still feels crowded, choose a different chart type rather than shrinking the text until it is hard to read.

One particularly common mistake is including a total row along with the categories that make up that total. If the category values are 18, 12, and 6, and the table also includes a Total of 36, selecting all four numbers makes Excel treat 36 as another slice. Select the three component values only. The total belongs in a separate cell or in a note, not as a peer category in that chart.

When another chart is a better choice

Use a bar or column chart when the goal is to rank categories, compare close values, or display many categories. A sorted horizontal bar chart is particularly helpful when labels are long. Use a line chart for values measured over time, such as monthly sales, because the connected points make the sequence and trend visible. A stacked bar chart can compare parts across several groups, although comparing individual segments becomes harder when they do not share a common baseline.

Ask what the reader needs to learn before choosing the chart. If the key message is that one category makes up about half of a single total, a pie chart may communicate it quickly. If the key question is whether 18 responses exceed 16, a bar chart makes that difference easier to judge. The best chart is not necessarily the most decorative one; it is the one that makes the relevant comparison clear without hiding important detail.

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 then format the labels to show Percentage. If you want the category names too, select that option as well. Check that the chart contains only the values that belong in the whole.

Can an Excel pie chart use negative numbers?
A pie chart is intended to show nonnegative parts of a whole. Negative values do not represent ordinary shares of a total and may not display as expected. Review the data and choose a chart type suited to the meaning of the positive and negative values.

How many categories should a pie chart have?
There is no fixed limit, but a small number of clearly named categories is usually easier to read. Many thin slices, long labels, or several nearly equal values make visual comparison difficult. Group related minor categories only when that grouping is meaningful and transparent.

Why does my pie chart show the wrong categories?
Check the selected source range and open Chart Design > Select Data. Make sure the category labels line up with the intended numeric values, exclude any total row, and use Switch Row/Column if Excel has interpreted the orientation incorrectly.

Can I change the order of the slices?
Change the order of the source rows to change the category sequence, or use the chart’s formatting controls to adjust the first-slice angle. In Windows Excel, right-click a slice and choose Format Data Series to find series options such as Angle of first slice. The exact controls can vary by chart type and app version.

Does changing the worksheet data update the chart?
Usually, yes: a chart linked to worksheet cells reflects edits to those cells. If you add categories beyond the chart’s current source range, they may not appear automatically. Use Chart Design > Select Data to confirm or expand the range.

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.