KPIs mit Übersichtsdiagrammen anzeigen


               

Möchten Sie erweiterte Google Workspace-Funktionen für Ihr Unternehmen nutzen?

Testen Sie Google Workspace.

 

 

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.

       
       A        B           C
1

Month

Units Sold

Total Revenue

2

January

5,000

$2,500.00

3

February

4,000

$2,000.00

4

March

4,400

$2,200.00

5

April

3,000

$1,500.00

6

May

4,500

$2,250.00

       

See an example that shows insights from many cells

The scorecard chart below shows the sum of the range C2:C4

  
       A        B           C
1

Month

Units Sold

Total Revenue

2

January

5,000

$2,500.00

3

February

4,000

$2,000.00

4

March

4,400

$2,200.00

5

April

3,000

$1,500.00

6

May

4,500

$2,250.00

  

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.

       A        B           C
1

Month

Units Sold

Total Revenue

2

January

5,000

$2,500.00

3

February

4,000

$2,000.00

4

March

4,400

$2,200.00

5

April

3,000

$1,500.00

6

May

4,500

$2,250.00

7 June 3,500 $1,750.00

Add a scorecard chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. At the top, click Insert und dann Chart.
  3. At the right, under “Chart type,” click the Down arrow Abwärtspfeil.

    • Tip: Point your mouse over an example image to see the chart type.
  4. Under “Other,” choose Scorecard chart.

Show data from one cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click on your scorecard chart und dann More Mehr und dann Edit chart.
  3. At the right on the Setup tab, under “Key value” click More Mehr und dann Edit.
  4. Click a cell.

Show insights from multiple cells

You can display information about a group of cells, like sum or average.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click on your scorecard chart und dann More Mehr und dann Edit chart.
  3. At the right on the Setup tab, under “Key value” click More Mehr und dann Edit.
  4. Select a group of cells.
  5. Click OK.
  6. At the right, on the bottom of the Setup tab, click Aggregate.
  7. Next to “Aggregate,” choose an option.

See comparisons

You can compare two ranges of data to show differences, like changes over time.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. On your scorecard chart, click More Mehr und dann Edit chart.
  3. At the right on the Setup tab, under “Baseline value,” click More Mehr und dann Edit.
  4. Select a cell or range of cells you want to compare your key value to.
  5. Click OK.

Tip: To show your comparison as a percentage, at the right click Customize und dann Baseline value. Under “Show comparison to key value as,” click the Dropdown arrowAbwärtspfeil.

Benötigen Sie weitere Hilfe?

Mögliche weitere Schritte:

true
Schulungscenter besuchen

Sie nutzen Google-Produkte wie Google Docs bei der Arbeit oder in einer Bildungseinrichtung? Wir helfen Ihnen mit praktischen Tipps, Lernprogrammen und Vorlagen. Sie werden erfahren, wie Sie auch ohne Office mit Office-Dateien arbeiten, dynamische Projektpläne und Teamkalender erstellen, Ihren Posteingang automatisch organisieren und vieles mehr.

Suche
Suche löschen
Suche schließen
Google-Apps
Hauptmenü
11176381790144394623