Möchten Sie erweiterte Google Workspace-Funktionen für Ihr Unternehmen nutzen?
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
The scorecard chart below shows the data in cell C2.
|
See an example that shows insights from many cells
The scorecard chart below shows the sum of the range C2:C4
|
See an example that shows a comparison
The scorecard chart below shows the sum of the range C5:C7 with a comparison to range C2:C4.
|
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 More Edit chart.
- At the right on the Setup tab, under “Key value” click More Edit.
- 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 More Edit chart.
- At the right on the Setup tab, under “Key value” click More Edit.
- 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 Edit chart.
- At the right on the Setup tab, under “Baseline value,” click More Edit.
- 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 Baseline value. Under “Show comparison to key value as,” click the Dropdown arrow.