How to Change Data Range in Google Sheets

Need to update a chart in Google Sheets because your data has grown or changed? It’s one of the most common tasks that can leave you clicking around, trying to figure out how to include that new data you just added. This guide will walk you through exactly how to change the data range for your charts and formulas, from the simple, direct method to more advanced techniques that will save you time every week.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Would You Need to Change a Data Range?

Before we get into the "how," let's quickly cover the "why." You’ll often find yourself needing to adjust a data range in Google Sheets for a few common reasons:

• You've added new data. This is the most frequent use case. You have a monthly sales report, and you’ve just added sales data from the new week. Your chart, however, is still stuck on last week’s data.
• You've removed irrelevant data. Sometimes you need to clean up your dataset, perhaps by removing outliers or data from a campaign that has ended. You'll need to update your charts and formulas to reflect this smaller dataset.
• You made a mistake in your initial selection. It happens to everyone. You accidentally missed a row or included an extra column when you first created your chart. Correcting the range is an easy fix.
• You are changing the focus of your analysis. The chart might currently show Q1 revenue, but now you need it to display Q2 data instead. Changing the data range is much faster than creating a whole new chart from scratch.

Whatever the reason, manually updating ranges can be tedious. Let’s look at the standard way to do it first, and then explore some smarter, more automated methods.

How to Change a Data Range for a Chart: The Direct Method

If you have an existing chart and just need to make a quick adjustment, the built-in Chart editor is the most straightforward tool for the job. It only takes a few clicks.

Let's use a simple example. Imagine you have a dataset tracking your website traffic by source for January and February. Your line chart only shows January, and you need to add February's data.

Here’s the step-by-step process:

1. Select Your Chart: Simply click on the chart you want to update. This will highlight it and bring up a three-dot menu icon in the top-right corner.
2. Open the Chart Editor: Click the three vertical dots (often called the "kebab menu") and select "Edit chart" from the dropdown menu. This will open the Chart editor pane on the right-hand side of your screen.
3. Locate the Data Range Field: Near the top of the "Setup" tab in the editor, you'll see a field labeled "Data range." It will show the current range your chart is using, something like 'Sheet1'!A1:B5.
4. Select a New Range: Click on the small grid icon next to the data range field. This will pop up a small dialog box prompting you to "Select a data range." Google Sheets will also highlight the current range on your spreadsheet.
5. Update the Range: You have two options here:
6. Confirm the Change: Once you've selected your new range, click the "OK" button in the dialog box.

That's it! Your chart will instantly refresh to display the updated data, now including both January and February.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

A Smarter Way: How to Create Dynamic Data Ranges

Manually editing the data range every time you add data works, but it's not efficient. If you’re updating a report every week or every day, this task quickly becomes a repetitive chore. A much better approach is to set up your ranges to be dynamic, so they automatically expand as you add new data. Here's a powerful trick for this: unbounded ranges.

Using Unbounded (or Open-Ended) Ranges for Charts

An unbounded range is a range that specifies a starting column but no ending row. Instead of writing A2:B50, you'd write A2:B. By leaving the row number off the end, you’re telling Google Sheets to include all data from cell B2 all the way down to the last row in column B.

When you add new data to row 51, 52, and beyond, your chart will automatically include it without any manual edits.

Here’s how to set this up for a chart:

1. Follow the steps above to open the Chart editor.
2. Go to the Data range field.
3. Instead of A1:B50, edit the range to A1:B.
4. Press Enter.

The Pros:

• It's Automatic: The biggest advantage. No more weekly edits. Just paste your new data and your chart updates instantly.
• It's simple: It is a very easy change to implement.

The Cons and How to Fix Them:

• Blank Rows Can Be a Problem: If you use an unbounded range like A1:B, any blank rows at the bottom of your sheet will also be included in the chart. For a line chart, this can cause a confusing line that drops to zero at the end.
• The Fix: The Google Sheets Chart editor has a simple solution. Under the "Setup" tab, scroll down and make sure the box for "Aggregate" is checked. Then, just below it, you can tell the chart what to use for the horizontal axis and the series. If you're building a time series chart, this setup usually handles blank rows gracefully. Another option is to add a filter within the editor itself to exclude rows where the value is null.

How to Change Data Ranges in Formulas

Your charts aren't the only elements that rely on data ranges. Common formulas like SUM, VLOOKUP, AVERAGE, IMPORTRANGE, and QUERY all depend on specified ranges. Updating them follows a similar logic.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Manually Editing Formula Ranges

The most straightforward method is to edit the formula directly.

1. Click on the cell containing the formula you want to change.
2. The formula will appear in the formula bar at the top of the worksheet (labeled fx).
3. Edit the cell references directly in the formula bar. For example, you might change:

=SUM(C2:C100)

to:

=SUM(C2:C150)

Just like with charts, you can also use unbounded ranges here to make formulas automatically update as new rows of data are added.

=AVERAGE(D2:D)

This formula will now average all numbers in column D from row 2 downwards, automatically including any new data you add.

The Best Practice: Using Named Ranges

Manually editing formulas across a large spreadsheet is slow and prone to error. You might forget to update one, throwing your entire summary off. This is where Named Ranges become your best friend.

A Named Range allows you to assign a simple, human-readable name (like Sales_Total or Traffic_Data) to a specific range of cells. Instead of writing a cryptic formula like =SUM('Q1 Data'!C2:C250), you can write =SUM(Sales_Total). It's cleaner, easier to understand, and much easier to update.

How to Create a Named Range:

1. Select the columns or cells you want to assign a name to. For example, highlight all of Column B with your monthly revenue.
2. Navigate to the top menu and click on Data > Named ranges.
3. A sidebar will open on the right. In the text box, give your range a meaningful name. Names cannot have spaces (use an underscore instead, like monthly_revenue).
4. Click "Done."

Now, you can use that name in any formula. For example:

=SUM(monthly_revenue)

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Update a Named Range:

Here’s the powerful part. When you need to update the data range, you don't edit every single formula. You just edit the Named Range once, and every formula that uses it will update automatically.

1. Go to Data > Named ranges.
2. A list of all your named ranges will appear in the sidebar.
3. Hover over the named range you want to change and click the pencil (edit) icon.
4. In the dialog that appears, simply update the range of cells and click "Done."

Every chart and formula using monthly_revenue will now point to this new range. It's a huge time-saver and the industry-standard way to manage ranges in complex spreadsheets.

Final Thoughts

Mastering how to change data ranges transforms Google Sheets from a static tool into a dynamic reporting dashboard. By moving beyond manual edits and embracing reusable methods like unbounded ranges and Named Ranges, you automate your reports and greatly reduce the opportunity for errors. Your dashboards and summaries become living documents that adapt as your data grows.

While these techniques make spreadsheet management easier, the core hassle of manually pulling data from different sources into Google Sheets remains. We built Graphed to solve exactly this problem. We let you connect marketing and sales tools like Google Analytics, Shopify, and HubSpot directly, so your dashboards have live data without any exporting, copying, or pasting. You can build a dashboard simply by describing what you want to see - like “show me my Shopify sales by traffic source from Google Analytics” - and Graphed creates interactive, auto-updating reports for you, so you can spend less time updating ranges and more time acting on insights.