What is Gauge Chart in Excel?

Attributes of Gauge Chart in Excel (Speedometer Chart)

  • Maximum value: It shows the value of the maximum range of the gauge chart, e.g., the maximum value is 180 in a motorbike.Minimum Value: It shows the value of the minimum range of the gauge chart, e.g., the minimum value is 0 in a motorbike.Speed: We use the speedometer/Gauge chart to check the exact information to check the vehicle’s speed because it is not stable.A gauge chart is used in business to check how much revenue has been achieved versus the goal.We can also check the temperature of a person, as a thermometerThermometerExcel Thermometer Chart is the visualization effect used to show the “achieved percentage vs targeted percentage”. This chart can be used to show employee’s performance, quarterly revenue target vs actual percentage, etc.… Using this chart we can create a beautiful dashboard as well.read more

How to Create a Gauge Chart in Excel? (with Step by Step Examples) 

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

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:

  • Step 1: We must first select the data and select the excel doughnut chartExcel Doughnut ChartJoint and Several Liability refers to conditions in a contract that are legally enforceable under which two or more people are jointly and individually liable to make good to the other party the same thing as enforced in the contract between them. Contracts entered between parties predetermine their liability towards each other in different situations.read more, 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 on “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. Here is a chart.

Pros

  • It is easy to understand for everyone.It is easy to use in Excel.Anyone can read and understand what the Gauge chart depicts.A Gauge chart can be prepared from a single value or multiple values.

Cons

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

Things to Remember

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

This article is a guide to Gauge Chart in Excel. We discussed creating a speedometer chart in Excel using pie and doughnut, practical examples, and a downloadable Excel template. You may also learn more about Excel from the following articles: –

  • We must first choose the data with a single value, as shown below: Then, select the information data and incorporate the headers from the information. Tap on the “Inset” tab. Then, in the “Charts,” tap the insert “Pie” or “Doughnut” diagram, and select the chart which suits the information: Consequently, the chart may look like the one below. Right-click on the speedometer chart and select the “Format Data Series” option. Select a “Series Options” and set an “Angle of first slice” to “90 degrees” to make data in a semi-circular form. Then, the chart looks like this. Now, right-click on the bottom slice of the pie. Next, click on a “Format Data Point.” Select “No fill.” As a result, it will make the bottom slice invisible. 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.Note: Using the same method, we can make the Gauge chart using multiple values.

Then, the chart looks like this.

The right-hand side slice of grey color shows the profit we had selected while preparing the Gauge chart.Note: Using the same method, we can make the Gauge chart using multiple values.

  • Funnel Chart in ExcelChart Templates in ExcelChart Wizard in ExcelTypes of Charts in Excel