Create a Pie Chart in Excel: Steps and Tips

Yes. In Excel for Microsoft 365 on Windows, select your category names and values, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel creates a chart you can title, label, recolor, and resize; the key to a useful result is arranging the data so each slice represents one part of a meaningful whole.

What a pie chart shows

A pie chart divides a circle into slices to show how categories contribute to a total. Each slice corresponds to a value, and its angle and area represent that value as a share of the sum. For example, if a department spends $480 on supplies, $300 on travel, $150 on software, and $70 on training, the total is $1,000. The corresponding shares are 48%, 30%, 15%, and 7%.

This makes a pie chart most useful when the reader needs to compare a small set of parts of one whole, such as a survey’s distribution of answers or a company’s share of sales by product. It is less useful when categories do not belong to one total, when the values change over time, or when the chart contains many similarly sized slices. The circle implies that the categories collectively make up the whole, so that relationship should be real and clear.

Prepare your Excel data

Put category labels in one column and their corresponding numbers in the next, with a header above each column. For example, cells A1:B5 might contain the headers Category and Amount, followed by Supplies, Travel, Software, and Training with their values. Keep each category-value pair on the same row and use actual numeric values rather than numbers stored as text.

Select the category rows and values, including the headers if you want Excel to use them in the chart. Do not include a grand-total row: the total is the whole, not another category within it, and including it would make the displayed proportions misleading. Check that each category is distinct and that the values describe parts of the same period, group, or overall total.

Use one value column for one pie chart. A pie chart is designed to show one data series.
Use nonnegative values that can be interpreted as portions of a whole. If a measure can be negative, a pie chart is generally not an appropriate way to present it.
Keep the number of categories manageable. Several small categories can be combined as Other only when that grouping is meaningful and disclosed.
Make sure the values add up to the total you intend to explain. Excel calculates each slice’s percentage from the selected values.

Create the chart step by step

Select the cells containing the category labels and values. Include the headers, but exclude any total row or unrelated data.
Open the Insert tab on the ribbon. In the Charts area, choose Insert Pie or Doughnut Chart.
Choose 2-D Pie for a standard flat chart. Excel inserts the chart on the worksheet, usually near the selected data.
Click the chart title and type a specific description, such as Sales by Product in October. If there is no title, use Chart Design > Add Chart Element > Chart Title and select a position.
Save the workbook. You can move or resize the chart by selecting its border and dragging it, or use the chart formatting controls to adjust its appearance.

If the chart displays the wrong categories or values, select it and use Chart Design > Select Data to review the chart’s source range and series. A pie chart uses one series of numbers and category labels. If Excel interprets rows and columns in the wrong direction, try Chart Design > Switch Row/Column; whether that helps depends on how the source data is arranged.

Add percentages and improve readability

Labels often make a pie chart easier to understand because readers do not have to estimate slice sizes or match colors to a distant legend. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a placement. To choose exactly what appears, open Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the formatting pane, you can select items such as Category Name, Value, and Percentage.

For a share-of-total chart, category names and percentages are often enough. Showing both the raw value and percentage can be helpful when the exact amounts matter, but it can make labels crowded. Choose a label position that keeps text legible; outside labels may work better for small slices, while labels inside slices can suit larger ones. If labels overlap, remove less important details or use a legend rather than shrinking the type until it is difficult to read.

Use a short, informative title and a restrained color palette. Excel’s preset colors are available through Chart Design > Change Colors. Avoid relying on color alone to convey an essential distinction: include category names in labels or a readable legend. A 3-D pie can make slices look larger or smaller depending on perspective, so a 2-D chart is generally clearer for comparing shares.

Choose the right pie chart type

The standard 2-D pie is a sensible default for showing one series of parts. Excel also offers variations such as a 3-D pie, a pie-of-pie chart, a bar-of-pie chart, and a doughnut chart. These options do not make unsuitable data suitable, so start by asking whether readers need to compare a few parts of one whole.

2-D pie: A straightforward option for a small number of categories with clearly different shares.
Doughnut: Similar to a pie chart, with a blank center. It can suit a compact dashboard, but the arc lengths can be harder to compare precisely.
Pie of pie or bar of pie: These separate some smaller slices into a secondary chart. They can expose small categories, but the added structure may take more explanation.
3-D pie: Adds perspective, but visual distortion can make comparisons less reliable. Use it only if the appearance is more important than precise comparison.

When there are many categories or several values are close together, a bar chart is often easier to read because people compare lengths more accurately than angles. A column chart can work well for a small set of categories, while a line chart is usually better for values changing across time. The best chart is the one that makes the intended comparison easiest, not necessarily the one that looks most decorative.

Fix common pie chart problems

The chart includes the total as a slice. Edit the source range with Chart Design > Select Data, or select the chart and adjust the highlighted range on the worksheet. Include category rows only, not the total row.

Labels or categories look wrong. Check that the selected range has one label column and one numeric column, and that headers are not being treated as data. Use Select Data to inspect the category label range and series values. If the chart is reading the data across rows instead of down columns, try Switch Row/Column.

A small slice is hard to see. Add percentage or category labels, simplify the number of categories, or consider a bar chart. Exploding a slice or changing its color may draw attention to it, but it does not make its value more significant. Do not exaggerate a slice’s importance with a misleading scale or presentation.

The chart does not reflect later data edits. Check that the edited cells are inside the chart’s source range. If you regularly add rows, converting the source range into an Excel table can make the data easier to manage and can help associated chart ranges expand as table data grows. Review the chart after adding rows to confirm the new category appears as intended.

Excel on Mac and Excel for the web

The general workflow is also available in Excel for Mac: select the data, use the Insert tab to insert a pie chart, and use the chart design and formatting controls to add a title or labels. Ribbon wording or control placement can vary slightly by Excel release. If selecting nonadjacent ranges, use Command while selecting on Mac rather than Ctrl on Windows; for a simple pie chart, keeping labels and values together in adjacent columns is easier.

Excel for the web also supports creating and editing charts, though its ribbon and chart-formatting options can differ from the Windows desktop application. If a specific label setting or chart variation is not available in the web interface, open the workbook in the desktop version of Excel. When sharing a workbook, recipients may see the chart differently if their application has limited editing or formatting support, so check the result in the version they are likely to use.

Frequently Asked Questions

Can I make a pie chart in Excel with percentages?

Yes. Create the chart from the category and value data, select it, then use Chart Design > Add Chart Element > Data Labels. Open More Data Label Options and select Percentage. Excel calculates the percentage of each selected value relative to the sum of the values in the series.

How many categories should a pie chart have?

There is no fixed maximum that guarantees readability, but a pie chart is usually clearest with a small number of categories. As slices become numerous or similar in size, labels and visual comparisons become difficult. Consider grouping categories only when the grouping is meaningful, or switch to a bar chart.

Can an Excel pie chart show two data series?

A standard pie chart is intended to display one data series, not two comparable series. If you select multiple series, the chart may show only one series or produce a result that does not communicate the comparison clearly. To compare groups, use a chart type designed for multiple series, such as a clustered column chart.

Can I change the chart after creating it?

Yes. Select the chart to access chart design and formatting options. Use Chart Design > Change Chart Type to switch to another chart type, or use Select Data to adjust the source range. You can also edit titles, labels, colors, and placement without rebuilding the worksheet data.

Why do my pie chart percentages not add up to exactly 100%?

Displayed percentages may add to 99% or 101% because Excel rounds each label for display. The underlying proportions are calculated from the selected values, but rounding each slice separately can create a small difference in the displayed total. More decimal places may reduce the visible discrepancy.

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.