C-19, Rajpur Khurd, Chattarpur, New Delhi – 110068 +91 99715 24677  ·  WhatsApp
RJ·COMPUTERS YOUR LOCAL TECH PARTNER Call us ↗
Home / Blog / Office help

Google Sheets chart misses new rows: extend the data range

Open the chart editor and inspect Setup > Data range. A chart using a fixed range will not include records added outside it.

By RJ Computers

Quick answer

Open the chart editor and inspect Setup > Data range. A chart using a fixed range will not include records added outside it.

Understand the problem before changing anything

Source range, series definitions and filters determine what is plotted. A record can be visible in the spreadsheet but absent from the chart. Check the selected sheet and columns before recreating the chart.

AI-created editorial photo illustrating Google Sheets chart misses new rows: extend the data range
AI-created editorial image illustrating this guide.

Step-by-step checks

  1. Identify a missing record

    Note its row, category and value. Confirm a numeric value is not stored as text.

  2. Open the chart editor

    Double-click the chart and inspect Setup, including Data range, headers, category axis and each series.

  3. Extend the intended range

    Include the new rows and correct columns. Keep header treatment consistent.

  4. Review filters and gaps

    Check filtered source data and blank categories that could explain missing or unexpected points.

  5. Update linked documents

    Once Sheets is correct, refresh linked charts in Docs or Slides if those copies are also being used.

What to avoid

Avoid expanding into unrelated totals or notes. Those rows may become extra data points and change the chart’s meaning.

How to verify the result

Locate the newest category and compare its value with the source cell. Recheck series names and axis labels after the change.

Follow the link between the source file and the displayed result

Confirm the Google account and exact source document before changing a shared object. A chart, table or imported value can depend on another spreadsheet, a selected range or a separate permission. The document where the problem is visible is not always where the underlying correction belongs.

Choose one known record or object and follow it through the workflow. Check the source values, range, headers and any filters before updating the destination. If the source already looks wrong, refreshing a linked document normally repeats that problem. If the source looks correct but the destination does not, inspect the link and its update state.

Review the result as a reader would see it. Check labels, totals, formatting and whether the displayed information is appropriate for the document’s audience. A person may see the rendered contents of a shared object without having access to its original source. After changing a shared file, inspect version history if you need to understand what changed, and refresh any separately exported PDF rather than expecting an older download to update itself.

Before you finish

  • Correct account and source file confirmed
  • Source range and filters inspected
  • Linked object and ordinary image distinguished
  • Shared view and exported copy reviewed

Common question

Will updating the chart in Docs extend the source?

No. Fix the data range in Sheets first, then refresh the linked object in the document.

LOCAL SUPPORT / SOUTH DELHI

Need help with the next step?

Tell RJ Computers the device model, exact symptom, checks already tried and whether important files are backed up. Confirm availability, assessment charges and the scope of work before arranging a visit.

Reference and version notes

Check the official instructions for your exact product version; menu names and available features can differ.

Official product documentation