A Chart for KPI Metrics
Progress Circle Chart is beautiful visual to display a KPI metric performance like Service level.
To create the above given chart below given steps to be followed:
- Insert a blank Doughnut chart from Insert>>Charts>>Doughnut Chart
- Right click on the chart and click on Select Data…
- Click on Add button to add a new series.
- Keep Series Name blank.
- In Series Values box put 20 times 1 like – {1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1}
- Once Doughnut Chart is ready, remove the chart elements like Chart Title and Legend.
- Click on doughnut and go to Format Tab>>Shape Fill>fill blue color
- Put the formula on Range H1 “=100%-G1” (Note : Service Level value is on Range G1)
- Right click on doughnut and click on Select Data…
- Click on Add button to add a new series.
- Select range F1 in Series Name box.
- Select range G1:H1 in Series Values option.
- Outside of first doughnut one more doughnut will be created.
- Right click on outside doughnut and click on Change Series Chart Type…
- Check the Secondary Axis option for Service Level Series.
- Now Service Level Doughnut will be above of first doughnut.
- Select blue slice by double clicking on it
- Go to Format Tab>>Shape Fill>>Fill as No fill
- Double click on orange slice
- Format Data Series window will be opened
- Click on Fill and Line option
- Select the Solid fill.
- Fill the White Color
- Change the Transparency 10%
- Go to Insert Tab and insert a text box over the Chart
- Connect the Text box with Service level value
- Select Text Box and go to formula bar and press “=”
- Click on Range G1
Once Text Box is connected with service level value, format the text box
- Select the text box and go to Home Tab
- Take the vertical alignment middle
- Take the horizontal alignment center
- Take font name “Impact“
- Take font size 30
- Take font color blue (Same color which take for first doughnut color)
Our Progress Circle Chart is ready. Please download the excel file for practice.
