How to Make a Pie Chart in Excel

To make a pie chart in Microsoft Excel for Microsoft 365 on Windows, arrange category names in one column and their values in the next, select both columns including the headers, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Add a chart title and, if useful, data labels from Chart Design > Add Chart Element. The chart shows each value as a share of the total.

Prepare the data for a pie chart

A pie chart works best when each row represents one category and each value represents that category’s part of a single whole. For example, a small shop might summarize one month of sales like this:

Books — 420
Games — 280
Stationery — 180
Gifts — 120

The total is 1,000, so the four categories represent 42%, 28%, 18%, and 12% of sales. Excel calculates the proportions from the values in the selected range; the values do not need to be entered as percentages or add up to 100. Make sure the numbers measure the same thing and cover the same time period. Mixing units, such as dollars with number of items, makes the whole meaningless.

Put a clear heading above each column, such as Category and Sales, and keep the category labels short enough to read in a legend or beside the slices. Avoid blank rows or columns inside the data range because Excel may interpret them as breaks or leave out part of the table. A single summary row for each category is usually easier to chart than detailed transaction records. If your source data contains many transactions, create a summary first, for example with a PivotTable, or use a suitable total for each category.

Use nonnegative values that can reasonably be understood as parts of a whole. A pie chart is not suitable for showing losses alongside gains, changes over time, or categories whose values overlap. If the values are counts, sales amounts, or portions of a budget, state the measure and period in the chart title or nearby text.

Insert the chart in Excel

Click and drag to select the category and value columns, including their headings. In the example, select the cells containing Category, Sales, and the four rows of data.
Open the Insert tab on the ribbon.
In the Charts group, choose Insert Pie or Doughnut Chart.
Under 2-D Pie, select the standard Pie option.
Check that the chart contains the intended labels and values. Move or resize it by dragging its border or corner handles.

Including the headings helps Excel identify what the data represents and can supply a useful default chart title or legend label. If the chart appears blank or does not include all categories, check that the selected cells contain numeric values and that the range includes the full table. You can also select a cell inside a well-organized table before inserting the chart; Excel may detect the adjacent data automatically, but reviewing the selected range is still worthwhile.

Excel adds the chart as an object on the worksheet. Click it to show the chart-specific tabs, including Chart Design and Format. To change the chart type later, use Chart Design > Change Chart Type and choose another pie style or a different kind of chart. The exact appearance of the ribbon can vary slightly with window size and Excel updates, but the Insert tab is the usual starting point in Microsoft 365 for Windows.

Show category names and percentages

A pie chart can be understandable with a legend, but labels placed on the slices often make it quicker to read. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position, such as Outside End. The position options depend on the chart type and available space. You can also use the green plus button next to a selected chart in Windows to turn on Data Labels.

To choose what each label displays, right-click a data label and select Format Data Labels. In the Format Data Labels pane, turn on options such as Category Name, Value, or Percentage and turn off items you do not need. For the shop example, Category Name and Percentage communicate both what each slice means and its share of the 1,000 total. Showing the raw value as well can help when readers need the underlying amounts. If a label becomes crowded, remove one of the fields or move labels outside the pie and retain a legend.

Percentage labels are calculated from the plotted values, not from a separate percentage column. Excel may round the displayed percentages, so the visible labels can add up to 99% or 101% even though the underlying shares total 100%. That is a rounding effect, not necessarily a data error. If precision matters, use an appropriate number format or include a note that percentages are rounded.

A useful title tells readers what the whole represents and, when relevant, the time period. For instance, Monthly sales by product category, October is more informative than Sales. Click the title area in the chart to edit it. If a chart title is not visible, use Chart Design > Add Chart Element > Chart Title and choose a position.

Format slices and improve readability

For a clean chart, keep the design restrained and make the largest categories easy to distinguish. Select the chart and use the Chart Design tab to browse chart styles or change colors. To format an individual slice, click the pie once to select the series and click the slice again to select that point; right-click it to open formatting options. A slice can be separated slightly from the rest of the pie, but avoid pulling out many slices because that makes comparisons harder.

Use a short legend or direct labels that clearly identify every category.
Choose colors with enough contrast to distinguish neighboring slices.
Keep labels legible at the size where the chart will actually be viewed or printed.
Use a consistent order and color scheme if readers will compare several pies.
Do not rely on color alone when the chart needs to be accessible; include readable category names.

In most charts, Excel assigns colors automatically. You can change the overall palette through Chart Design > Change Colors. To adjust one slice, select it and use Format Data Point in the formatting pane; available fill and border controls depend on the selected chart element. Avoid a 3-D pie for precise comparisons. The perspective can make slices at the front appear larger than slices of the same value at the back.

You can reposition a chart by dragging its outer border. To change its size, drag a corner handle; holding Shift while resizing is not a reliable way to preserve proportions in every Excel context, so check the result visually. For a more exact size or position, select the chart and use the Format tab’s size controls when they are available in the ribbon layout.

Fix common pie chart problems

If Excel plots the category names as values, or treats the first column as a second data series, inspect the selected range and chart setup. A standard pie chart represents one series of values, with each value forming one slice. Select the chart and choose Chart Design > Select Data to review the chart data range and series. If Excel has interpreted rows and columns in the wrong direction, try Chart Design > Switch Row/Column. For a simple two-column list, categories should usually be in one column and the corresponding numbers in the next.

If a category is missing, check for a blank or text entry in its value cell, and confirm that the cell lies inside the chart’s source range. Numeric-looking values stored as text may not be plotted as expected. If new rows are added after making the chart, Excel may not include them automatically, especially when the source is an ordinary range. Update the range through Chart Design > Select Data, or format the source as an Excel table so the chart can use a structured, expanding data source in common workflows.

If labels overlap, try a different data-label position, remove redundant fields, widen the chart, or use a legend. Very small slices are especially difficult to label. Combining tiny categories is appropriate only when the grouping is meaningful and disclosed; do not hide categories simply to make the picture look neater. If several categories have similar values, readers may not be able to compare them accurately by eye even when every label is visible.

If the chart looks wrong after editing the source cells, confirm that the correct cells are linked and that the values are not duplicated. A pie chart’s slice sizes change when its source data changes. For a snapshot that must not update, you can copy the chart and use Paste Special options to paste it as a picture, but the pasted image will no longer respond to changes in the data.

When a pie chart is the right choice

Use a pie chart when the question is specifically about how a small number of categories divide one total, and all categories belong to the same whole. It can work well for a brief summary, such as the share of a department’s budget by expense type, provided the categories are mutually exclusive and together account for the stated total.

Use a bar or column chart when the main task is comparing category amounts, especially when there are many categories or values are close together. Bar lengths are easier to compare than slice angles. A line chart is usually more suitable for a trend across dates, while a stacked bar can show composition across several groups or time periods. These alternatives are not merely different visual styles: they answer different questions. A pie shows composition at one point or over one defined period, not how the parts change through time.

As a practical rule, keep a pie chart to a manageable number of categories. There is no universal cutoff, but a chart with many narrow slices, lengthy labels, or several nearly equal values is hard to interpret. If a reader needs exact comparisons, include a table of values or choose a bar chart. A doughnut chart, available in the same Insert Pie or Doughnut Chart menu, is also a part-to-whole display with a central hole; it does not solve the difficulty of comparing many similar slices.

Excel on Mac and Excel for the web

The instructions above describe Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, the same general workflow applies: select the data, use the Insert tab, choose a pie chart, then use the chart-design controls to add a title or data labels. Ribbon placement and some control names can differ between Mac and Windows, so look for the chart-type and chart-element controls on the Insert and chart design tabs.

Excel for the web also supports creating and editing charts from selected worksheet data, though its ribbon and chart-formatting pane can differ from the desktop app and some detailed formatting choices may be limited or arranged differently. If a particular option is not available in the browser, open the workbook in the desktop version of Excel and make the adjustment there. A chart saved in a workbook can generally be viewed in the web app even if a specific formatting action requires desktop Excel.

Frequently Asked Questions

How do I show percentages on a pie chart in Excel?
Select the chart, choose Chart Design > Add Chart Element > Data Labels, then right-click a label and select Format Data Labels. Turn on Percentage. Add Category Name as well if readers need to identify each slice without consulting the legend.

Do the values have to add up to 100?
No. Excel calculates each slice as a share of the total of the plotted values. Values such as 420, 280, 180, and 120 produce the same proportions as 42, 28, 18, and 12. Use values from the same measure and scope so the total is meaningful.

Why is my pie chart showing the wrong data?
Check that the chart source includes both the category labels and their matching numeric values, and that the pie contains only the intended value series. Use Chart Design > Select Data to inspect the range. For a simple category-and-value list, try Switch Row/Column if Excel has interpreted the layout incorrectly.

Can I make a pie chart with multiple data series?
A standard pie chart displays one series at a time. If you need to compare multiple groups, use a bar, column, or other chart designed for multiple series, or create separate pies only when each one represents a clearly defined whole and the comparison remains easy to read.

How do I add a new category to an existing pie chart?
Add the category and its value to the source data, then check whether the chart includes the new row. If it does not, select the chart and use Chart Design > Select Data to expand the chart data range. A chart based on an Excel table may include added rows more conveniently.

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.