WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Gauge Chart in Excel (Speedometer)

Gauge Chart in Excel (Speedometer)

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

By Madhuri Thakur

What is Gauge Chart in Excel?

Gauge chart in excel is also known as speedometer chart because of its resemblance to a speedometer, because it resembles a speedometer it uses dials to visualize the information on the data, it is basically a combination of two different types of charts which are doughnut chart and pie chart, it can be used by creating a combo chart option in excel.

Attributes of Gauge Chart in Excel (Speedometer Chart)

  1. Maximum value: It shows the value of the maximum range of gauge chart, e.g., the maximum value is 180 in a motorbike.
  2. Minimum Value: It shows the value of the minimum range of gauge chart, e.g., the minimum value is 0 in a motorbike.
  3. Speed: To check the speed of the vehicle, we are using the speedometer/gauge chart to check the exact information because it is not stable.
  4. A gauge chart is used in business to check how much revenue has been achieved versus the goal.
  5. We can also check the temperature of a person, as a thermometer

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

You can download this Gauge Chart Excel Template here – Gauge Chart Excel Template

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

  • Step 1: Choose the data with a single value, as shown below:

Gauge Chart Example 1

  • Step 2: Select the data in your information and additionally incorporate the headers from your information.

Gauge Chart Example 1-1

  • Step 3: Tap on the Inset tab, in the Charts, tap the insert pie or doughnut diagram or, and select the chart which suits your information:

Gauge Chart Example 1-2

  • Step 4: Your Chart looks like as given below:

Gauge Chart Example 1-3

  • Step 5: Right-click on the speedometer chart, select the format data series option.

Gauge Chart Example 1-4

  • Step 6: Select a series option and set an angle of the first pie to 90 degrees to make data in a semi-circular form.

Format data Series

  • Then the chart looks like this.

Speedometer Chart in Excel

  • Step 7: Right, click on the bottom slice of pie. Click on a format data point.

Click on a format data point

  • Step 8: Select no fill; it will make the bottom slice invisible.

Format Data Point

  • Step 9: Now, here is a Gauge Chart, which looks like a speedometer in excel. Add a Chart Title to it.

Speedometer Chart in Excel

In this chart, the right-hand side slice of grey color shows the profit which shows in our which we have selected while preparing the gauge chart.

Note: By the same method, we can make the gauge chart by using the multiple values.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

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. Mention below is the data:

Gauge Chart Example 2

  • Step 1: Select the data and select the excel doughnut chart, as shown above, while creating the gauge chart with a single value. Once it is done, you will get the gauge chart (speedometer).

Gauge Chart Example 2-1

  • Step 2: Select a Format Data series option and

Select a Format Data series option

  • Step 3: Set an angle of the first pie (which one is large) to 90 degrees.

FOrmat data series

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

Gauge Chart Example 2-4

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

Click on format data point

  • Step 6: Click on Fill and select no fill; it will make the slice invisible.

Format data points

  • Step 7: Finally, we have prepared the gauge charge quality-wise. Here is a chart.

Speedometer Chart in Excel

Pros

  1. It is easy to understand for everyone.
  2. It is easy to use in excel.
  3. Anyone can read and understand what the gauge chart depicts.
  4. 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. Gauge Chart is not able to portray the context of the sample.
  3. People who are color blindly, they won’t be able to get the information through a gauge chart.
  4. It requires a lot of space when you want to display different information on a single chart.

Things to Remember

  1. Always take the values which have no dimensions.
  2. If you want to communicate your data through a gauge, so it is mandatory to understand the audition, whether they understand the data or not.
  3. Always make your chart more attractive so that it shows clear information by using different colors.
  4. Always select the appropriate data to get the chart in a better way.
  5. Always remember to invisible that slice of pie, which is larger in size.
  6. If the data is small, the better you can understand the data and make a better gauge chart.

Recommended Articles

This has been a guide to Gauge Chart in Excel. Here we discuss how to Create a Speedometer Chart in Excel Using Pie and Doughnut along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Funnel Chart in Excel
  • Chart Templates in Excel
  • Chart Wizard in Excel
  • Types of Charts in Excel
7 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Category iconExcel Tutorials,  Excel, VBA & Power BI

Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Gauge Chart Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More