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.
