Progress Circle Chart

A Chart for KPI Metrics

Progress Circle Chart is beautiful visual to display a KPI metric performance like Service level.

Progress Circle Chart
Progress Circle Chart

To create the above given chart below given steps to be followed:

  • Insert a blank Doughnut chart from Insert>>Charts>>Doughnut Chart
Insert a blank Doughnut Chart
Insert a blank Doughnut Chart
  • Right click on the chart and click on Select Data…
Select Data option
Select Data option
  • Click on Add button to add a new series.
Add New Series
Add 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}
Edit Series window
Edit Series window
  • Once Doughnut Chart is ready, remove the chart elements like Chart Title and Legend.
Remove Chart Elements
Remove Chart Elements
  • Click on doughnut and go to Format Tab>>Shape Fill>fill blue color
Fill Color in doughnut
Fill Color in doughnut
  • Put the formula on Range H1 “=100%-G1” (Note : Service Level value is on Range G1)
Put formula
Put formula
  • Right click on doughnut and click on Select Data…
Select Data Option
Select Data Option
  • Click on Add button to add a new series.
Add New Series
Add New Series
  • Select range F1 in Series Name box.
  • Select range G1:H1 in Series Values option.
Edit Series window
Edit Series window
  • Outside of first doughnut one more doughnut will be created.
  • Right click on outside doughnut and click on Change Series Chart Type…
Change Series Chart Type
Change Series Chart Type
  • Check the Secondary Axis option for Service Level Series.
Secondary Axis
Secondary Axis
  • 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
No fill the first slice
No fill the first slice
  • Double click on orange slice
  • Format Data Series window will be opened
  • Click on Fill and Line option
Fill and Line Option
Fill and Line Option
  • Select the Solid fill.
  • Fill the White Color
  • Change the Transparency 10%
Select Slice Setting
Second Slice Setting
  • Go to Insert Tab and insert a text box over the Chart
Insert a Text Box
Insert a Text Box
  • Connect the Text box with Service level value
  • Select Text Box and go to formula bar and press “=”
  • Click on Range G1
Connect Text box with Service Level value
Connect Text box with Service Level value

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)
Text box formatting
Text box formatting

Our Progress Circle Chart is ready. Please download the excel file for practice.

Progress Circle Chart
Click on the chart to download the excel file

Video Tutorial for Progress Circle Chart: