Pie Chart Data in Excel: Format, Create, and Fix Charts

To make a pie chart in Excel, arrange category names in one column and their numeric values in the next, select the two columns, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. A pie chart works best when the values are nonnegative parts of one meaningful total and there are only a few categories.

What makes data suitable for a pie chart?

A pie chart represents how categories contribute to a whole. Each slice is proportional to its value compared with the sum of all values in the series. For example, if a shop sells 45 units of Product A, 30 of Product B, 15 of Product C, and 10 of Product D, the total is 100 units. The slices represent 45%, 30%, 15%, and 10% of that total.

The data should answer a part-to-whole question, such as “What share of total orders came from each channel?” It is less suitable for comparing unrelated measurements, showing change over time, or putting values with different units into one picture. A pie chart does not make a total meaningful just because Excel can draw one.

Use one category for each slice and one numeric value for that category.
Keep the categories mutually exclusive so the same item is not counted twice.
Make the categories collectively cover the total you want to describe. If some data is missing, explain that rather than implying the chart is complete.
Use positive values. Zero values do not create visible slices, and negative values cannot be represented as ordinary pie slices.

How to arrange pie chart data in Excel

For a simple chart, put category labels in the first column and values in the adjacent column. A heading row helps make the chart and its legend easier to interpret. For example, enter “Channel” in A1 and “Orders” in B1, then list “Web” and 45, “Store” and 30, “Phone” and 15, and “Partner” and 10 in rows 2 through 5. Excel uses the labels for the slice names and the numbers to calculate their relative sizes.

Keep the data in a contiguous block, with no completely blank rows or columns inside it. Avoid putting a grand-total row in the selected range: the total is already the sum of the slices, so adding it as another category counts the whole amount again and distorts the picture. If your source table has several numeric measures, select only the category column and the single measure you want to chart.

When the source is an Excel table, adding a new data row directly below the table generally expands the table and can extend a chart based on it. For a one-off chart, an ordinary range is also fine. Whichever layout you use, keep labels descriptive and values numeric; numbers stored as text may not behave as intended.

Create a 2-D pie chart in Excel for Microsoft 365

Select the cells containing the category headings, category names, and the one value series. Include the heading row if it is present.
On the Windows ribbon, choose Insert > Insert Pie or Doughnut Chart > 2-D Pie.
Excel inserts a chart on the worksheet. Check that each intended category appears once and that the chart title describes the measure and scope.
Move or resize the chart using its border, or use the Chart Design and Format tabs to adjust its appearance.

Excel may infer the category and value ranges from your selection. If the slices or labels look wrong, select the chart and use Chart Design > Select Data to inspect the chart data range and series. A standard pie chart should contain one data series. The chart remains linked to its source cells, so changing a source value normally changes the slice proportions as well.

In Excel for Mac, the ribbon-based insertion route is broadly similar: select the data and choose the pie chart from the Insert tab’s chart options. Ribbon labels and layout can differ slightly between builds. Excel for the web also provides chart insertion, though some detailed formatting controls may be arranged differently from the Windows desktop app.

Show values, percentages, and category names

A chart can be mathematically correct but hard to read if readers have to guess what each slice means. To add labels in Microsoft 365 for Windows, select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position such as Outside End. To choose the information shown, open Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select options such as Category Name, Value, or Percentage.

For the example with a total of 100 orders, percentage labels should read 45%, 30%, 15%, and 10%. If the total were 200 and the values were 90, 60, 30, and 20, the percentages would be the same because the proportions are unchanged. Excel calculates percentages from the plotted series; you do not need to add a percentage column just to display percentage labels.

Choose labels that serve the reader. Category names plus percentages are often clearer than values plus percentages when the chart is small. If exact counts matter, show the values too or put them in a nearby table. A legend can be useful when labels would collide, but it forces readers to match colors back and forth. On a crowded chart, neither labels nor a legend can make too many slices easy to understand.

Choose categories and colors carefully

Pie charts are easiest to scan with a small number of categories. There is no universal maximum, but as the slice count rises, it becomes harder to compare angles and distinguish similar colors. If a report has many product types, consider grouping small categories into a clearly named “Other” slice. State which categories were grouped, especially when the breakdown may affect a decision.

Sort the source values when it helps tell the story, such as putting the largest category first and the rest in descending order. Keep category labels stable and specific: “Email campaign” is more useful than “Other” unless “Other” is genuinely a defined group. Use color consistently across related charts, and do not rely on color alone to communicate meaning; labels help readers who cannot distinguish some color combinations.

Excel can separate a slice from the rest of the pie, but an exploded slice should have a clear purpose, such as highlighting the category being discussed. Exploding several slices or using decorative effects can make the chart look dramatic while making comparisons less clear. A simple 2-D chart is usually easier to interpret than a 3-D pie, whose perspective can make slices at the front appear larger than comparable slices at the back.

When another chart is a better choice

Use a pie chart when the important message is the share each category contributes to a single whole and the categories are few enough to label. If readers need to compare values precisely, a bar or column chart is usually more effective because it is easier to compare lengths against a common scale than to compare slice angles.

A 100% stacked bar chart can be useful when the goal is to compare percentage composition across several groups, such as each department’s mix of order channels. A pie chart normally shows one series at a time; it is not a good way to compare several years by adding multiple value columns. For a time trend, use a line chart, and for several groups with many categories, consider a clustered or stacked bar chart. The best choice depends on the question, not on which chart type is most decorative.

Common pie chart data problems

The total appears as a slice: Remove the total row from the chart’s source range. Otherwise Excel treats the total as another category in addition to the component values.
Categories or values are missing: Check that the selected range includes all intended rows and that blank rows have not split the data. Use Chart Design > Select Data to review the range.
A slice is unexpectedly absent: Check for a zero, blank, text-formatted number, or negative value. A zero has no visible area, while negative values do not represent ordinary parts of a whole.
Percentages do not match expectations: Confirm that the chart includes only the intended categories and one series. Remember that displayed percentages are calculated against the sum of values actually plotted.
The chart is unreadable: Reduce the number of categories, use a bar chart, enlarge the chart, or show only the most useful label details. Adding more colors or effects rarely solves a crowded-data problem.

Also check for duplicate categories that should have been combined. If “Web” appears on several rows because the source is transaction-level data, Excel may draw separate slices for each row rather than automatically summing matching labels. Summarize the data by category first, for example with a PivotTable or a separate summary table, and chart that result.

Frequently Asked Questions

How do I make a pie chart with percentages in Excel?
Select category names and one numeric value column, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Select the chart and use Chart Design > Add Chart Element > Data Labels > More Data Label Options, then enable Percentage. You can also enable Category Name.

Can an Excel pie chart have more than one data series?
A standard pie chart is designed to show one data series at a time because each pie represents one whole. If you need to compare multiple series, use a different chart type, such as a clustered bar chart, or make separate pies only when that comparison remains clear.

Why does my pie chart show the wrong percentages?
Excel calculates each slice as a share of the values in the plotted series. Check whether a total row, unintended category, or extra value column is included, and confirm that the selected categories are the ones you meant to compare.

Can a pie chart show negative numbers?
Negative values cannot be shown as ordinary positive slices of a whole. Recheck the data or choose a chart designed to show values above and below zero. Do not change negative values to positive simply to make a pie chart work; that would change what the data means.

Should I use a 3-D pie chart in Excel?
Usually not when accurate comparison matters. Perspective can distort the apparent size of slices, while a 2-D pie makes the proportions easier to judge. Use a 3-D style only when its appearance is specifically needed and the visual distortion will not mislead readers.

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.