Gauge chart

Gauge Chart in Excel :-

Gauge chart in Excel also known as Speedometer chart.

This chart is basically a combination of 2 charts, 1^st Doughnut chart & 2^nd Pie chart

First we will make Doughnut chart which is a base to place pie chart on it -

To make doughnut chart we requires some measures which will show the strength of area like RED area, Yellow area & the safest area which is green, we will use below mentioned table to make this chart

Performance	Measure	Color
Bad	40%	Red
Average	20%	Yellow
Good	40%	Green
Base	100%	White

We require half (100% out of 200%) of the chart to be hidden so will color this area white

To create Doughnut chart follow mentioned instructions –

·         Select Doughnut chart from Insert chart menu under other charts

·         Remove the legends & heading

·         Right click on any of the slice of the chart area and select Format Data series

·         Rotate chart by 270 degree under series options

·         Right click outside the circle and select No fill under Fill option

·         Also click on No line under border color

·         And change the slice color as per table mentioned above

Now we will make another part of Gauge chart which is Pie chart –

Pie chart will capture your actual performance %age, by changing this %age your chart will change automatically

Performance	Measure
Performance	50%

Here we are assuming 50% is your current performance which can be change manually as per the actual performance of the company

Now the below mentioned table will make Pie chart

	Data	Color
Performance - 1%	49%	White
1%  Gap to highlight	1%	Gray
	150%	White

In this table 1% is nothing but to show the line on the point of performance %age like below

To create this chart –

·         Select Pie chart from insert menu under charts

·         Remove the legends

·         Add Data Labels

·         Right Click on any slice of Pie chart and select format Data series

·         Rotate chart by 270 Degree under series options

·         Right click just outside the circle & select No Fill under Fill option

·         Also select No line under border color

·         Change the circle color as per Table mentioned

·         Remove data levels except 1%

·         Select 1%, Press equal to sign & click on performance value Cell (50%) to show performance %age

After doing this our chart will look like

Fit Pie chart over Doughnut chart & do formatting like below

·         Make a round circle to fit middle of the doughnut chart

 

·         Make a shield to protect your charts to avoid unnecessary clicks

Place circle & shield at appropriate place & your Gauge chart is ready

Please write your suggestions to make it better