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.
