Table of Contents
In this gauge chart tutorial, you will get to know everything about the speedometers. And how this will 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 about the speedometer kind of excel dashboard templates!
What is a Gauge Chart and how to use it?
The gauge chart offers a spectacular visualization to present 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 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 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 to 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 type 240 degrees into Angle of first slice textbox.
8. Choose the Donut Chart Series and Repeat the Step 7! If you want 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 / change 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 / change the Shape Fill of each point. Point 1 = Red, point 2 = Yellow, point 3 = Green, point 4 = No fill.
11. 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 3 slices sum up to 150 points.
Explanation for Donut Chart Series: You can change the Red, yellow and green zone values freely. Importan rules: Red zone + Yellow Zone + Green Zone = 100!
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 to spend much energy and time for 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 gauge chart for the beginners. The following dashboards 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.
Live Dashboards using speedometers
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 wouldn’t take more than 15-20 minutes.
Our professional 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 KPI dashboard making to a new level especially for top managements and business analysts.
Awesome Free Excel Gauge chart Tool – 3 easy steps!
• Install the add-in
• Use Gauge charts to create awesome automated dashboards
• Enjoy your work!
Finally, just few words about the free Excel Gauge Chart Add-in:
• Easy Gauge Manager
• Linked cell / formula 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 and the creation of the connecting KPI dashboard. KPI is a huge subject; soon we’ll introduce an article about it. To tell the truth this subject can be equally loved and hated.
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 it through what would You like to use this tool for? Carefully plan the dashboard! It is even worth to draw up a paper based sketch.
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 info graphics 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 here a little summery 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 dashboards.
• Don’t get scared of applying a few settings.
• The goal is to use one or two key performance indicator.
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.
The decision is of course Yours as always, we can only share you our experiences with you. Thank you for being with us and if you interested in novelties join our Excel Dashboard School group on Facebook 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 Dashboard Widgets – Circle, Quarter and semi circle style gauges
Product Metrics Dashboard using Gauge Chart