Excel Pie Chart Not Updating? Fix the Data Range Now

An Excel pie chart usually misses new data because its source range still ends at the old last row. Select the chart, choose Chart Design > Select Data, and extend the chart data range; for future additions, use an Excel Table as the source and add new rows within that table.

Start by identifying what is not updating

First check whether the chart is missing a category, displaying an old number, or showing no visible change at all. Those symptoms point to different causes. A new row that is not represented usually means the source range does not include it. A slice that stays the same size after a cell changes may indicate a calculation, data-type, or refresh issue.

Click the chart and compare its selected source cells with the worksheet data. On Excel for Microsoft 365 for Windows, select the chart and open Chart Design > Select Data. The Chart Data Range box shows the cells used by the chart, while the entries below it identify the plotted series and category labels. If the new row is outside those references, Excel cannot use it.

Also check that you are looking at the correct chart and worksheet, especially in a workbook with several similarly named sheets. If the chart is a PivotChart, treat it differently: its source is a PivotTable, and new source records generally need a refresh before they appear.

How an Excel pie chart uses its source data

A pie chart represents parts of one whole. Its source normally consists of one set of category labels and one set of numeric values, such as product names in column A and sales in column B. The labels become the slice names, and the values determine the relative slice sizes. If your chart uses A1:B4, adding a fifth product on row 5 does not necessarily make that fixed range become A1:B5.

Excel charts are linked to cell references, not to the general idea of “all data in this area.” A chart created from a selected block of cells usually stores references to that block. Typing below it can leave the original reference unchanged. This is why a chart can appear healthy and still omit new records: Excel has no reason to assume the additional row belongs to the chart.

For a pie chart, make sure the selected data has one meaningful numeric series. If you include several value columns, Excel may plot a different series than you intended or produce a chart that does not communicate the categories as expected. Avoid including a grand-total row as a slice: the total would be counted alongside the individual parts and distort the proportions.

Expand the chart’s data range

To include new rows in an existing chart in Excel for Microsoft 365 on Windows:

Select the pie chart so the chart tabs appear.
Choose Chart Design > Select Data.
In the Select Data Source dialog, inspect the Chart Data Range and the listed series.
Extend the range to include the new category label and its value, then select OK.

For example, if the current source covers the header and three categories in A1:B4, and you added a fourth category in row 5, the source needs to include A1:B5. If the existing range includes only values or only part of the labels, adjust it so the labels and numeric values line up row by row. In the dialog, you can also select the series and choose Edit to check its values, or adjust the category labels if the slice names are wrong.

Another option is to select the chart and look for the colored outlines around its source cells on the worksheet. Drag the lower-right corner of the outlined range down to include the new row. This can be convenient for a small chart, but Select Data gives you a clearer view of which labels and values Excel is using. Excel for Mac has similar chart data controls, though the ribbon layout and dialog wording can vary slightly by release. If the controls are unavailable in Excel for the web, open the workbook in the desktop app for the full set of chart-editing options.

Use an Excel Table to include future rows

If the source list will keep growing, an Excel Table is usually more convenient than repeatedly editing a fixed range. Select a cell in the source data, then choose Insert > Table, confirm the range, and indicate whether the first row contains headers. Create the chart from the table’s category and value columns, or change an existing chart to use those table columns.

When you enter or paste a new record directly below a table, Excel normally expands the table to include it, and a chart based on the table normally includes the added row as well. Check that expansion happened: the new row should have the table’s formatting and filtering controls. If it did not, add the row from the table’s last row or use Table Design > Resize Table to extend the table. A row separated from the table by a blank row, or placed elsewhere on the sheet, may remain outside its data.

Tables are useful when records are appended regularly, but they do not repair every chart automatically. A chart might still point to an old cell range if it was created before the table or built from a separate selection. After converting the data, inspect Chart Design > Select Data and confirm the chart includes the table’s columns. Also keep a single header row and avoid blank rows within the records; consistent structure makes both the table and chart easier to maintain.

Check formulas and workbook calculation

If the new row is included but the slice size or value label is stale, check the cells feeding the chart. A chart reflects the values available in its source cells; it does not independently update a formula that has not recalculated. Look at the formula bar and confirm the source cell actually displays the expected result. If the cell depends on another worksheet, a lookup, or an imported value, follow that dependency as well.

Excel can be set to manual calculation, in which case formula results may remain unchanged until recalculation. In Windows Excel, choose Formulas > Calculation Options > Automatic. You can also press F9 to recalculate open workbooks. If formulas update but the pie chart does not, return to Select Data and verify that the chart points to those formula cells rather than to a neighboring or older range. On Mac, use the Calculation settings in Excel’s preferences or settings; available labels depend on the version, and keyboard recalculation keys can differ by keyboard configuration.

Check for formulas that return an empty string, errors, or zero when you expect a positive number. A blank or zero value does not create a visible pie slice. A number stored as text may also fail to behave like a numeric chart value. Convert the source entry to a real number, then confirm the cell’s displayed value and the chart. Do not change calculation mode without considering the workbook: manual calculation can affect other formula-driven results, not just the chart.

Refresh a PivotChart or external data

A PivotChart is connected to a PivotTable rather than directly to an ordinary cell range. If records have been added to the PivotTable’s source, refresh the PivotTable: select a cell in it and choose PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections too. Then check whether the PivotTable source itself includes the new records. Refreshing cannot bring in rows that are outside a fixed source range.

For recurring records, a Table can help provide an expanding source for a PivotTable. After appending rows to that Table, refresh the PivotTable or use Data > Refresh All. If the chart is based on a workbook connection, database, or other external source, the latest data may depend on a successful connection refresh and the workbook’s connection settings. A chart can be correctly configured yet continue to show the last successfully loaded data.

To tell whether you have a PivotChart, select it and look for PivotChart Analyze or PivotTable-related controls. An ordinary chart instead offers its regular chart data controls. This distinction matters: editing the ordinary chart’s data range will not replace the PivotTable refresh step that a PivotChart requires.

Common data issues that hide or distort slices

Even when the source range is correct, the values may not produce the slices you expect. Review the labels and values from top to bottom, and check that each category has the intended numeric amount. Common causes include:

Blank or zero values: these have no visible positive slice, although a category may still exist in the source.
Negative amounts: a pie chart is intended to show positive parts of a whole; negative values cannot be represented as ordinary pie slices. Use a different chart type or reconsider what the data means.
Numbers stored as text: entries imported with apostrophes, spaces, or inconsistent decimal separators may not be interpreted as numbers.
Duplicate or missing categories: repeated labels can make it difficult to distinguish slices, while blank labels can leave unclear legend entries.
A total included as a category: adding the total alongside its component amounts double-counts the whole and changes every slice’s proportion.

Pie charts also become hard to read when there are many categories or several very small values. That is a presentation problem rather than an updating failure. Consider grouping minor categories only when that grouping is meaningful, or choose a bar chart so readers can compare the individual values more easily. A chart that updates correctly is not necessarily the clearest way to present the data.

A practical troubleshooting order

Use this sequence to avoid changing chart formatting when the underlying cause is a source or refresh issue:

Confirm the new row is on the worksheet and contains the intended label and numeric value.
Check whether the chart is ordinary or a PivotChart.
For an ordinary chart, use Chart Design > Select Data and include the new row; for a PivotChart, verify the source and refresh the PivotTable.
If the row should be included automatically, confirm it is inside the Excel Table and that the chart uses the table data.
If the value itself is stale, check formulas, calculation mode, and any external data connection.
Inspect the pie’s labels, zeros, negative values, and any accidentally included total.

This order separates three different things people often call “the chart not updating”: the chart does not include a new row, the source cell has not calculated or refreshed, or the chart is technically current but the data is unsuitable for a meaningful pie.

Frequently Asked Questions

Why does my Excel chart not include new rows?
The chart may use a fixed cell range that stops above the new rows. Extend it in Chart Design > Select Data, or base the chart on an Excel Table and add records within that table.

Will an Excel pie chart update automatically when I add data?
It generally updates when an added row is inside the chart’s source, such as a row added to a Table used by the chart. A row typed beneath a regular fixed range may not be included; check the source range rather than assuming Excel expanded it.

How do I refresh an Excel pie PivotChart?
Refresh its PivotTable by selecting a cell in the PivotTable and choosing PivotTable Analyze > Refresh, or use Data > Refresh All. Make sure the PivotTable’s source includes the new records before refreshing.

Why did my pie chart stop changing when a formula changed?
Check whether the formula cell recalculated and whether that cell is included in the chart source. In Windows Excel, set Formulas > Calculation Options to Automatic if appropriate, then recalculate and inspect the chart range.

Why is a new pie-chart category missing even though the range includes it?
Confirm its value is a positive number rather than text, zero, blank, or a negative amount, and make sure the category label aligns with the correct value. A category with no positive value may not produce a visible slice.

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.