Gauge Chart In Excel (Speedometer)

A Gauge Chart in Excel helps users measure the dataset values and to show the comparison between them. It is also known as a Speedometer Chart because it resembles a speedometer, which uses dials to visualize the information on the data.

We can create an Excel Gauge Chart using the combo chart option in Excel, mostly two different types of charts: a doughnut and pie charts.

For example, we can find the scores of an entire classroom using their exam results. When we use the Guage chart to measure their performance and place them in the “Poor Average, Good, and Excellent” categories, we get the following chart.

The output is shown above, which indicates 20% of the students fall under the “Excellent” score category, the next 20% in the “Good” category, and 10% of them in the “Poor Average” category..

1. Maximum value: It shows the value of the maximum range of the gauge chart, e.g., the maximum value is 180 in a motorbike.
2. Minimum Value: It shows the value of the minimum range of the gauge chart, e.g., the minimum value is 0 in a motorbike.
3. Speed: We use the speedometer/Gauge chart to check the exact information to check the vehicle’s speed because it is not stable.
4. A gauge chart is used in business to check how much revenue has been achieved versus the goal.

Excel does not provide an inbuilt Gauge Chart or a Speedometer Chart. However, we can create the chart using the Combo Chart Option in Excel, or a Doughnut Chart.

We will consider some examples to create Gauge Chart in Excel.

Example #1 – Create a Gauge Chart in Excel with Single Value

The steps to create a Guage Chart are as follows:

1. We must first choose the data with a single value, as shown below:

   
   

2. Then, select the information data, and incorporate the headers from the information.

   
   

3. Tap on the “Insert” tab. Then, in the “Charts,” tap the insert “Pie” or “Doughnut” diagram, and select the chart which suits the information:

   
   

4. Consequently, the chart may look like the one below.

   
   

5. Right-click on the speedometer chart and select the “Format Data Series” option.

   
   

6. Select “Series Options” and set the “Angle of first slice” to “90 degrees” to make data in a semi-circular form.

   
   
   
   Then, the chart looks like this.
   
   

7. Now, right-click on the bottom slice of the pie. Next, click on “Format Data Point.”

   
   

8. Select “No fill.” As a result, it will make the bottom slice invisible.

   
   

9. Here is a Gauge chart, which looks like a speedometer in Excel. Add a chart title to it.

   
   
   
   The right-hand side slice of grey color shows the profit we had selected while preparing the Gauge chart.

Example #2 – Create a Gauge Chart in Excel with Multiple Values

• We are taking the data on the quality of the product like “Average,” “Good,” “Excellent,” etc. Below is the information:

The steps to create a Guage Chart are as follows:

• Step 1: We must first select the data and select the excel doughnut chart, as shown above, while creating the Gauge chart with a single value. Once it is completed, we will get the Gauge chart (speedometer).

• Step 2: Select a "Format Data Series" option.

• Step 3: Set an “Angle of first slice” (which one is large) to 90 degrees.

• Step 4: It rotates the chart on the right side.

• Step 5: Right-click on a large slice of pie. Click on “Format Data Point."

• Step 6: Click “Fill” and select “No fill.” As a result, it will make the slice invisible.

• Step 7: Finally, we have prepared the Gauge chart quality-wise, as shown below.

Pros

1. It is easy to use and understand for everyone.
2. A Gauge chart can be prepared from a single value or multiple values.

Cons

1. It is not the best method to present a single measure.
2. The Gauge chart cannot portray the context of the sample.
3. People who are color blind would not be able to get the information through a Gauge chart.
4. It requires a lot of space to display different information on a single chart.

1. We must always take the values which have no dimensions.
2. If we want to communicate the data through a Gauge, it is mandatory to understand the audition and whether they know the data.
3. We must always make the chart more attractive to show clear information using different colors.
4. We must always select the appropriate data to get the chart in a better way.
5. Remember to make the slice of pie, which is larger, invisible.
6. If the data is small, we can better understand the data and make a better Gauge chart.