(A Chart for KPI Metrics)
Battery chart is used to show the KPI metrics. For example if we have to create a chart for Process Service Level then we can use battery chart.
![Battery Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-gif.gif)
Below are the steps to create a battery chart in excel:
- Put your metrics (for example Service level) on range A1 and its value on range B1 (like 80%)
- On Range A2 Upper cap and on range B2 5% (Upper cap size of battery)
- On Range A3 Lower cap and on range B3 5% (Lower cap size of battery)
- On Range A4 Blank Area and on Range B4 put a formula “=100%-B1”
![Data for Battery Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-1.jpg)
- Select the range A1:B4 and go to Insert>>Charts>>Insert Column Chart>>3D Column>>3D Stacked column
![Insert 3D Stacked Column Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-2.jpg)
- Select the chart and go to Chart Toos>>Design Tab>>Click on Switch Row/Column
![Switch Row/Column](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-3.jpg)
- Click on the Chart Element button (Plus button of chart) and unchecked Axes, Chart Title and Gridlines.
![Chart Elements](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-4.jpg)
- Right click on 3D column and click on Format Data Series.
![Format Data Series](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-5.jpg)
- In Format Data Series option select Cylinder option which is available under Column Shape.
![Cylinder Option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-6.jpg)
- Right click on cylinder (in chart) and click on 3-D Rotation…
![3-D Rotation](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-7.jpg)
- In 3D Rotation option change the X Rotation 0º in place of 20º
- In 3D Rotation option change the Y Rotation 10º in place of 15º
![3-D Rotation option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-8.jpg)
- Right click on cylinder and click on Select Data…
![Select Data option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-9.jpg)
- In select data option use Move Down and Move Up option and arrange the series in below order-
- Upper Cap
- Service Level
- Blank Area
- Lower Cap
![Select Data Source](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-10.jpg)
- Right click on Upper Cap or Lower Cap Area and click on Format Data Points…
![Format Data Points](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-11.jpg)
- In Format Data Point click on Fill and Line Option.
![Fill and Line](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-12.jpg)
- In Fill option select the Solid fill and change the color as Gray.
- Similarly fill the color in other Lower Cap (Gray color), Service Level (Green Color) and Blank Area (Green Color).
![Color Fill option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-13.jpg)
- Select the Blank Area series and change the Transparency as 75%
![Transparency option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-14.jpg)
- Right click on Battery and click on Format Data Series…
![Format Data Series](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-15.jpg)
- In Format Data Series option go to Series Option and change Gap Width 300% from 150%.
![Gap Width option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-16.jpg)
- Select the chart and go to Insert>>Shapes>>Flowchart>>insert Flowchart: Magnetic Disk
![Insert Shape](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-17.jpg)
- Change the size of shape according to Batter size.
![Resize Shape](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-18.jpg)
- Select the shape and go to Format Tab>>Shape Fill >>Fill black color
![Shape fill option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-19.jpg)
- Select the shape and go to Format Tab>>Shape Outline>>Select No Outline
![Shape Outline](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-20.jpg)
- Right click on battery chart (in green area) and click on Add Data Labels.
![Add Data Labels](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-21.jpg)
- After adding the data label change the font color of data label as White.
- Change font size of data label as 11
Our battery chart is ready.
![Batter Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/BatteryChart/Battery-Chart-22.jpg)