How to Add a Range on Spreadsheets Charts

Your spreadsheet chart looked perfect - until new data came in. Whether you just added last month's sales figures or have a fresh set of metrics to compare, you now need to expand your chart's data source to include the new information. This article will show you exactly how to add a new data range to your charts in both Google Sheets and Microsoft Excel, so your visualizations are always up-to-date.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does Updating Your Chart's Data Range Matter?

Charts and dashboards are only useful if they reflect current reality. Manually updating the data range is a fundamental spreadsheet skill that comes into play in many common scenarios:

• Tracking Performance Over Time: You've added a new week, month, or quarter's worth of data to your sheet. You need to extend the chart's range to include this new period and see updated trends.
• Expanding a Comparison: You initially charted the performance of two products, but now you want to add a third for comparison. You'll need to adjust the range to include the new product's data column.
• Correcting an Initial Mistake: It’s easy to accidentally grab the wrong cells when first creating a chart. Knowing how to quickly edit the range saves you from having to delete the chart and start over.
• Refining Your Focus: Sometimes you need to do the opposite - shrink a data range to focus on a more specific period or subset of data. For example, you might want to change a yearly view into a quarterly one.

Keeping your chart data sources accurate ensures you're making decisions based on the complete picture, not just stale information.

How to Add a Data Range in Google Sheets

Google Sheets makes updating chart ranges very intuitive with its Chart editor. Here are a couple of ways to get it done.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Directly Editing the Data Range

This is the most common and straightforward method. If you've simply added more rows or columns right next to your original data, this will take just a few seconds.

Let's use an example. Imagine you have a chart showing monthly website traffic for Q1, and now you've added data for April.

Your data looks like this:

Month | Traffic Jan | 10,000 Feb | 12,500 Mar | 15,000 Apr | 14,000 &lt,-- New data to add

Here’s how to update your chart:

1. Select Your Chart: Simply click once on the chart you want to update.
2. Open the Chart Editor: You can either double-click the chart, or click the three vertical dots in the top-right corner of the chart and choose 'Edit chart'. The Chart editor sidebar will appear on the right side of your screen.
3. Locate the 'Data range' Field: Under the 'Setup' tab in the editor, the 'Data range' field will be right near the top. It will show the current range, for example, A1:B4.
4. Select the New Range: Click inside the 'Data range' field. You can manually type the new range (e.g., A1:B5). Alternatively, click the grid icon to the right of the field. This opens a 'Select a data range' dialog box.
5. Drag to Select New Data: Click and drag your cursor over the entire new data set on your sheet, including the new row for April. Google Sheets will highlight your selection.
6. Confirm Your Selection: Click 'OK'. The chart will instantly refresh to include the April data point.

Method 2: Amending Individual Series

Sometimes you don't need to change the entire scope of the chart, but just add a new metric to compare. For instance, imagine you have a bar chart showing 'Revenue' by product, and now you want to add a series for 'Profit'.

Your data might look like this:

Product | Revenue | Profit Product A | $5,000 | $2,000 Product B | $8,000 | $3,500 Product C | $6,500 | $2,500

Here's how to add just the 'Profit' data as a new series:

1. Open the Chart editor as described above.
2. In the 'Setup' tab, scroll down until you see the 'Series' section. You'll see your existing 'Revenue' series there.
3. Click on the '+ Add Series' button.
4. A menu will ask you to select the range for this new series. Click the grid icon and select the 'Profit' data (in this case, cells C2:C4).
5. Click 'OK'. Google Sheets will add a new set of bars (in a different color) to your chart representing profit for each product. Your chart is now a grouped bar chart, showing both revenue and profit side-by-side.

Pro Tip: Use Unbounded Ranges for Automatic Updates

If you know you'll be constantly adding new rows of data (like new monthly reports), you can save yourself future work by creating a dynamic chart using an "unbounded" or "open-ended" range.

Instead of defining your data range with a final row number (e.g., A1:B12 for a full year of data), you'll leave the row number off the second half of the range.

For example, if your data starts in column A and has values in column B, your range would be A1:B.

This tells Google Sheets to include all data from row 1 to the very last row in column B. When you add a new row of data for the next month, the chart will automatically update itself because the new row falls within the A1:B range. This is a massive time-saver for recurring reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Add a Data Range in Microsoft Excel

The process in Excel is very similar, though the menus and dialog boxes look a bit different.

Method 1: Using the 'Select Data' Source Menu

This is the standard and most reliable way to change a chart's data range in Excel.

Let's use the same example as before - adding April's traffic data to a Q1 report.

1. Select Your Chart: Click anywhere on the chart. When you do, new contextual tabs will appear in the top ribbon. Click on the 'Chart Design' tab.
2. Open the Data Selector: In the 'Data' group of the 'Chart Design' ribbon, click the 'Select Data' button.
3. Define the New Range: A 'Select Data Source' window will pop up. You'll see a field called 'Chart data range:'. This shows the current selection (likely something like =Sheet1!$A$1:$B$4).
4. Update the Range: You can either manually edit the formula in this box, or just click into the spreadsheet itself and re-select the entire data set, including the new April row. You'll see the marching ants border expand as you select.
5. Apply the Change: Once the 'Chart data range' field shows the correct new range (e.g., =Sheet1!$A$1:$B$5), click 'OK'. Your chart will update immediately.

Method 2: Adding a New Series Individually

Just like in Google Sheets, you can also add a completely new column of data to an existing Excel chart without changing the original series.

Using the Revenue and Profit example:

1. Open the 'Select Data Source' window (Chart Design > Select Data).
2. On the left side, under 'Legend Entries (Series)', you'll see your 'Revenue' series. Click the 'Add' button just above it.
3. An 'Edit Series' dialog box will appear.
4. Click 'OK' twice (once for the 'Edit Series' box and once for the 'Select Data Source' box). Your chart now contains the new profit data series.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Pro Tip: Format Your Data as an Excel Table

This is the best practice for creating dynamic charts in Excel. Before you even create the chart, convert your raw data into a formatted Excel Table.

1. Select your data range, including headers.
2. Go to the 'Insert' tab and click 'Table', or press the shortcut Ctrl + T.
3. Make sure the 'My table has headers' box is checked and click 'OK'. Your data will be beautifully formatted.
4. Now, create a chart based on this table.

Here’s the powerful part: anytime you type a new row of data directly below the last row of the table, the table automatically expands to include it. And because your chart is linked to the table (not a fixed cell range), the chart updates automatically as well! No further adjustments are needed.

Troubleshooting Common Issues

Sometimes things don't go perfectly. Here are some common issues and how to solve them:

• My Chart Looks Messy: If you've added many new data points, your chart might become cluttered. Consider switching to a line chart (better for many time-series points) or a pivot chart that allows for easier filtering.
• Labels Are Wrong or Missing: When you update a data range, make sure you've also correctly selected the range for your axis labels. In Excel's 'Select Data' menu, there's a separate box on the right for 'Horizontal (Category) Axis Labels' you may need to edit.
• I See Empty Space in My Chart: This often happens with the "pro tip" methods (unbounded ranges in Sheets or Tables in Excel) if you have blank rows in your table. To fix this, you can apply a filter to your data or chart to exclude blanks.

Final Thoughts

Keeping your charts in sync with your latest data is a vital part of effective reporting. Whether you use Google Sheets' Chart editor or Excel's Select Data feature, mastering the ability to adjust your data range gives you full control over your visualizations and ensures your analysis is always on point.

While mastering these small spreadsheet tasks is essential, we know that manually updating ranges across dozens of reports is exactly the kind of repetitive work that slows teams down. That's precisely why we built Graphed . We connect directly to your core data sources like Google Analytics, Shopify, and Salesforce, so your dashboards and charts are always live and update themselves automatically - no more adjusting ranges or downloading CSVs. All your data stays current, letting you focus on the insights, not the manual updates.