Write = and give reference to achievement. Click text box, go to the formula bar and click on. This needle looks too thin, make 2%.Īdd a text box or shape.

Now we need to do a little bit of formatting.

When you change the data in achieved the needle will move. We have our speedometer (gauge) chart ready.

Go to fill and, select no fill for each part of pie chart, except needle part.

Tick mark the checkbox of the secondary axis for the pointer, and change chart type of pointer as Pie chart from dropdown.

Right Click on the chart, and click on “Change Series Chart Type.

Now you have a chart that looks like this.

In the Series Value, give reference to the data we prepared. The End is a calculated value that is equal to (200% - (Achieved+width)).ĥ: Now right-click on the chart, and click select data.Ħ: In Legend Entries (Series): click on Add. It is for the thickness of the needle in the speedometer. The 50% is an achievement point that will be shown on the speedometer or gauge. Colour poor as red, average, as yellow, and good as green.Ĥ: Now we need the needle that will show how much target is achieved. If you want, change the color of the markers. (Optionally, reduce the doughnut hole size. You will see that the chart is already started to look like a speedometer.

Go to the series option, and make “angel of the first slice” 270 degrees.

30+40+30=100.Ģ: Now select the markers and go to Insert -> charts -> Donut and plot a donut chart.ģ: Right on the donut chart and click on the format data series.

The invisible part should be equal to some of the markers. The last tag is 100% and it will be invisible in the chart. The next marker is good that is for >70%. The next marker is for average that is from 31% to 70%. Next is for poor performance which is to 30%. The first marker is 0 for the starting point. Here, I have to show everyday target achieved in speedometer chart.ġ: Speedometer will have markers such as Poor, Average, and Good.

So, sit tight, and let’s get started.Īnd yes, you can download the file below. This article focuses on an easy explanation about creating a speedometer graph in excel. I read many articles about how to create the Speedometer graph in excel, but none of them were explaining it easily. It visualizes achievement or growth rate creatively. Excel Speedometer or Gauge graph is one of the most popular chart types that attract managers. A beautiful, and easy to understand chart always make your excel dashboard stand out.

Making a mac pivot chart in excel