Pie Chart Creation in Excel: A Practical Step-by-Step Guide

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

What a pie chart shows—and when to use one

A pie chart represents a whole as a circle divided into slices. Each slice corresponds to a category, and its size reflects that category’s share of the total. Excel calculates the proportions from the values in the selected series, so the values do not need to be percentages; counts, sales, or other nonnegative quantities can work.

Use a pie chart when your data answers a focused question such as “How is this total divided among the main categories?” A department budget split among five departments or survey responses across four choices can be suitable examples. A pie is most useful when the categories are mutually exclusive and collectively represent the whole. If categories overlap, or the data does not add up to a meaningful whole, the slices can suggest a relationship that is not really there.

Pie charts are less effective when there are many categories, when the values are close together, or when readers need precise comparisons. People generally find it easier to compare positions along a common scale than to compare angles. A bar chart is often clearer for ranking categories or distinguishing similar values.

Prepare the worksheet data

Arrange the chart source as a simple two-column table. Put one category per row, with category names in the first column and the corresponding numeric values in the second. Include a header row, such as Category and Amount, and avoid blank rows or columns inside the range. For example, a table might list Product A, 48; Product B, 30; Product C, 15; and Product D, 7. The total is 100, so the values correspond to shares of 48%, 30%, 15%, and 7%.

Select the headers and all category-value rows when creating the chart. Including headers helps Excel identify the series and category labels. If the chart appears with an unexpected slice or label, check that the selection did not include a grand-total row. A total row should not usually be included as a slice: Excel would treat the total as another category and count it in the whole, distorting every proportion.

Before charting, check that values are numeric rather than numbers stored as text. Remove or explain missing values, and decide how to handle categories that have no value. A zero contributes no visible slice. Negative values do not make sense as parts of a whole, so use a different chart or revisit the data if negatives appear. Also make sure each category is counted only once and that the table represents the period or population described by the chart.

Create the pie chart in Excel for Windows

Click a cell in the category-and-value table, or select the full range including the headers.
Open the Insert tab on the ribbon.
Choose Insert Pie or Doughnut Chart in the Charts group.
Select 2-D Pie for a standard flat pie chart. Excel inserts the chart on the worksheet.
Click the chart title and replace the placeholder with a specific description, such as Share of Survey Responses.

If Excel chooses the wrong data arrangement, select the chart and open Chart Design > Select Data. Check that the category labels point to the name cells and the series values point to the numeric cells. For a simple two-column table, Excel usually recognizes this correctly without extra setup. The Chart Design and Format tabs appear when the chart is selected.

You can move the chart by dragging its border, or resize it using the handles around the chart area. To place it on a separate sheet, use Chart Design > Move Chart and choose a new sheet or an object in an existing sheet. A dedicated chart sheet can help when the chart needs to be printed or presented by itself; an embedded chart is convenient when it should sit beside its source data.

Add labels, percentages, and a legend

Labels often make a pie chart easier to read than a legend alone. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position. To control what appears, right-click a data label and choose Format Data Labels. In the Format Data Labels pane, you can select items such as Category Name, Value, or Percentage, and adjust the label position. The exact available options depend on the chart type and Excel build.

For a chart showing composition, percentage labels can make the proportions immediately clear. For a chart where readers also need the original quantities, show both the category name and value, or include the values in a nearby table. Avoid duplicating the same information in labels and a prominent legend if that makes the chart crowded. If labels overlap, try a larger chart, a different label position, shorter category names, or a legend instead. Do not solve crowding by shrinking the text until it is hard to read.

A legend identifies slices by color, but it can be difficult to follow when there are many entries or the colors are similar. Direct labels can help, provided they remain legible. Keep the meaning explicit in the title or a subtitle—for example, state the reporting period and what the values measure. A title such as Monthly Expenses, October 2026 is more informative than the generic Chart Title.

Choose between pie, doughnut, and other chart types

Excel’s 2-D Pie option is a practical default for a small set of categories. A 3-D pie adds perspective effects, but those effects can make slices appear larger or smaller depending on their position. It is usually better to avoid 3-D when accurate visual comparison matters. Exploded pie charts separate one or more slices from the circle to draw attention, but too much separation makes the whole harder to interpret.

A doughnut chart uses a hollow center and can display one or more data series, although additional rings require careful labeling. It can be useful when the center is reserved for a short summary, but do not assume it automatically makes the proportions easier to compare. A bar or column chart is typically a better choice for many categories or close values. A 100% stacked bar is useful when comparing percentage composition across multiple groups, while a regular stacked chart can show both composition and totals.

As a rule of thumb, keep a pie chart to a small number of meaningful categories. There is no universal category limit, but once labels or slices become difficult to distinguish, combine only categories that can honestly be grouped together, or choose another chart. If you create an Other category, calculate it from the omitted categories and say what it includes, rather than using it as an unexplained catch-all.

Format the chart without distorting the message

Use color to distinguish categories, not to imply a ranking that the data does not support. A restrained palette with clearly different hues is easier to interpret than many nearly identical shades. If a specific category deserves emphasis, highlight it consistently and explain why. Do not rely on color alone to communicate essential information; category names and values should remain available for readers who cannot distinguish the colors.

To change colors or apply a coordinated appearance, select the chart and use the Chart Design tab. Chart styles and color choices vary with the Excel version and theme. For more precise changes, select a slice and open its formatting options. In the Format Data Point pane, you can adjust that slice’s fill and other available properties. To rotate the starting position of the slices, right-click the series, choose Format Data Series, and adjust Angle of first slice. Rotation changes where slices appear, not their values, and should not be used to suggest a different conclusion.

Keep backgrounds, borders, and effects simple. A chart should remain readable when printed or copied into a presentation. If you use data labels, check that their text contrasts with the slice color and that labels do not collide. Include a text description or a nearby data table when the chart will be shared with people who may use assistive technology. In Excel, you can right-click a chart and choose View Alt Text to add a concise description; also provide the underlying data when readers need exact figures.

Common problems and how to fix them

The chart has one slice or unexpected labels: Open Chart Design > Select Data and verify the category-label and value ranges. Ensure the selection includes the intended rows and columns.
A total appears as a large slice: Remove the grand-total row from the chart source. The total is not another category in the composition.
Percentages do not add up to exactly 100%: Rounded labels can sum to 99% or 101% even though the underlying proportions sum to 100%. Use more decimal places if exact display matters, while avoiding unnecessary precision.
Labels are missing or crowded: Add data labels through Chart Design > Add Chart Element, then adjust their content and position in Format Data Labels. Consider a larger chart or a bar chart if the categories remain difficult to read.
A category is absent: Check for a zero or blank value, confirm the category is inside the selected range, and inspect filters or hidden rows. A zero has no visible slice.
The slices look wrong: Confirm that the values are numeric and represent the same kind of quantity for the same scope. Check for duplicates, negative values, or an accidentally included total.

When the source data changes, a chart based on a normal worksheet range generally updates when values in that range change. If new rows are added outside the original range, they might not be included. Converting the source range to an Excel table with Insert > Table can make it easier to manage growing data, though check that the chart’s source expands as intended in your workbook.

Excel for Mac and Excel for the web

In Excel for Mac, the same basic process applies: select the data, use the Insert tab, and choose a pie chart from the chart options. Ribbon layout and the names or placement of chart controls can vary by release. Select the chart to reveal its chart-specific tabs, then look for chart design, data selection, and label controls. Mac keyboard shortcuts can differ from Windows shortcuts, but no shortcut is required for the steps above.

Excel for the web also supports inserting and editing charts, including pie charts. Its ribbon and formatting panes may offer fewer controls or arrange them differently from the Windows desktop application. If a particular formatting option is unavailable in the browser, open the workbook in the desktop version of Excel and make the change there. In either version, verify the selected data and labels after insertion; automatic chart formatting can vary with the workbook and interface.

Frequently Asked Questions

How do I show percentages on an Excel pie chart?
Select the chart, choose Chart Design > Add Chart Element > Data Labels, then right-click a label and select Format Data Labels. Turn on Percentage in the pane. You can turn off Value if you want percentages without the raw numbers.

Can I make a pie chart from non-adjacent cells?
Yes. Select the first range, then hold Ctrl on Windows while selecting additional ranges. The ranges must still provide matching category names and values, and the selection can be less straightforward than using a clean, contiguous two-column table. On Mac, use Command while selecting additional ranges.

Why does my pie chart not show every category?
Check whether a category has a zero or blank value, whether its row is included in the chart source, and whether filters or hidden rows affect the displayed data. Very small slices can also be difficult to notice, so add labels or choose a bar chart if every category needs to be clear.

Can an Excel pie chart show multiple data series?
A standard pie chart represents one series of values at a time. If you need to compare several groups, use a doughnut chart only if its rings can be labeled clearly, or consider a 100% stacked bar chart, which is often easier to compare across groups.

How many categories should a pie chart have?
There is no fixed maximum, but a pie works best with a small number of categories that are easy to distinguish. If labels overlap or several slices look almost identical, combine categories only when the grouping is meaningful or switch to 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.