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

Google Sheets tutorials›Charts›Create an area chart

Google Sheets · Verified tutorial

Create an area chart in Google Sheets

Create an area chart from A1:B5 using Month as the labels and Revenue as the series.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create an area chart from A1:B5 using Month as the labels and Revenue as the series.

Step-by-step

1

Select the targetCreate an area chart from A1:B5.

2

Apply the changeMonth as the labels and Revenue as the 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

An area chart uses the complete A1:B5 data range.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:B5 and repeat the final action. An area chart uses the complete A1:B5 data range.

Example spreadsheet data

This is the clean fixture used for the verified run.

Month	Revenue	Orders
January	120	8
February	180	12
March	240	16
April	210	14

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create an area chart from A1:B5.
Apply the change. Month as the labels and Revenue as the series.
An area chart uses the complete A1:B5 data range.