How to Create Gauge Chart in Google Sheets

The Gauge charts are another reason to love Google Sheets. This tutorial can help you to understand what is a Gauge chart and how to create a Gauge Chart in Google Sheets. The Gauge chart looks like a Speedometer so it’s also called a Speedometer chart.

The Purpose of the Gauge Chart is to compare or assessing the performance of single or multiple values. It’s commonly be used in executive dashboard reports to assess performance.

The Gauge chart above shows the percentage of marks scored by a student in two different years.

Gauge charts are visually appealing and easy to read. You can create Gauge charts in Google Sheets with few clicks.

How to Create Gauge Chart in Google Sheets

Formatting of data is important in creating any chart in Google Sheets. To create a Gauge chart in Google Sheets, follow the below formatting.

The gauge chart data should contain in two columns. The first column should be a string and that is the Gauge label.

The second column should be a number and that’s the gauge value.

Steps to Create a Beautiful Gauge Chart in Google Sheets

If you want to just assess the performance of a value and there is no scope of any comparison, then you can set it with one single label and value.

In my example, I am comparing two values. So I’ve two labels and two values.

First of all, enter the labels and the values in two columns. Select it and then go to the Insert menu Chart and select Gauge chart.

data format for google sheets Gauge chart

See here I am using the percentage values and as a reason, the minimum and max values in the gauge axis are not correct.

Instead of 0% to 100%, it shows 0% to 10000%. The color ranges are also ‘missing’.

In the above chart, if you are using numbers instead of the percentage value, the Gauge axis values will be correct.

In the following steps, you can learn how to get color coding and correct the axis values.

How to Get Color Coding in Gauge Chart in Google Sheets and Also the Proper Axis Values

This is an important step. Go to the Chart editor Customize tab. Set the gauge range from 0 to 1. I mean the Min value is zero and the Max value is one. This will correct the gauge chart axis value error due to the percentage value used.

gauge chart color coding in Google Sheets

See my color coding setting. I’ve set the color dark red up to 50% of value, 50% to 80% to orange color, and the balance set as green color.

With this color coding, I can easily visualize the percentage of marks scored by the student. I mean whether it’s falling in danger (red) or safe zone (other two colors).

When you change the values, the position of the needles gets adjusted.

This way you can create a Gauge Chart in Google Sheets for different performance assessments and comparisons.

More Charts:

1. How to and Example to Annotated Timeline Chart in Google Sheets

2. How to Create a TreeMap Chart in Google Sheets

3. Create Gantt Chart Using Wrike Online Project Management Software

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Finding Most Frequent Text in Excel with Dynamic Array Formulas

Looking to identify the most frequently occurring text in Excel? You can do this...

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

1 COMMENT

  1. Thank you for explaining the 10000% thing. I had my mins and maxes set to 0-100 and my needles weren’t budging. Once I switched to 0-1 and the gradations in between, it works like a charm!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.