Excel Pie Chart Not Showing? Fix the Data and Display

If an Excel pie chart is not showing, first check that its source range contains one series of numeric values and category labels, with at least one positive value. Select the chart, open Chart Design > Select Data, and confirm the range; then check chart filters, hidden rows, and display settings if the chart is still blank or incomplete.

What a pie chart needs to display

A pie chart turns one series of values into slices that represent parts of a whole. For example, a small table with category names in A2:A4 and sales figures in B2:B4 can show each category’s share of the combined sales. The labels identify the slices; the numbers determine their relative sizes.

That one-series requirement is an important difference between a pie chart and a column chart. If your selection includes several numeric columns, Excel may choose an unexpected series or interpret the rows and columns differently than you intended. A pie chart is also a poor fit for negative figures, since parts of a whole should be positive amounts. Use a chart type such as a column chart when you need to compare positive and negative values.

Zeros do not create visible slices, and a chart with no usable positive values cannot show a meaningful pie. If every value is zero, blank, or stored as text, the chart may look empty even though the chart object exists. Check the source cells before changing the chart’s appearance.

Check the source range and chart type

For a straightforward chart, arrange the data in two adjacent columns: one for labels and one for values. Include a header row if you have one, and select just the labels and the single value series. Then choose Insert > Insert Pie or Doughnut Chart and select a pie style. Excel for Microsoft 365 on Windows may display the chart-type choices as icons in the Charts group on the Insert tab.

If a chart already exists, select it and choose Chart Design > Select Data. Review the Chart data range and the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels. The series should point to the intended numeric cells, and the category labels should point to the names beside them. Correct the ranges if they include a title, unrelated columns, or empty cells where the data should be.

Keep one value series for the pie and use the neighboring cells for its category names.
Check that the selected range includes the first and last intended categories.
If Excel has interpreted rows and columns backwards, try Chart Design > Switch Row/Column, then confirm that the result is one series with the expected labels.
If the chart is a different type, select it and use Chart Design > Change Chart Type to choose a pie chart.

On Mac, the chart tabs and commands can look different depending on the Excel version and window width, but select the chart and look for the Chart Design tab and its data-selection or chart-type commands. Excel for the web also supports creating and editing many charts, though some advanced formatting and chart controls can differ from desktop Excel.

Find values that Excel cannot plot as slices

Numbers that look correct on the worksheet may not be numeric values. A number imported from a text file, for instance, can be stored as text. Excel may align it differently from nearby numbers, or show a warning indicator. In that case, convert the cells to numbers and confirm the chart updates. Depending on the data, you can use the warning menu to convert text to numbers or clean and re-import the source data.

Also check for formulas that return an empty string, cells containing spaces, and error values. A formula that displays a blank is not the same as a positive amount, so it will not supply a visible slice. Clear unintended spaces and fix errors in the source. If a category legitimately has no amount, a zero is clearer than a text placeholder such as “none.”

For a quick test, enter a few temporary category names and positive numeric values in unused cells, select them, and insert a pie chart. If that simple chart appears, the original problem is likely in the source data, selection, or chart settings rather than Excel’s ability to draw a pie. Remove the test data afterward if it is not needed.

Check hidden, filtered, and empty data

Hidden rows or columns can affect what a chart includes. By default, chart data in hidden rows and columns is not necessarily displayed. Select the chart, go to Chart Design > Select Data, and open Hidden and Empty Cells. If appropriate, turn on Show data in hidden rows and columns. The option is useful when the source is deliberately hidden but should still contribute to the chart; it is not a substitute for checking whether the values are correct.

Worksheet filters can also change which categories are visible in a chart. If slices disappear after filtering a table, clear the filter temporarily and compare the chart. Some charts also show a Chart Filters button when selected; open it and make sure the needed categories or series are checked. Filtered or excluded categories change the total represented by the visible pie, so percentages may be recalculated rather than remaining the same as before.

Empty cells have their own setting in the Hidden and Empty Cells dialog. A blank cell cannot produce a slice, but the way Excel treats an empty point can matter for other chart types. For a pie chart, focus first on whether each category that should appear has a valid, positive numeric value and whether the chart includes that cell.

When the chart exists but looks blank

Sometimes Excel has created a chart object, but its contents are hard to see. Click where the chart should be and look for selection handles or the Chart Design tab. If the chart is selected, inspect its size and position: it may be very small, moved behind another object, or placed outside the visible part of the worksheet. Drag it into view or use the sizing handles to make it larger.

Formatting can hide a chart without removing it. A white chart area on a white sheet is normally still visible because of its border or selection handles, but a white font, transparent or unusual fills, or a very small plot area can make the pie difficult to see. Select the chart and review the Format options for the Chart Area and Data Series. You can also apply a built-in style from Chart Design to reset the presentation to a more legible starting point.

On Windows desktop Excel, a workbook setting can hide drawing objects, including charts. Check File > Options > Advanced, then under Display options for this workbook find For objects, show and select All. If the sheet is protected, protection may restrict moving or editing a chart; the workbook owner may need to allow those actions or unprotect the sheet. Do not remove protection unless you are authorized to do so.

If the object is difficult to locate among other shapes, open Home > Find & Select > Selection Pane. The pane lists objects on the sheet and can help you identify whether the chart is present or hidden. The pane is especially useful when a chart overlaps a picture or another chart.

Make sure changes to the data reach the chart

Charts based on ordinary cell ranges usually update when those cells change, but the chart will not automatically include data entered outside its source range. Select the chart and review Chart Design > Select Data to see whether the new rows or columns are included. Expand the range if needed, or select the updated data and create a replacement chart.

Using an Excel Table can make a chart easier to maintain when you add rows of records. Select the data and choose Insert > Table, confirm whether the table has headers, and create the chart from the table. As table data grows, chart references can expand with it. Still, check that new entries use the expected columns and numeric values; a table cannot make text or blank amounts into meaningful slices.

If values are produced by formulas, verify that calculation has finished and that the displayed results are what you expect. If the workbook uses manual calculation, formula results may not update immediately. On Windows, Formulas > Calculation Options shows the calculation mode; choosing Automatic allows Excel to recalculate formulas as inputs change. Mac has calculation options on the Formulas tab as well. If the chart still seems stale, save the workbook, recalculate, and inspect the source cells directly.

Choose a chart that fits the data

A pie chart is best for a small set of categories that make up one whole. It becomes hard to read when there are many thin slices, long labels, or values that are close in size. Combining tiny categories into a clearly labeled “Other” group can help, provided that grouping is appropriate for the analysis and the underlying figures remain available.

A doughnut chart uses the same basic one-series, part-to-whole idea, so changing a blank pie to a doughnut will not fix invalid or missing source values. A bar or column chart is often clearer when readers need to compare category amounts precisely, when there are many categories, or when values can be negative. A stacked chart may be suitable for certain comparisons across multiple groups, but it answers a different question from a simple pie.

One common misconception is that changing colors or adding data labels will make missing data appear. Labels can clarify existing slices, but they do not create a slice for a blank, text, or zero value. First confirm that the data is valid and included; then use labels or formatting to make a correctly plotted chart easier to understand.

Frequently Asked Questions

Why is my Excel pie chart blank?
Check that the chart’s source range includes numeric values and that at least one intended value is positive. Also inspect the series range, hidden or filtered categories, and whether the chart object is hidden or formatted so its contents blend into the background.

Why does my pie chart show only some of my data?
The source range may omit rows, or filters and hidden rows may exclude categories. Select the chart and review Chart Design > Select Data, then check the chart’s filter controls and the Hidden and Empty Cells settings.

Can an Excel pie chart show negative numbers?
A pie chart is meant to show positive parts of a whole, so negative amounts are not an appropriate basis for interpreting its slices. Use a column or bar chart when negative and positive values both matter.

Why is my chart not changing when I update the worksheet?
Confirm that you edited a cell inside the chart’s source range and that the chart includes any newly added rows. If formulas supply the values, check their results and the workbook’s calculation mode.

Why are some pie slices missing after I filter the table?
The chart may be reflecting the filtered data or have categories excluded in Chart Filters. Clear the worksheet filter and review the chart filters to see whether the missing categories return.

Does changing a pie chart to a doughnut fix a blank chart?
No. Pie and doughnut charts use the same general kind of part-to-whole data. If the values are blank, text, zero, excluded, or outside the selected range, changing between those chart types will not solve the source-data problem.

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.