Excel Pie Chart Not Working? Fix Common Data Issues

If an Excel pie chart is blank, incomplete, or showing the wrong slices, first check that its source contains one category column and one numeric column with at least one positive value. Select those cells, then use Insert > Insert Pie or Doughnut Chart > 2-D Pie; if the chart already exists, use Chart Design > Select Data to correct its source range.

Start by checking the chart’s source

A pie chart represents parts of one whole: each category is a slice, and each value determines that slice’s share of the total. Many apparent chart failures come from Excel interpreting the selected cells differently than expected, so inspect the source before changing colors or rebuilding the workbook.

A straightforward source table might look like this:

Column A: category names, such as Apples, Oranges, and Pears.
Column B: the corresponding values, such as 40, 35, and 25.
Row 1: optional headings, such as Fruit and Quantity.

For that example, select A1:B4, including the headings, and insert a 2-D pie chart. Excel should use the first column for category labels and the second for the slice sizes. If the categories and amounts are separated by unrelated columns, select the category range and the value range together with Ctrl-clicking on Windows, or Command-clicking on Mac. For a first attempt, a compact two-column table is usually easier to troubleshoot.

Also confirm that the data describes a meaningful whole. A pie chart is not suitable for comparing unrelated totals, negative values, or a time series with many dates. It can display only one data series at a time; if your selection includes several value columns, simplify the range or use a chart type designed for multiple series.

Prepare a pie-chart-friendly source table

Each category should have one value, and the value cells should contain numbers Excel recognizes as numbers—not text that merely looks numeric. Click a suspect cell and check its alignment and the formula bar, but do not rely on alignment alone: custom formats can make numbers appear unusual. One quick check is to select the values and look at the status bar; Excel commonly shows a sum for numeric selections. If it shows only a count, some entries may be text or blanks.

Text values can enter a sheet through a copied report, a CSV import, or an apostrophe typed before a number. If Excel displays a green error indicator, use its warning menu and choose Convert to Number when appropriate. Otherwise, reimport or clean the data so the amounts are genuine numbers. Check decimal and thousands separators too: a value such as 1,25 may be read differently depending on regional settings. Do not replace separators blindly if the data includes different formats.

Look for these source-table problems before creating the chart:

Blank category names, merged cells, or extra title rows inside the selected range.
Totals or subtotals included as categories, which inflate the whole and distort every slice.
Duplicate category names that should be combined, or labels that are too long to read.
Negative values, errors such as #N/A, and formulas that return an empty string.

A zero has no visible slice, so a category with a zero value may appear absent even though it is in the data. Negative values cannot represent a share of a positive whole in a standard pie chart. If there are errors or negative figures, determine what they mean and clean or summarize the source rather than treating the chart as a data-cleaning tool.

Insert or repair the chart in Excel

In Excel for Microsoft 365 on Windows, select the source cells and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. A 3-D pie is available in the same chart menu, but it can make slice sizes harder to compare because perspective changes their apparent area. Start with a 2-D chart unless a specific presentation requirement calls for another style.

To repair an existing chart, select it and choose Chart Design > Select Data. In the Select Data Source dialog, inspect the chart data range and make sure it includes the intended labels and values, without unrelated columns or a total row. If the range is wrong, edit it or select the data directly on the worksheet. The Series values should point to the numeric cells; the category labels should point to the text cells. Click OK and check whether the chart updates.

If Excel has assigned the wrong row or column, the dialog’s Switch Row/Column button may help, but it does not fix an unsuitable layout. For a basic pie, the clearest structure remains one category column and one value column. If the chart is tangled or its source is difficult to correct, deleting it and inserting a new chart from a clean selection can be faster than repeatedly adjusting the series.

Excel for Mac uses the same general Insert and Chart Design concepts, though ribbon placement and dialog appearance can differ by release. In Excel for the web, chart creation and basic editing are available, but some detailed formatting and data-source controls may be less convenient than in the desktop app. If a control is missing, open the workbook in the desktop version rather than assuming the chart itself is broken.

Fix a blank chart or one that will not update

If the chart frame appears but has no visible slices, first revisit the data range. It may include headings but no values, point to empty cells, or exclude the rows containing the numbers. Use Chart Design > Select Data to verify the range. Then check whether the values are all zero, negative, text, or errors. A pie with no positive numeric values has no meaningful slices to draw.

Next, check whether the data is hidden or filtered. In the Select Data Source dialog, open Hidden and Empty Cells and inspect the option to show data in hidden rows and columns. If relevant rows are excluded by a worksheet filter or hidden, the chart may not show them under its current settings. In desktop Excel, selecting the chart may also reveal a Chart Filters button; use it to check whether categories or series have been unchecked. The button’s availability and presentation can vary with the app and chart selection.

When values come from formulas, confirm that the formulas have recalculated and that they return usable numbers. A formula returning an empty string looks blank but is not the same as a positive number for charting purposes. If calculation appears stale, check Formulas > Calculation Options; Automatic is the typical setting for workbooks that should update when inputs change. Be cautious about changing calculation mode in a shared workbook, because it affects workbook behavior beyond the chart.

Finally, distinguish a blank chart from a chart hidden behind another object or placed on a hidden worksheet. Use the sheet tabs and the Selection Pane, available from Home > Find & Select > Selection Pane, to inspect overlapping objects. This is less common than a bad source range, but it matters when the chart exists in the workbook and cannot be seen on the sheet.

Correct slices that are missing or misleading

If one or more expected categories are absent, look for zero values, filtered categories, hidden rows, and labels or values outside the selected range. Also check whether a category’s value is stored as text. If the chart shows only one large slice, the source may contain one numeric value and several text values, or the series may point to just one cell. Correct the data range and verify that each category has a corresponding numeric entry.

Unexpectedly large slices often result from including a subtotal or grand total as though it were another category. For example, charting three department figures and a fourth row labeled Total counts the total again, so the chart no longer represents the intended parts of the whole. Exclude the total row from the chart range. Similarly, if categories repeat across several records, decide whether to summarize them first; a pie chart should show the intended categories, not accidental duplicate rows.

Excel calculates each slice as a share of the sum of the plotted values. In a table with values 40, 35, and 25, the total is 100, so the slices represent 40%, 35%, and 25%. If you add a separate value of 100 for the total, the denominator becomes 200 and the total itself becomes half the pie. That is why including a total row can make every other slice appear too small even though the underlying figures are unchanged.

Make labels and formatting readable

A chart can be working correctly but still seem broken if labels are missing, clipped, or difficult to interpret. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a placement. To show more detail, use Chart Design > Add Chart Element > Data Labels > More Data Label Options, then choose items such as Category Name, Value, or Percentage in the formatting pane. Exact options can vary slightly with chart type and Excel version.

Use category names or percentages when readers need to understand what each slice means. Showing only values may be unclear without a legend, while displaying category, value, and percentage together can overcrowd a small chart. If there are many categories, combine very small values into a clearly explained Other group or choose a bar chart so labels remain legible. Keep the source data intact if you group categories only for presentation, and explain how the grouping was made.

To change the slice colors, select a slice and use the formatting controls, or choose a chart style from Chart Design. Avoid relying on color alone to convey meaning: retain readable labels and use sufficient contrast. If the chart looks flat or has an unexpected legend, verify the chart type and selected data before adjusting formatting; styling cannot correct incorrect source values.

Know when another chart is a better choice

Pie charts work best when there are a few categories that add up to a meaningful whole and the differences are easy to see. They become difficult to read when there are many similarly sized slices, long labels, or several series to compare. A bar chart is often clearer for ranking values or comparing categories across periods, while a line chart is generally more suitable for showing change over time.

A doughnut chart is similar to a pie chart and also represents one series as parts of a whole, but it has a hole in the center. It does not solve problems with negative values, unclear categories, or an incorrect source range. A 100% stacked bar can help compare proportions across multiple groups, something a standard pie chart cannot communicate with several series in one chart. Choose the chart based on the question the reader needs answered, not just on the shape that looks familiar.

Frequently Asked Questions

Why is my Excel pie chart showing only one slice?
Check that the chart series includes all the numeric value cells and that the values are numbers rather than text. Also make sure the chart filter has not excluded categories and that the other values are not zero or blank.

Why does my pie chart show the wrong percentages?
Excel calculates percentages from the values included in the chart. Remove any grand total or subtotal included as a category, and confirm that the chart range does not include unrelated values. The visible percentages should add to approximately 100%, subject to rounding.

Can an Excel pie chart display negative numbers?
A standard pie chart is intended for nonnegative parts of a whole, so negative values cannot be represented as ordinary slices. Review what the negative entries mean and use a chart type that can communicate positive and negative values if they are important.

Why are some labels or rows missing from my pie chart?
Check the source range, worksheet filters, hidden rows, and chart filters. In Chart Design > Select Data, inspect the series and category references and the Hidden and Empty Cells settings. A zero value also has no visible slice.

How do I make an Excel pie chart update when data changes?
If the chart references the cells you edit, changes to those values should update the slices. Use Chart Design > Select Data to check the source range; if you regularly add rows, consider converting the source range to an Excel table so its data range can expand with new entries. If values are formula-driven, check that calculation is set appropriately and that the formulas return numbers.

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.