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

Google Sheets tutorials›Charts›Add data labels to a chart

Google Sheets · Verified tutorial

Add data labels to a chart in Google Sheets

Create a column chart from A1:B5. In Customize > Series, turn on data labels for the Revenue series. Do not change any values.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create a column chart from A1:B5. In Customize > Series, turn on data labels for the Revenue series. Do not change any values.

Step-by-step

1

Select the targetCreate a column chart from A1:B5.

2

Apply the changeIn Customize > Series, turn on data labels for the Revenue series.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A column chart uses A1:B5 and displays data labels on its Revenue series.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A1:B5 and repeat the final action. A column chart uses A1:B5 and displays data labels on its Revenue series.

Example spreadsheet data

This is the clean fixture used for the verified run.

Month	Revenue
Jan	120
Feb	180
Mar	150
Apr	220

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a column chart from A1:B5.
Apply the change. In Customize > Series, turn on data labels for the Revenue series.
A column chart uses A1:B5 and displays data labels on its Revenue series.