Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

Create a Gauge Chart in Excel Part 1

We welcome back guest blogger Nick Williams. Nick is an Access tutor based in the UK.

In this article, you will learn how to create a gauge chart in Excel.

Let’s assume we would like to represent % value in a gauge chart. I’ve embedded the Excel workbook used for this article. Feel free to refer to it as you read through the article.

Let’s begin by creating a suitable data to plot the chart.

  1. I’m selecting 80% as the percentage to represent (I’m plugging that into cell B2), the same can be changed to any desired value or even a formula can be used to determine the value
  2. Then subtract the value (in this case 80%) from 1 or 100%, use relevant formula to do this in Cell B3
  3. Add 100% in the cell B4. Later you’ll understand why this is necessary

  4. Now Select the range A1:B4 and Inset a Pie chart by navigating to the Charts section of the Insert Ribbon
  5. Select the option for a Doughnut chart, you’ll get chart similar to the one shown below

  6. Remove the legend and the title or modify the title as per your requirement
  7. Right click on the chart area and select Format Data Series

  8. This will open a section to Format the Data series on the right
  9. Make the angle of the first slice as 270° and set the Doughnut hole size to 60

  10. Now click on the bottom half of the Doughnut chart to modify the format of only that slice (You might have to click twice if the slice isn’t selected). Click on the paint bucket icon available on the right. In the Fill section select no fill
  11. You can select No border in the border section, remove the border from all the other slices
  12. Fill the smaller slice with a lighter color to denote the remaining value to achieve 100%
  13. Now the chart should look something like the following:

  14. Now, Select the entire chart area and in the fill, select no fill and No line in the border section
  15. Position the graph in so that a cell aligns to the center space and reference that cell to the actual percentage we have plotted (here 80%)
  16. Remove Gridlines by unchecking Gridlines from the Show section of View ribbon

  1. Now we have a gauge chart created:

In Part II, we will discuss making a more advanced version of gauge charts.

 

Comments are closed.