Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Create an Excel Gauge Chart the Easy Way? 

How to Create an Excel Gauge Chart the Easy Way? 

  • Facebook
  • Twitter
  • YouTube

(Note: This guide on how to create an Excel gauge chart is suitable for all Excel versions including Office 365)

Excel charts are a great way to depict data easily and effectively. There are a variety of charts available and depending on your preference you can choose the chart of your choice.

One among the variety of charts is the “gauge chart”. But what does it do and how can it help you?

In this article, you’ll learn how to create an Excel gauge chart to depict your data effectively.

You’ll Learn:

  • What is Excel Gauge Chart?
  • How to Create an Excel Gauge Chart?
    • Creating the First Doughnut Chart from the First Table 
    • Creating the Second Doughnut Chart from the Second Table
    • Creating the Pointer and Pie Chart from the Final Table
Download Sample Workbook for Excel Gauge Chart
Download Sample Workbook for Excel Gauge Chart

Watch this Video on How to Create an Excel Gauge Chart

Related Reads:

How to Create a Funnel Chart in Excel? 2 Useful Ways

How to Save Excel Chart as Image? 4 Simple Ways

How to Create a Step Chart in Excel?

What is Excel Gauge Chart?

Before we learn how to create an Excel gauge chart, let us see what a gauge chart is.

The Excel gauge chart also called the speedometer chart consists of a dial-like structure over which a needle-like pointer represents a specific point in the data. This type of chart helps depict the performance of the data. The Excel gauge chart is dynamic, meaning the chart changes when the data in the table changes.

This type of chart has a variety of applications from corporate presentations to show the performance of a project or to show the stage of a process to school presentations to show the performance to students. 

The gauge chart is created by a combination of a pie chart and a donut chart. It represents the start and end points on the scale and where the specific data lies in the scale. You can also add multiple ranges to the scale.

How to Create an Excel Gauge Chart?

Let us consider a basic example where we have to create an Excel gauge chart to represent the performance of a student in a school. 

The first step in creating an Excel gauge chart lies in creating the data points and the scale. We also need to create data points for the dial.  Aside from that, we need to create three tables to create the chart.

The first table denotes the category in the chart. The performance of a student can be plotted from initial to maximum and there can be any number of data intervals in between. Let us say, the initial value is 0 and the maximum value is 100. Create the data points in increment values, so that the intermediate data points add to the maximum value.

The second table denotes the labels in the chart. Let us name the labels in increments of 10 from the start to the end and also make a total of it.

The third table denotes the pointer and three values. In this table, you can specify the value you want to denote and the width of the pointer. The rest value denotes the total values of the first table minus the pointer value and the pointer width. 

The Tables
The Tables

The first and second tables are used to create the doughnut chart and the final table is used to create the pie chart.

Creating the First Doughnut Chart from the First Table 

Let us now create a chart for the data in the first table.

  • Navigate to Insert and then click on the dropdown from Insert Pie or Doughnut Chart. Select Doughnut Chart. This will populate an empty chart since we have not selected any data. 
Select the doughnut chart
Select the doughnut chart
  • To add the data to the chart, right-click on the empty space and select Select Data.
Click on Select Data
Click on Select Data
  • In the Select Data Source dialog box, click on Add. 
Add Data
Add Data
  • This in turn opens the Edit Series dialog box. In the Series name text box, enter any name for the data. In the Series values text box, click on the select data button and select the data under the Values section of the first table. 
Select the data and series
Select the data and series
  • Click OK.
  • This gives you the doughnut chart. You can see the orientation of the chart is a bit off.
  • To change the angle of the chart, right-click on the doughnut chart and select Format Data Series. 
  • In the Format Data Series, under the Series Options, change the Angle of the first slice to 270°.
  • If you want to change the size of the chart, change the Doughnut Hole Size.
Change the Angle of first slice
Change the Angle of first slice
  • Now, let us delete the bottom part of the doughnut chart. Select the part you want to delete, select the Fill&Line section and click on No Fill. 
  • If you want to change the colors of the other data points, click on the data points, navigate to the Line&Fill section and select the color from the dropdown.
Clear the bottom of the chart
Clear the bottom of the chart

Let us now select the data labels which will act as cues for the viewers.

  • In the customize shortcut buttons, click on Chart Elements and select Data Labels. This populates the numbers on the chart. 
  • Now, right-click on the numbers and select Format Data Labels.
Select Data Labels
Select Data Labels
  • In the Format Data Labels pane, select Values from Cells and select the headers corresponding to the values. Click OK.
  • Uncheck any other checkbox in the Data Labels option. 
Add Data Labels
Add Data Labels
  • Now, delete any unnecessary data labels and elements by clicking on them. 
The first scale of Excel gauge chart is ready
The first scale of Excel gauge chart is ready
  • Thus we have the doughnut chart which acts as the scale over which the pointer moves. 

Suggested Reads:

How to Make a Pie Chart in Excel? A Step by Step Guide

How to Create an Excel Map Chart from Pivot Table Data? 3 Simple Steps

How to Make a Box Plot Excel Chart? 2 Easy Ways

Creating the Second Doughnut Chart from the Second Table

Plotting the second chart by using the second table is an optional part of creating the Excel gauge chart. 

This part is mainly helpful to give in-depth cues and additional scaling to the existing chart.

  • First, right-click on the empty space in the table and click on Select Data.
  • In the Legend Entries(Series) click on Add. 
  • This opens the Edit Series dialog box.
  • In the Series name text box, give the chart any name. In the Series value, select the data from the Values in the second table.
  • Click OK. The selected data is added to the Data Series dialog box.
  • Again, click OK.  This populates the chart above the existing chart.
  • You can see that this new chart is already rotated to the previously specified degree. 
  • Now, right-click on the below half of the chart and select Format Data Series. In the Fill&Line section, click on No Fill.
  • Change the color coding as per your wish.
  • Now in the customize shortcut buttons, select the Data Labels. Right-click on the numbers and select Format Data Labels. 
  • In the Label Options, check the checkbox for Value from Cells and select the headers for the values in the table. And, make sure to uncheck any other checkbox.
  • Delete any element you deem unnecessary and move any data elements based on your choice.
The second scale of Excel gauge chart
The second scale of Excel gauge chart

Creating the Pointer and Pie Chart from the Final Table

This is the third, final, and most important step in creating the Excel gauge chart. 

  • To create the pointer, right-click on any empty space in the chart and select Select Data.
  • This opens the Select Data Source dialog box. In the Legend Entries(Series), click on Add.
  • This in turn opens the Edit Series dialog box. 
  • Enter the series name in the textbox given below. In the Series values text box, select the data in the values column from the third table.
  • Click OK.
Add the data for the pointer
Add the data for the pointer
  • Then, right-click on the doughnut chart and select Change Series Chart Type. 
Change the Chart Type
Change the Chart Type
  • In the Change Chart Type dialog box, select Combo and click on Custom Combination. In the Pointer data series, click on the dropdown and select Pie.
  • Click OK.
Change the pointer chart to Pie
Change the pointer chart to Pie
  • If the angle is not correct, right-click and select Format Data Series.  Under the Series Options, change the Angle of the first slice to 270°.

Now, let us just leave the pointer and hide the other parts of the chart.

  • Click on the data points in the pie chart. Navigate to the Fill&Line section in the Format Data Series and click on No Fill.
  • Delete any unwanted elements or move the chart elements to your preference. 

And, here it is. We have successfully created the Excel gauge chart or the speedometer chart to our liking.

The Final Excel Gauge Chart
The Final Excel Gauge Chart

When you change the Pointer value in the third table the pointer in the dial changes accordingly. 

Also Read:

How to Make an Excel Bullet Chart – 2 Easy Examples

How to Graph a Function in Excel? 2 Easy Ways

How to Make a Line Graph in Excel? 4 Best Line Graph Examples

Frequently Asked Questions

Can we create an Excel gauge chart with multiple scales?

Yes, we can create any number of scales or dials over which the pointer moves to depict the information. Once you create the first table and the doughnut chart, creating the rest of the dials is the same. 

Are the speedometer chart and gauge chart the same in Excel?

There is a lot of confusion regarding the term gauge charts and speedometer charts in Excel. Excel gauge chart signifies the charts which help show the performance of a particular data over a range of data. And, speedometer chart is also a part of the Excel gauge chart. 

What are the specifications to create the pointer table in the Excel gauge chart?

The pointer value to which the pointer should point. The thickness of the pointer. When the pointer value is 1, the pointer is thin and when it is 5, the pointer will be thick. The rest value is used to keep the pointer in balance. It is the result of the total of the first table minus the pointer value and its thickness.

Closing Thoughts

In this article, we saw how to create an Excel gauge chart easily. 

Creating an Excel gauge chart involves a couple of steps to arrive at the perfectly crafted chart. Initially, this may seem pretty confusing and elaborate at first. Once you understand how to create tables and how to curate the chart, it is a very easy and powerful tool to depict the performance of a variety of data.

Furthermore, you can use the existing chart, duplicate it and use it as a template to create several charts and depictions.

Want more high-quality guides for Excel? Check out our free Excel resources centre. 

Click here to access in-depth Excel training courses and master in-demand advanced Excel skills. 

Simon Sez IT has been teaching critical IT software for over ten years. For a low, monthly fee you can get access to 130+ IT training courses by seasoned professionals.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to do a Mail Merge in Microsoft Word 2013 – Part 1

Creating a New Calendar in Project 2010

How to Make a Histogram in Excel?—2 Best Methods

How to Create a Query in Microsoft Access 2013

Managing Catalogs in Photoshop Elements 11

How to Rip a CD in Windows 8

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)