EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Charts Excel Gauge Chart
 

Excel Gauge Chart

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated June 12, 2023

Gauge Chart in Excel

 

 

Gauge Chart in Excel

A gauge chart in Excel is a meter type chart of a dial chart, which looks like a speedometer with the pointer toward the numbers mentioned on the arc. The gauge Chart measures and shows the numerical value from zero to its maximum limit. We can use the Gauge chart to show profit, loss, and completion status with percentages. To create a Gauge chart, the first 3 numbers in which some of those 2 numbers give the 3rd value. Then using these numbers, create a Pie Chart, which is there in the Insert menu tab’s Charts section. Once created, delete a portion that came out of the summation of the first 2 numbers. This is what our basic Gauge chart will look like. Now we can choose the data which we want to show on it.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Create a Gauge Chart in Excel?

Gauge Chart in Excel is very simple and easy to use. Let’s understand the creation of a Gauge Chart in Excel with some examples.

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

Example #1 – Create a Simple Gauge Chart in Excel

A pie chart can resemble a simple gauge chart in Excel. It does not involve any levels like the speedometer has Poor, Average, Good, or Excellent parameters. It shows only two items: the current achievement and what needs to be achieved.

For this example, I have set up data. This data includes the sale starting date and sale ending date.

Example 1

Using the NETWORKDAYS function, I have shown the total days available in the sales cycle. NETWORKDAYS excludes weekends and gives the number of days.

NETWORKDAYS function

In the next cell, I have entered the current date.

Current date

Again using the NETWORKDAYS, I have shown how many days are over from the sales start date.

Number of Days Over

And how many days are left in the sales cycle

Number of Days Left

Now we will create a simple gauge chart in Excel that shows the total number of days available, the total number of days over, and the total number of days remaining.

Step 1: Select B4, B6, and B7 cells by holding the Control key.

Gauge Chart Example 1-6

Step 2: Insert a Pie Chart for the selected cells.

Insert a Pie Chart

Step 3: Now, we have a chart that looks like this.

Gauge Chart Example 1-8

Step 4: Select the chart and press Ctrl + 1, the shortcut key for the format chart. On the right-hand side, you will get format options.

Make the Angle of the first slice 90 degrees.

Press Ctrl + 1

Step 5: Now select the blue colored area, i.e., the highest value, and make the fill as NO FILL.

NO FILL

Step 6: Now select the entire chart. Under Format, the tab makes the Shape Outline as No Outline.

No Outline

Step 7: Now select only the GREEN Colored part to make and the FILL as NO FILL, shape outline as BLACKLINE.

Gauge Chart Example 1-12

Step 8: Now select only the colored area and make the shape outline like a black line. Go to FILL > Pattern Fill > Select 90% pattern fill.

Gauge Chart Example 1-13

Step 9: Make the chart title No of Days Over.

Result of Example 1

Now we have set up a simple Gauge chart. But it does not have any kind of indicators such as Poor, Average, Good, and Excellent parameters; we will see this in the next example.

Example #2 – Create a Speedometer Chart with Indicators

For this example, I am taking sales individual employee’s performance in the last year. To judge them, I have created some slabs for their efficiency level.

Example 2

Conversely, I have individual sales employee’s performance for the entire year.

Gauge Chart Example 2-2

Now create one more data series, as shown in the below image.

Gauge Chart Example 2-3

Create a drop-down list of employee names.

Gauge Chart Example 2-4

Apply VLOOKUP to get the target, actual, and efficiency level based on the selection from the drop-down.

Gauge Chart Example 2-5

Now create one more table for the Speedometer needle.

Gauge Chart Example 2-6

For Efficiency Level, give a link to the VLOOKUP Efficiency cell, i.e., N2.

Gauge Chart Example 2-7

For Needle Size, mention 1%.

Gauge Chart Example 2-8

For the Remaining cell, mention the formula as =200%-I2-I3.

Gauge Chart Example 2-9

We have set up the data required to create a Gauge chart in Excel.

Gauge Chart Example 2-10

Step 1: Select the first table and insert the donut chart.

Gauge Chart Example 2-11

Step 2: Your chart should look like this now.

Gauge Chart Example 2-12

Step 3: Select the chart and make the Angle of the first slice 270 degrees.

Gauge Chart Example 2-13

Step 4: Now select the big portion of the donut chart and make the fill as NO FILL.

Gauge Chart Example 2-14

Step 5: For the remaining 5 parts, fill in different colors as shown in the below image.

Gauge Chart Example 2-15

Step 6: Right-click on the chart and click on Select Data.

Gauge Chart Example 2-16

Step 7: Here, select the second table we have created.

Gauge Chart Example 2-17

Step 8: Now, our chart looks like this.

Gauge Chart Example 2-18

Step 9: Again, select the big portion of the newly inserted chart and fill it in as NO FILL.

Gauge Chart Example 2-19

Step 10: Right-click on the chart and select Select Data. Here select the final table we have created.

Gauge Chart Example 2-20

Step 11: Our chart looks like this now.

Gauge Chart Example 2-21

Step 12: Select the newly inserted chart and click Change Series Chart Type.

Gauge Chart Example 2-22

Step 13: Select the PIE chart and then click on OK.

Gauge Chart Example 2-23

Step 14: Make the Angle 270 degrees.

Gauge Chart Example 2-24

Step 15: In the PIE chart, fill the two big portions as NO FILL and change the needle size to 5%.

Gauge Chart Example 2-25

Step 16: Right-click on the first donut chart and select format data labels that select only the category name.

Gauge Chart Example 2-26

Step 17: Select the second donut chart and add data labels, but this select Value.

Gauge Chart Example 2-27

Step 18: Make some color adjustments for data labels to look better.

Gauge Chart Example 2-28

So our Speedometer or gauge chart is ready to use.

As per the change of the employee name, you make it from the drop-down list, and your gauge chart will show the results.

Result of Example 2

Things to Remember About Gauge Charts in Excel

  • Create a drop-down list to make the chart dynamic.
  • Even though it looks like a great chart will take a tremendous amount of time to create.
  • It is often used in KPI presentations.
  • Try different colors to make the chart look great and appealing.

Recommended Articles

This has been a guide to Gauge Chart in Excel. Here we discuss how to create a Gauge Chart in Excel, along with Excel examples and a downloadable Excel template. You may also look at these useful charts in Excel –

 

  1. Excel Dynamic Chart
  2. Pie Chart in Excel
  3. Excel Bubble Chart
  4. Excel Clustered Bar Chart

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Gauge Chart Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Gauge Chart Excel Template

EDUCBA

डाउनलोड Gauge Chart Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW