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.
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.
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
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!