A Chart for KPI Metrics
Speedometer Chart is very useful Visual to display KPI metrics. We can showcase metric like Service Level.
![Speedometer Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart.gif)
To create above given Speedometer chart in MS Excel below steps to be followed-
- On Range “A1:A10” put 10%
- On Range “A11” put 100%
- On Range “D1” put your metric name (like- Service Level)
- On Range “E1” put metric performance number (like – 85%)
- On Range “D2” put Needle Width
- On Range “E2” put 1%
- On Range “D3” put Blank Area
- on Range E3 put formula “=200%-SUM(E1:E2)“
![Create data for Speedometer Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-1.jpg)
- Select Range “A1:A11” and go to Insert>>Chart>>Insert Doughnut Chart
![Insert Doughnut Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-2.jpg)
- Remove all the chart elements like Chart Title and Legend.
![Remove Chart Element](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-3-678x304.jpg)
- Right Click on Doughnut and go to Format Data Series…
![Format Data Series](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-4.jpg)
- In Format Data Series change the Angle of first slice from 0° to 270°
![Angle of first slice](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-5.jpg)
- Double click on half circle (available in below side).
- Format Data Point window will be opened.
- Click on Fill and line option.
![Fill and Line option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-6.jpg)
- Fill as No fill in half circle.
![Fill as No Fill](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-7.jpg)
- In the other slices fill the Red to Green color as given in below image.
![Fill color in Slices](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-8.jpg)
Right Click on Doughnut and click on Select Data …
![Select Data](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-9.jpg)
- Click on Add (available under Legend Entries (Series)) to add new series.
![Add New Series](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-10.jpg)
- Select Range “D1” (Service Level) in Series Name box
- Select Range “E1:E3” in Series Values box
![Edit Series window](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-11.jpg)
- A new doughnut will be created in outside of old doughnut
- Right click on outside doughnut and click on Chang Series Chart Type.
![Change Series Chart Type](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-12.jpg)
- In Change Chart Type window Change Chart type as Pie for the Service Level Series or Series 2.
- Also check the Secondary Axis option.
![Change Chart Type Window (Excel 2013)](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-13.jpg)
- Right click on Pie and click on Format Data Series.
![Format Data Series of Pie Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-14.jpg)
- Change the Angle of first Slice in format Data Series window.
![Angle of first Slice](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-15.jpg)
- Click on the Pie and go to Format Tab>>Shape Outline>>Select No Outline
![Remove Outline from Pie chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-16.jpg)
- Double click on blue slice of Pie and fill as No Fill.
![No fill in Blue Area](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-17.jpg)
- Double click on Gray slice of Pie and fill as No Fill.
![No fill in Gray Slice](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-18.jpg)
- Double click on Needle and fill as black color.
![Black Color in Needle](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-19.jpg)
- Go to Insert Tab>>Shapes>> Select Oval under Basic shapes
- Drag the a small oval on center of needle.
![Insert a Oval](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-20.jpg)
- Select the oval and go to Format Tab>>Shape Fill>>Fill black color in the Oval
![Fill Black Color in Oval](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-21.jpg)
Select the Oval and go to Format Tab >>Shape Effects>>Preset>>Select Preset 2
![Change Oval's Preset](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-22.jpg)
- Double click on needle speedometer, needle will be selected
- Right click on needle and click on Add Data Label.
![Add Data Labels](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-23.jpg)
- 1% will be available as data label, click on 1%
- Go to formula bar and press “=” and click on range “E1”
- Data label will be connected with cell “E1” which is metric performance.
![Change the Data Label](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-24.jpg)
Our Speedometer Chart is ready. Please download the excel file for practice.
![Speedometer Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/SpeedometerChart/Speedometer-Chart-25.jpg)