Call attention to key performance indicators, known as KPIs, on your spreadsheet like total sales, average cost, or a top selling item.
Examples
See an example that shows data from one cell
See an example that shows insights from many cells
See an example that shows a comparison
Add a scorecard chart
- On your computer, open a spreadsheet in Google Sheets.
- At the top, click Insert
Chart.
-
At the right, under “Chart type,” click the Down arrow
.
- Tip: Point your mouse over an example image to see the chart type.
- Under “Other,” choose Scorecard chart.
Show data from one cell
- On your computer, open a spreadsheet in Google Sheets.
- Click on your scorecard chart
- At the right on the Setup tab, under “Key value” click More
- Click a cell.
Show insights from multiple cells
You can display information about a group of cells, like sum or average.
- On your computer, open a spreadsheet in Google Sheets.
- Click on your scorecard chart
- At the right on the Setup tab, under “Key value” click More
- Select a group of cells.
- Click OK.
- At the right, on the bottom of the Setup tab, click Aggregate.
- Next to “Aggregate,” choose an option.
See comparisons
You can compare two ranges of data to show differences, like changes over time.
- On your computer, open a spreadsheet in Google Sheets.
- On your scorecard chart, click More
- At the right on the Setup tab, under “Baseline value,” click More
- Select a cell or range of cells you want to compare your key value to.
- Click OK.
Tip: To show your comparison as a percentage, at the right click Customize 
