How to Use Scorecard Chart in Google Sheets

Want to display a single, critical number in a big, bold way on your dashboard? The scorecard chart in Google Sheets is purpose-built for this exact job. It cuts through the visual noise of complex graphs to put your most important key performance indicator (KPI) front and center. This article breaks down what a scorecard chart is, how to set up your data for it, and the exact steps to create and customize one for your reports.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Is a Scorecard Chart?

A scorecard chart, sometimes called a KPI card or a number display, is a data visualization that shows a single, aggregated metric. Unlike bar charts that compare categories or line charts that show trends over time, a scorecard's only job is to highlight one summary figure. Its power lies in its simplicity.

Think of it as the headline number on a news report. It's the first thing you see and immediately tells you the most important piece of information. You'd use a scorecard chart to answer direct, singular questions like:

• What was our total revenue last month?
• How many new users did we sign up this week?
• What is our current customer conversion rate?
• How many support tickets are currently open?

By isolating a key metric - like "Total Sales" or "Website Sessions" - you give it the prominence it deserves. This is especially useful for high-level dashboards where stakeholders need a quick snapshot of business health without getting bogged down in the finer details.

Preparing Your Data for a Scorecard Chart

The beauty of the scorecard chart is its minimal data requirement. It only needs one value. However, the best practice is to set up your data in a way that makes the scorecard dynamic and easy to understand.

A scorecard chart sources its value from a single cell. Because of this, you typically want that cell to contain a summary formula, like SUM, AVERAGE, COUNT, or MAX. This way, if your raw data changes, the formula updates automatically, and your scorecard chart reflects the new total without any manual work.

Let's say you have a table tracking sales from different channels for the quarter:

Here's a sample dataset in Google Sheets:

You wouldn't want to create a scorecard for "Organic Social" ($18,500) if your goal is to show the total sales. Instead, you need a summary cell.

Simply add a "Total" row and use a SUM formula to get the grand total. In our example table where the channel sales are in cells B2 through B5, you would use this formula in cell B6:

=SUM(B2:B5)

Now, cell B6 contains the single, aggregated value we need: $89,800. This is the perfect data point for our scorecard chart. Our data is prepared and ready.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Make a Scorecard Chart in Google Sheets (Step-by-Step)

With your key metric calculated in a single cell, creating the scorecard chart takes less than a minute. Following our example above, let's turn that total sales number into a scorecard.

Step 1: Select Your Data

Start by clicking on the cell that contains the value you want to display. In our case, that’s cell B6 ($89,800). To automatically create a title for your chart, you can select the label cell and the data cell together. Hold the Ctrl (or Cmd on Mac) key and click both cell A6 ("Total") and cell B6 ($89,800).

Step 2: Insert the Chart

With your cell(s) selected, navigate to the main menu and click Insert > Chart. Google Sheets will insert a default chart type based on its best guess, it often defaults to a pie chart or bar chart, which is not what we want. Don't worry, this is normal.

Step 3: Choose the Scorecard Chart Type

The Chart editor pane will appear on the right side of your screen. In the first dropdown under the Setup tab, you'll see "Chart type." Click it.

Scroll down past the common charts like "Line" and "Bar." Towards the bottom, under the "Other" category, you'll find the Scorecard chart. Click it.

Voila! Your default pie chart has now transformed into a clean scorecard showing your total sales.

Customizing Your Scorecard Chart for Impact

A basic scorecard gets the job done, but with a few simple tweaks, you can make it clearer, more visually appealing, and more contextually rich. The customization options are found in the Customize tab of the Chart editor.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Key Value Customizations

The primary number is the star of the show. You want it to be prominent. Under Customize > Key value, you can:

• Change the Font size to make the number larger and more eye-catching. A size of 36 or 48 often works well.
• Make the text Bold for extra emphasis.
• Adjust the Text color to match your brand or dashboard theme. Dark grey or black is usually best for readability.

Chart Title and Subtitle

A clear title is essential. Under Customize > Chart & axis titles, you can change the text, font, size, and color of your title. If you didn't select a label cell earlier, your chart may have no title, so you can add one here. For instance, changing the title from "Total" to "Total Sales Q3" gives much-needed context.

Chart Style

For better integration into a dashboard, you may want to change the visual styling of the chart box itself. Go to Customize > Chart style. Here you can set a Background color and a Chart border color. Setting the background color to a subtle grey or removing the border completely can help it blend better with other dashboard elements.

Adding Context with a Comparison Value

This is where scorecard charts go from good to great. A number like $89,800 is useful, but it's even more powerful when compared to something else, like the previous quarter's sales or a sales target. The scorecard chart has a built-in feature for this under the Setup tab.

Let's update our dataset to include last quarter's sales total of $75,000.

Now, follow these steps:

1. Double-click your scorecard chart to re-open the Chart editor.
2. Under the Setup tab, below the "Key value" section, you’ll find a field for "Baseline value".
3. Click into the text box and then select the cell containing your comparison value (in this case, cell B7 with $75,000).

Instantly, your scorecard chart updates to show the comparison. It will display the main value, $89,800, and underneath it, the percent change from the baseline value. In this case, it would show a green "▲19.7%" to indicate a positive increase.

You can customize how this baseline value appears by going to the Customize > Baseline section. Here you can choose to show the change as an absolute value instead of a percentage, and you can change the colors for positive and negative changes.

Bringing It All Together: Pro Tips for Using Scorecard Charts

Now that you know how to build and customize them, here are a few tips for using scorecard charts effectively.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Create a KPI Dashboard Header

Use a row of 3-5 scorecard charts at the very top of your dashboard. This creates a powerful, high-level summary that lets anyone get the health of the business or project in seconds. You might show Total Revenue, New Customers, Average Order Value, and Conversion Rate all side-by-side.

Use Them for Project Tracking

Scorecards are not just for financial data. You can use them to track progress against a goal. For example, show "Tasks Completed" with a baseline value of "Total Tasks" to instantly see how far along your team is.

Keep It Simple

The power of a scorecard is its singular focus. Resist the temptation to make it overly complex. Its job is to communicate one metric brilliantly. If you need to show trends, comparisons across many categories, or relationships between variables, use a different type of chart, like a line graph or bar chart.

Final Thoughts

The scorecard chart in Google Sheets is a simple but incredibly potent tool for highlighting your most important performance metrics. By isolating a single number and giving it visual emphasis, you can create reports and dashboards that communicate key results clearly and immediately. Whether you're tracking sales figures, website traffic, or project milestones, scorecards help put the most vital information front and center.

Of course, the hardest part of creating insightful charts isn't building the visualization - it's getting all your data clean, organized, and in one place to begin with. Many teams spend hours each week downloading CSVs from platforms like Google Analytics, Shopify, Salesforce, and Facebook Ads, then manually wrangling that data in spreadsheets just to produce a few numbers. With Graphed target="_blank" rel="noopener"), we connect directly to all your data sources and allow you to build real-time, shareable dashboards instantly using natural language. That way, your key metrics are always up to date, and you can spend your time acting on insights, not just pulling them.