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

Google Sheets tutorials›Charts›Create a scorecard chart

Google Sheets · Verified tutorial

Create a scorecard chart in Google Sheets

Create a scorecard chart from A1:B2 using Completed as the metric. Do not change any values.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create a scorecard chart from A1:B2 using Completed as the metric. Do not change any values.

Step-by-step

1

Select the targetCreate a scorecard chart from A1:B2.

2

Apply the changeCompleted as the metric.

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 scorecard chart uses the complete A1:B2 data range.

Common mistake

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

Troubleshooting

Re-select A1:B2 and repeat the final action. A scorecard chart uses the complete A1:B2 data range.

Example spreadsheet data

This is the clean fixture used for the verified run.

Metric	Value
Completed	72

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a scorecard chart from A1:B2.
Apply the change. Completed as the metric.
A scorecard chart uses the complete A1:B2 data range.