Google Sheets Chart Not Updating? 5 Fixes That Work

Nine times out of ten, a Google Sheets chart that ignores new data has one problem: the chart is pointing at a fixed range like A1:B7, and your new rows landed at row 8. The chart is doing exactly what you told it — you just told it to watch a box that your data grew out of. Fix the range once, properly, and you never think about it again. Here’s the fast fix, then the four other causes worth knowing.

The 30-second answer. Double-click the chart to open the Chart editor, go to the Setup tab, and look at the Data range field. If it reads Sheet1!A1:B7, delete the row numbers so it reads Sheet1!A1:B. That tells the chart to watch the entire columns, so every new row is included automatically. Done.

Fix 1: Use an unbounded range (the real fix)

This is the one that actually ends the problem, so do it first. A range like A1:B7 is frozen — it captures rows 1 through 7 and nothing else. The moment you add row 8, the chart can’t see it.

Open the Chart editor > Setup > Data range, and change the reference from Sheet1!A1:B7 to Sheet1!A1:B — remove the trailing row numbers. Now the chart reads all of columns A and B, however far down your data goes. Any row you add from here on appears in the chart the instant you type it, no re-editing required.

This is worth building in from the start on any sheet you expect to grow. If you’re new to charting in Sheets, How to Make a Line Graph in Google Sheets shows where these settings live.

Fix 2: Your numbers are stored as text

If new values appear in the sheet but the chart flatlines or skips them, check whether those cells are actually numbers. A tell-tale sign: text values sit left-aligned in the cell, real numbers sit right-aligned. Charts won’t plot text as a quantity.

This usually happens when data is pasted from another app, or imported, and Sheets keeps it as text. Select the column, then Format > Number > Number (or use the VALUE function on a helper column) to convert. Once the values are genuinely numeric, the chart picks them up.

Fix 3: Blank rows are breaking the series

A blank row in the middle of your data can interrupt the chart’s series, especially on line charts, so the line appears to stop or the new data below the gap gets ignored. Google Sheets treats a break in the data as the end of the run.

Keep your data as one clean, continuous block: one entry per row, one variable per column, no empty rows or columns wedged in the middle. If you need visual separation, put it in a separate tab rather than inside the charted range.

Fix 4: The chart is built on a formula that hasn’t recalculated

If your chart’s source cells contain formulas — a QUERY, an IMPORTRANGE, a lookup — the chart only updates when those formulas do. Most recalculate instantly, but imported and cross-sheet data can lag.

Force a refresh by making a trivial edit and undoing it (type into any cell, press Enter, then Ctrl+Z), or reload the browser tab. For data pulled in with IMPORTRANGE or IMPORTDATA, give it a few seconds after opening the sheet — these functions show “Loading…” while they fetch, and a chart read during that window can briefly show empty. This lag is the usual reason a live-updating chart occasionally blanks out.

Fix 5: The chart points at the wrong or an outdated range

Sometimes the range simply drifted — you inserted a column, moved the data, or duplicated a tab, and the chart is still aimed at where the data used to be. Open Chart editor > Setup > Data range and confirm the reference matches where your data actually lives now. It’s the least glamorous fix and, once Fixes 1 through 4 are ruled out, often the culprit.

Bonus: filtered rows and add-on charts

Two edge cases catch people out often enough to be worth naming.

If you’ve got a filter applied to your data, the chart plots only the visible rows — so “missing” data points may just be filtered out of view rather than out of the chart. Clear the filter and check whether the points reappear before you go hunting for a range problem.

And if your chart came from a third-party charting add-on rather than Google’s built-in Insert > Chart, it may not refresh on data change the way native charts do. Add-on charts often need a manual refresh from the add-on’s own menu, or a scheduled trigger, because they don’t share the live link that native Sheets charts have. If a chart stubbornly ignores every fix above, check whether it’s actually a native chart at all.

The habit that prevents all of this

The durable fix isn’t any single setting — it’s a layout habit. Keep your raw data on one tab and your charts on a separate dashboard tab that references it, and always chart whole columns (A1:B, not A1:B7). Structured that way, data flows in from the bottom, charts read the full column, and nothing needs re-pointing when the sheet grows. Set it up once and “my chart won’t update” stops being a phrase you ever type into a search box again.

Grab the demo file

Download google-sheets-chart-refresh-demo.csv and import it to Drive as a new Google Sheet (File > Import > Upload). Chart columns A and B, then add a July row and watch nothing happen — that’s the fixed-range problem. Now switch the Data range to A1:B and add August: it appears immediately. Seeing both behaviours side by side makes the fix stick.

FAQ

Why is my Google Sheets chart not updating with new data? The chart’s data range is fixed (for example A1:B7) and doesn’t include your new rows. Change it to an unbounded range like A1:B in the Chart editor’s Setup tab.

How do I make a Google Sheets chart update automatically? Set the data range to whole columns (A1:B instead of A1:B7) so new rows are captured, and keep your data in one continuous block with no blank rows.

My data is there but the chart is blank — why? The values are probably stored as text, not numbers (text is left-aligned, numbers right-aligned). Convert the column via Format > Number > Number and the chart will plot them.

How do I force a Google Sheets chart to refresh? Make and undo a small edit, or reload the browser tab. For IMPORTRANGE or IMPORTDATA sources, wait a few seconds for the data to finish loading.

---

New to charts in Sheets? Start with How to Make a Line Graph in Google Sheets. Want ready-made charts to copy? See 15 Free Chart Templates for Google Sheets. And if you’d rather have AI build the chart for you, we put it to the test in Gemini in Google Sheets: AI Chart Generation Tested.