New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Charts›Change chart range

Google Sheets · Verified tutorial

Change chart range in Google Sheets

Create a line chart using only A1:B5. Month must be the labels and Revenue the only series; do not include Forecast.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create a line chart using only A1:B5. Month must be the labels and Revenue the only series; do not include Forecast.

Step-by-step

1

Select the targetCreate a line chart.

2

Complete the next actiononly A1:B5.

3

Apply the changeMonth must be the labels and Revenue the only series;.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A line chart uses the corrected A1:B5 source range.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A1:B5 and repeat the final action. A line chart uses the corrected A1:B5 source range.

Example spreadsheet data

This is the clean fixture used for the verified run.

Month	Revenue	Forecast
January	120	140
February	180	190
March	240	230
April	210	220

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a line chart.
Complete the next action. only A1:B5.
Apply the change. Month must be the labels and Revenue the only series;.
A line chart uses the corrected A1:B5 source range.