Pie Chart Creator in Excel: Make and Format a Chart

Excel has a built-in pie chart creator: select a category-and-value table, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel creates the chart from your selected data; you can then add labels, change its colors, and adjust the title from the chart tabs on the ribbon.

What a pie chart shows—and when to use one

A pie chart represents one data series as slices of a whole. Each slice corresponds to a category, and its size reflects that category’s share of the total. For example, a table of monthly expenses by category can show how rent, food, transport, and utilities divide up the month’s spending. Excel calculates each slice’s proportion from the values; you do not need to calculate percentages first.

Pie charts work best when the categories are parts of the same meaningful total and there are only a few of them. They are useful for a quick view of proportions, not for showing change over time or comparing many similar values. A column or bar chart is usually easier to read when you have numerous categories, small differences, or values that do not add up to one whole.

A pie chart is not automatically a percentage chart in the source data. If the values are 40, 35, and 25, Excel treats them as parts of a total of 100. If they are 40, 35, and 15, Excel treats them as parts of a total of 90 and displays their relative shares. Make sure the figures truly belong together before presenting them as a whole.

Prepare the data before inserting the chart

Put category names in one column and their corresponding numeric values in the next. Include a descriptive header row if you have one. A simple example might be:

Column A: Expense category
Column B: Monthly amount
Rows below the headers: Rent, food, transport, and other categories, with one value per row

Keep the table simple: one category column and one set of values. Check that each name lines up with the correct number and that the values are numeric rather than text that only looks like a number. Avoid including a grand-total row in the selected range. Including it makes the total appear as another slice, distorting the meaning of the chart.

Before charting, consider whether every row belongs in the same total. A list combining unrelated measures, such as units sold and dollars earned, does not make a sound pie chart. Also check for duplicate category names and decide whether they should be combined. A pie chart can display many slices, but too many narrow segments make the labels and comparisons difficult to interpret.

Create a pie chart in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, create a basic chart with these steps:

Select the category names and values, including the headers if present. For a contiguous table, drag across both columns and the relevant rows.
Open the Insert tab on the ribbon.
Choose Insert Pie or Doughnut Chart in the Charts group.
Select 2-D Pie for a conventional flat pie chart. Excel inserts the chart into the worksheet.
Click the chart title and replace the placeholder with a clear description, such as Monthly expenses by category.

If Excel assigns the categories or values incorrectly, click the chart and open Chart Design > Select Data. In the Select Data Source dialog, check the chart data range and the series and category assignments. You can also resize or move the chart by dragging its border; drag a corner handle to change both dimensions while keeping its proportions more consistent.

Excel’s ribbon labels and arrangement can vary slightly with window size and updates, but the Insert tab is the starting point. On Excel for Mac, select the data and use the Insert tab’s pie-chart controls; the chart options are similar, although their placement can differ. Excel for the web also supports creating and editing charts, but some detailed formatting controls may be more limited than in the desktop application.

Add labels that explain the slices

A chart without category names can be hard to interpret. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a label position. To decide exactly what appears, choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, you can select items such as Category Name, Value, and Percentage. The available options depend on the chart and Excel version.

For a small pie, category names and percentages are often enough. Showing both the raw value and percentage can be useful when readers need to see the amount as well as its share, but it can crowd the chart. If labels overlap or become too small, try moving them to the outside, showing fewer label fields, or using a legend to identify categories. A legend identifies slices by color; it does not give the exact values unless those are also included as labels.

Percentages are calculated from the displayed values, so they may appear rounded and add up to 99% or 101% rather than exactly 100%. That is normally a rounding effect, not evidence that Excel has lost data. If you need precise amounts, show the values as well or provide the source table alongside the chart.

Format colors, title, and chart appearance

To change the chart’s overall color palette, select it and use Chart Design > Change Colors. The Chart Design tab also offers chart styles that adjust the visual treatment. For more control over an individual slice, select the pie and then select the slice again; use the formatting options to change that data point’s fill. Be consistent: colors should help readers distinguish categories, not imply a ranking that the data does not support.

Use a title that names the subject and, when relevant, the time period or unit. A label such as Sales mix, Q2 2026 is more informative than Chart Title. To add a legend or other chart element, use Chart Design > Add Chart Element. You can also use the plus-shaped Chart Elements button beside a selected chart in many desktop layouts to toggle common elements.

Excel offers 3-D Pie and doughnut charts as well as 2-D Pie. Three-dimensional perspective can make slices appear larger or smaller depending on their position, so it is generally a poor choice when accurate visual comparison matters. A doughnut chart uses the same part-to-whole idea but leaves a hole in the center; it is not a solution to having too many categories. For straightforward comparison, a flat 2-D pie is usually the clearest starting point.

Choose the right chart for the data

Excel pie charts are designed around one data series. If your selection contains multiple value columns, Excel may use only one series or produce a chart that does not communicate the comparison you intended. For example, comparing each department’s expenses across three years is usually clearer as a clustered column chart than as several pie charts. A single pie cannot show a time trend in a meaningful way.

Use a pie chart when readers need to understand a small set of category shares in one snapshot. Consider another chart type when:

There are many categories or several slices are too small to label clearly: use a bar chart, or combine minor categories only when that grouping is meaningful and disclosed.
You need to compare exact values or small differences: use a bar or column chart with a value axis.
You want to show values over dates: use a line chart or, for a small number of periods, a column chart.
You need to compare parts across several groups: consider a stacked bar or column chart, while taking care not to make comparisons harder than necessary.

Excel also offers Bar of Pie and Pie of Pie chart types in supported desktop versions. These split smaller categories into a secondary chart, but they can be harder to follow than a simple bar chart. Use them only when the split is important and the relationship between the main pie and the secondary sections is made clear.

Common problems and how to fix them

If the chart is blank or a slice is missing, first inspect the selected range and the source values. Confirm that the values are numeric, that the category and value ranges have matching rows, and that the range does not accidentally include blank rows or a total. A zero value contributes no visible slice. If you add categories below the original data range later, the chart may not include them automatically; check Chart Design > Select Data or use an Excel Table as the source so the chart can better accommodate rows added to the table.

If the wrong labels appear, open Select Data and verify that the category labels point to the name column. If the chart seems to show only one slice, check whether the selected values include multiple nonzero categories and whether Excel interpreted them as numbers. If a category is named but has a blank or zero value, it may not produce a visible slice.

If the chart looks cluttered, do not try to solve every issue by shrinking the font. Reduce the number of categories where the data can be legitimately grouped, remove unnecessary label fields, or switch to a bar chart. Also avoid relying on color alone: include category names in labels or a readable legend so the chart remains understandable to readers who have difficulty distinguishing colors.

Keep the chart useful when sharing it

A chart should make sense outside the person’s workbook. Give it a meaningful title, use units where necessary, and keep the source data nearby or include a note explaining what is counted. If the values are a sample, estimates, or a particular time period, say so. A pie chart can look authoritative even when the underlying categories are incomplete or not comparable, so clear context matters.

When copying the chart into a report or presentation, check that labels remain readable at the final size. In Excel, you can copy the chart and paste it into another Office app; the exact paste choices depend on the destination application. If the chart must update with the workbook, choose a linked paste option when available. If the recipient only needs a fixed image, paste it as a picture instead. Keep the workbook’s source figures available when others may need to verify or update the chart.

Frequently Asked Questions

Where is the pie chart creator in Excel?
Select the data, open the Insert tab, and choose Insert Pie or Doughnut Chart in the Charts group. Pick a chart style, such as 2-D Pie. After insertion, use Chart Design and Format to adjust its elements and appearance.

How do I show percentages on an Excel pie chart?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Percentage. You can also select Category Name or Value if those details are useful.

Can I make a pie chart with multiple data series?
A standard Excel pie chart represents one series of values. To compare several series, such as different years, choose a chart type suited to the comparison, such as a clustered column or bar chart, rather than expecting one pie to show multiple series clearly.

Why do my pie chart percentages not add up to 100%?
Excel may round the displayed percentages, so the visible labels can total 99% or 101%. The underlying slices are calculated from the values. If the difference is larger, verify that the selected range contains the intended values and excludes totals or unrelated rows.

Can I create a pie chart in Excel without percentages in the source table?
Yes. Enter the category values, select them, and insert the chart. Excel calculates each slice as a proportion of the total. You can choose to display those calculated percentages as data labels afterward.

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.