Excel Pie Chart from a Table: Create and Format It

To make an Excel pie chart from a table, select the category names and their numeric values, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel creates a slice for each category; you can add labels and percentages from Chart Design > Add Chart Element > Data Labels.

What a pie chart shows

A pie chart represents one set of values as parts of a whole. Each wedge corresponds to a category, and its share depends on that category’s value compared with the sum of all values being plotted. For example, if a shop sells 40 mugs, 35 notebooks, and 25 pens, the chart shows 40%, 35%, and 25% of the 100 items. The values do not have to be percentages beforehand: Excel calculates each slice’s proportion from the numbers in the source data.

Pie charts work best when the categories are mutually exclusive parts of the same total and there are only a few of them. They are less useful for comparing many similar values, tracking changes over time, or showing categories that do not belong to one meaningful whole. A pie chart is a visual summary, not a substitute for checking the underlying numbers.

Prepare the table before inserting a chart

Use a simple two-column layout: one column for category names and one for values. For instance, a monthly survey might have Region in column A and Responses in column B, with one region per row. Include clear headers, such as Region and Responses, and keep the data contiguous so Excel can identify the chart range easily.

Use one row per category and one numeric value per row.
Remove blank rows and columns within the data block, and check that numbers are stored as numbers rather than text.
Do not include a grand-total row in the chart selection. The total is not another category; including it creates a misleading extra slice.
Combine or omit tiny categories when appropriate, rather than crowding the chart with labels that cannot be read.

Turning the range into an Excel table is useful, though it is not required to make a chart. Select a cell in the data and choose Insert > Table, or press Ctrl+T in Excel for Microsoft 365 on Windows. Confirm that My table has headers is selected if the first row contains column names. On Mac, use Insert > Table; the available shortcut can depend on the keyboard settings. A table gives the data named headers, consistent formatting, and a convenient way to add rows.

Create the pie chart in Excel

Click a cell in the prepared data, or select just the category and value columns, including their headers.
Open the Insert tab, choose Insert Pie or Doughnut Chart in the Charts group, and select 2-D Pie.
Check that the chart uses the category names as slice labels and the numeric column as the values. If Excel interpreted the range incorrectly, select the chart and choose Chart Design > Select Data to review the source.
Move or resize the chart using its border and corner handles. Drag it beside the table or use Chart Design > Move Chart to place it on a separate chart sheet.

If the chart shows one slice for every row but the category names are missing, the source range may not include the labels column or Excel may have read the rows and columns in the wrong direction. In Chart Design > Select Data, use Switch Row/Column if needed, and verify the category labels and series values in the dialog. For the usual two-column layout, there should be one data series and several category labels.

Add percentages and improve readability

Click the chart, then choose Chart Design > Add Chart Element > Data Labels. Select a position such as Outside End, or choose More Data Label Options for finer control. In the Format Data Labels pane, select Category Name and Percentage if you want both the name and share displayed. Clear Value if showing the raw count as well would make the labels crowded. The percentage is calculated from the values plotted in the pie.

Give the chart a descriptive title, such as Responses by Region, rather than leaving a generic title. Use the Chart Design tab to change the chart style or colors, but make sure adjacent slices remain easy to distinguish. If labels overlap, try a larger chart, a different label position, or a legend. For a report, include the unit and time period in the title or a nearby note; a chart titled Sales alone may be ambiguous if readers cannot tell whether the values are dollars, orders, or units.

Ordering categories from largest to smallest in the source table can make a chart easier to scan. The slice order follows the source categories; sorting the table changes that order. Excel also lets you adjust the first slice’s position: right-click a slice, choose Format Data Series, and change Angle of first slice under Series Options. This rotates the pie but does not change any values.

Keep a chart connected to a growing table

A chart made from an Excel table can expand when you add new category rows to that table, which is one reason to use a table rather than a manually selected fixed range. Enter the new record in the row directly below the table and confirm that Excel extends the table formatting. The chart should then include the added row. If it does not, select the chart and inspect Chart Design > Select Data to see whether its source includes the new table data.

Updates can fail when a chart was originally created from cells outside the table, when the table was converted back to a normal range, or when new data was entered too far away to be recognized as part of the table. You can correct the source through Select Data, or recreate the chart by selecting a cell in the table and inserting a new one. If the table has a filter, remember that the visible records may change; check the displayed chart against the filtered data before using it in a report.

Common problems and what they mean

The chart is blank or has no useful slices: Confirm that the value cells contain numeric values and that the selected range includes them. Text such as a number followed by a unit may be stored as text and not chart as intended.
The total appears as a large slice: Remove the grand-total row from the chart source. A total added to its component values counts the same quantity twice.
There are too many labels: Group low-volume categories into a clearly named Other category, or choose a bar chart that can display a longer list more legibly.
A category has a zero value: It has no visible share of the whole, so it may not appear as a visible wedge. Check whether zero is a genuine result or a missing-data placeholder before deciding what to show.
Negative values are present: A pie chart is not an appropriate way to represent positive and negative contributions. Resolve what the negatives mean or choose a chart type that can show direction and magnitude without implying that all values are parts of one positive whole.

Be especially cautious with missing observations. Replacing a blank with zero changes the denominator and therefore every displayed percentage. Likewise, excluding a category changes the shares of the remaining slices. State any exclusions or grouping choices in a note if readers need to understand how the chart was calculated.

When to choose another chart

A pie chart is not automatically the clearest choice just because the data adds to a total. People generally compare wedge angles less precisely than they compare positions along a common scale. If you have many categories, several values close in size, or a need to compare exact amounts, a clustered bar or column chart is often easier to read. A bar chart is also a better fit when values include negatives.

For a time series, such as monthly sales, use a line chart or column chart rather than one pie per month. Multiple pies make it difficult to compare changing shares across periods. If the goal is to emphasize a part-to-whole relationship across a small number of categories, a 2-D pie can be suitable; avoid 3-D effects because perspective can make slices look larger or smaller than their actual values. A doughnut chart uses the same kind of part-to-whole data but leaves a hole in the middle; it does not solve the problem of too many categories.

Frequently Asked Questions

Can I make a pie chart directly from an Excel table?
Yes. Click a cell in the table, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Check the resulting chart to ensure the category column supplies the labels and the numeric column supplies the values.

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 to show which slice each percentage belongs to.

Will an Excel pie chart update when I add a row?
It normally updates when its source is an Excel table and you add the row as part of that table. If it does not, check Chart Design > Select Data and confirm that the chart source covers the table’s current data.

Can a pie chart show more than one data series?
A standard pie chart displays one data series at a time. If your source has several numeric columns, Excel may use only one series or prompt you to interpret the data. For comparisons across multiple series, use a different chart type or make separate pies only when each pie represents a clearly defined whole.

Why does my pie chart show the total as a slice?
The total row was probably included in the selected data. Remove it from the chart range; the category values alone should make up the whole. Adding the total alongside its component values inflates the plotted sum and makes the shares misleading.

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.