Posts

Showing posts with the label scorecard

Google Sheets - Scorecard chart

Image
Scorecard is very useful when building a dashboard containing the key performance indicators (KPIs). In this tutorial we will build a scorecard chart like below: Suppose the total revenue is $1200, like below. 1. Do NOT select any data. Click an empty cell. Then on the menu, click Insert > Charts. A blank chart with "No data" is shown. 2. Change the chart type to scorecard. 3. Click the Key Value field 4. Select the value containing $1200.  5. Now you get a cool scorecard. However, when you show this scorecard to your audience, they may not know what this $1200 means. We need to add a title to the chart. 6. Right click the chart, under Chart & axis titles, click Chart title. 7. Enter "Total Revenue". 7. Now you get a pretty cool scoreboard chart!