How to Create a Gauge Chart in Google Sheets

A gauge chart is one of the quickest ways to see if you’re hitting a target. Just like the speedometer in a car, it gives you an instant reading on a single, important metric. This article will show you exactly how to create and customize a gauge chart in Google Sheets to track your own key performance indicators (KPIs).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Gauge Chart?

A gauge chart, also known as a speedometer or dial chart, is a data visualization tool that displays a single value within a given range. It immediately communicates progress toward a goal or the status of a specific metric. Think of it as a cross between a pie chart and a progress bar, shaped like a semicircle dial.

It typically has three main components:

• A scale or range: This includes a minimum and maximum value that defines the boundaries of your metric (e.g., 0% to 100%).
• A pointer or needle: This indicates the current value on the scale.
• Color-coded zones: These are custom ranges on the dial used to signify performance levels, like "poor," "average," and "good," often represented by red, yellow, and green.

When to Use a Gauge Chart

Gauge charts excel at simplifying information. Because they focus on a single value, they are perfect for dashboards and reports where you need a high-level overview. They aren't meant for complex data analysis or comparing multiple metrics - bar charts or line charts are better for that.

Use a gauge chart when you want to:

• Track progress toward a target: Measure daily sales against a monthly goal, tickets closed against a weekly target, or campaign spend against a set budget.
• Monitor performance at a glance: Quickly check a server's uptime percentage, a customer satisfaction score (CSAT), or inventory levels.
• Provide a quick status indicator: Show if a metric is in a "good," "warning," or "critical" state.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step: How to Create a Gauge Chart in Google Sheets

Creating a basic gauge chart is surprisingly straightforward. Let's walk through the process using a common example: tracking quarterly sales revenue against a goal of $100,000.

Step 1: Set Up Your Data

The data preparation for a gauge chart couldn't be simpler. All you need is a label and a value. Google Sheets will use the label as the title above the chart, and the value will determine where the needle points.

In your spreadsheet, set up two cells like this:

• In cell A1, type your label: Quarterly Sales
• In cell B1, type the current value you're tracking. Let's say it's 78,000.

Your sheet should look like this:

Step 2: Insert the Chart

With your two cells prepared, you can now insert the chart.

1. Highlight the cells containing your data (A1 and B1).
2. Go to the menu and click Insert > Chart.

Google Sheets will automatically insert a chart for you. In most cases, it will default to a Pie Chart, which is not what we want. Don’t worry, we’ll fix that in the next step.

Step 3: Select the Gauge Chart Type

With the chart selected, the Chart editor pane will appear on the right side of your screen. This is where you control everything about your chart's appearance and data.

1. In the Chart editor, click on the Setup tab if it's not already selected.
2. Click the dropdown menu under Chart type.
3. Scroll down to the section labeled "Other."
4. Select Gauge chart.

Your chart will immediately transform into a basic gauge chart. It's functional, but without any context, it’s not very useful. The default range is 0 to an arbitrary number above your value, with no meaningful color coding.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Your Gauge Chart for Clarity

Now comes the important part: customizing the chart to tell a clear story. We’ll set a clear goal, add performance ranges, and adjust the styling to make it professional.

In the Chart editor, click the Customize tab. This is where we’ll make all our adjustments.

Step 4: Set the Min and Max Values

A gauge chart needs a clear finish line. For our example, the sales goal is $100,000. That should be our maximum value.

1. In the Customize tab, click on the Gauge section.
2. Under the Gauge axis options, set your Min and Max values.
3. For our example, enter 0 for the Min value and 100000 for the Max value.

The dial will instantly adjust to reflect this new range, and the pointer will accurately show our progress of $78,000 toward the $100,000 goal.

Step 5: Add Color-Coded Performance Ranges

Colors are what make gauge charts so intuitive. A red section for poor performance, yellow for average, and green for excellent performance is a universally understood system.

Let's define our performance tiers:

• Poor (Red): $0 - $40,000
• Average (Yellow): $40,001 - $75,000
• Good (Green): $75,001 - $100,000

Here’s how to add these ranges in the Chart editor:

1. Still within Customize > Gauge, find the Range colors section.
2. For the Red Range:
3. For the Yellow Range: Click Add Range to create a new color section.
4. For the Green Range: Click Add Range again.

Now your gauge chart has vivid, meaningful color zones that instantly tell you if performance is on track.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 6: Refine the Chart Title and Style (Optional)

Finally, let's clean up the text and styling for a professional look.

1. Go to the Chart & axis titles section in the Customize tab.
2. For the Title text, you can change it to something more descriptive like "Progress to $100k Quarterly Goal." You can also adjust the font, size, and color here.
3. Next, go to the Chart style section. Here, you can change the background color of the chart or add a border to make it pop.

And that’s it! You now have a complete, customized, and easy-to-read gauge chart that gives a clear, instantaneous view of your performance.

Best Practices for Effective Gauge Charts

While making one is easy, making an effective one requires a bit of thought. Here are a few tips to keep in mind.

• One Chart, One Metric: The strength of a gauge chart is its simplicity. Resist the temptation to try and show multiple data points. A gauge chart should always answer just one question (e.g., "How close are we to our goal?").
• Use Intuitive Colors: Stick with a standard "traffic light" color scheme (red-yellow-green). It's universally understood and requires no explanation.
• Set Meaningful Ranges: The min and max values must be logical. If you're tracking a customer satisfaction score from 1-5, don't set your gauge from 0 to 100. The context provided by the range is everything.
• Label Clearly: Make sure the chart's title explains exactly what the gauge is measuring. Someone should be able to understand it in seconds without asking for clarification.
• Know Its Limitations: Remember, a gauge chart can't show trends over time, compare values between categories, or provide deep analytical detail. For those tasks, pick a better tool for the job, like a line chart or a bar chart.

Final Thoughts

A gauge chart is an excellent tool in Google Sheets for transforming a single, critical number into an insightful, at-a-glance visual. By setting clear ranges and using intuitive colors, you can build powerful dashboard components that communicate progress and performance without any complexity.

Building these individual charts is helpful, but the real struggle for most teams is connecting all the data in the first place. You spend hours downloading CSVs from platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce just to get the numbers into a spreadsheet. With Graphed, we automate that entire process. We connect directly to your marketing and sales tools and use AI to build real-time, interactive dashboards - you just ask for what you want to see in plain English. No more pivot table headaches or manual data wrangling, just instant access to the insights you need.