In this gauge chart tutorial, you will get to know everything about the speedometers. And how will this go? The following will be an irregular Excel tutorial! We can even call it a summary. We will show you the creation of the gauge chart and all of the articles we have written about this subject in the past years. First of all, we’d like to give you a comprehensive picture of the speedometer kind of templates.
What is a Gauge Chart, and how to use it?
The gauge chart offers a spectacular visualization to present the sales performance of representatives. In Excel, there are more tricky ways to create the chart; we will show you the designs that are built on the pie chart and doughnut chart.
The created gauge could be a useful instrument for others (not only for marketing/sales) fields also for visualization between the goal and actual values. With a little modification, it is able to show not only the 0-100% range but to display other arbitrary values on the speedometer graph. In this detailed tutorial, we’ll show you how to create a gauge chart from scratch!
How to create a gauge chart using Excel?
To create a Gauge Chart, do the following steps:
1. Specify the value range and parts you want the speedometer chart shown! Select the range F6:G10 (Column F for Donut Chart – Zone Settings) and (Column G for Pie Chart – Ticker Settings). The Pie series has 3 data points, and the Donut chart series has 4 data points.
2. Go to the Insert Tab on the ribbon and in the Charts Group, click on to Create Custom Combo chart icon to create the default chart.
3. Choose Doughnut as the chart type. For the Pie series, choose Pie as the chart type. It’s very important to mark the checkbox to Plot the Pie series on the secondary axis.
4. Click on the OK button!
5. Clean up the combo chart: Remove the chart title and the legend.
6. Select the chart area and go to the Format tab on the ribbon. In the Current Selection group, select the Pie series using the drop-down list.
7. On the Format tab, in the Current Selection group, click Format Selection and type 240 degrees into Angle of first slice textbox.
8. Choose the Donut Chart Series and Repeat Step 7! If you want to change the Donut Chart Hole Size, change the default value to 70%
9. Select the Pie Chart series! Use the Ctrl and the left / right arrows to select a single data point. On the Format tab, in the Shape Styles group, change the Shape Fill of each point. Point 1 = No Fill, point 2 = black and point 3 = No Fill.
10. Select the Donut Chart series! Use the Ctrl and the left / right arrows to select the Shape Fill of each point. Point 1 = Red, point 2 = Yellow, point 3 = Green, point 4 = No fill.
Tips to create a gauge chart
Explanation for Pie Chart Series: How to change the actual value between 0 and 100? First, click on the cell G9 and check the formula. Use the Spin Button to change the value in cell G7. The formula in cell G9 ensures that the three slices sum up to 150 points.
The explanation for Donut Chart Series: You can change the Red, yellow and green zone values freely. Important rules: Red zone + Yellow Zone + Green Zone = 100!
Download the gauge chart template!
Excel Speedometers – Love it or hate it?
This question can be heard a lot of times. When we talked with Excel experts, even the opinions of the professionals are divided if it is lucky to use them for displaying key performance indicators.
When we are running in the wrong direction, there is no sense in increasing the speed. We completely agree with this remark, but sometimes it is worth spending much energy and time on development so we can create something totally new and unique.
This is our case, and we hope that the speedometer will be a very favored tool!
There are some gauge chart tutorials for them also. In this part, we’d like to introduce the use of a gauge chart for beginners. The following templates are all absolutely free. We’ll present them below and will say a few words about their usage.
We have also used some graphics in order for you to see the almost endless possibilities of the speedometer dashboard templates.
Build Dashboards using Gauge Chart Add-in
If the goal is to display only a few key performance indicators, then that take only a maximum of 5 minutes, but if you have to show all the indicators of a company with a use of 50-100 gauge chart widget, the work still won’t take more than 15-20 minutes.
Gauge chart add-in is a part of our data visualization add-in can dramatically enhance the functionality of Excel.
The Gauge Chart add-in works together with Excel simply and without any trouble. Instead of long hours before, now it is only a matter of minutes to create a business dashboard or report. The add-in that we have made is a special Excel add-in that elevates dashboard making to a new level, especially for top management and business analysts.
Awesome Excel Gauge chart Tool – 3 easy steps!
- Install the add-in
- Use Gauge charts to create awesome automated dashboards
- Enjoy your work!
Finally, just a few words about the Excel Add-in:
- Easy Gauge Manager
- Linked cell handling
- Easy Format changer
- Gauge Skin Changer
Why should we use Gauge Charts?
The gauge/speedometer chart can be applied in many-many fields. It is a serious task to properly determine the key performance indicators. KPI is a huge subject; soon, we’ll introduce an article about KPI Dashboards.
We don’t mind that this subject divides people’s assumptions! It makes this profession beautiful! What would happen if everyone would use the same tools? It would create templates that are spitting images of each other.
We recommend you the following steps. First, you should think through what would you like to use this tool for?
If you have the resources and the key performance indicators are all right, then you can take the last step to choose the appropriate kind of gauge. Do not forget the Excel infographics either; they can boost the overall picture. Like always, the decision is yours! Thank you for being with us today!
Pros and Cons
And finally, let’s see where a little summary that will help you chose the cases you should use this kind of chart and the cases when you should avoid it from afar!
Use gauge chart templates if:
- you like data-visualization and would like to create unique reports
- you don’t get scared of applying a few settings
- the goal is to use one or two key performance indicators
Not recommended to use gauge chart if:
- you have to display more than two values
- you wish for something simpler
- don’t even have enough time to read this article through
- not interested in the topic of KPIs
Thank you for being with us, and if you are interested in novelties, join our YouTube channel, where the novelties are shared primary on a weekly basis.
Free Gauge Chart Templates
We’ve divided this Gauge chart tutorial into some useful articles:
- Free Widgets – Circle, Quarter and semi-circle style gauges
- Product Metrics Dashboard using Gauge Chart