Create progress circle chart in Excel
A progress circle chart is a type of doughnut chart which is used to represent the percentage complete when you want to monitor progress towards a target in Excel. It is more interesting and compelling than the progress bar chart.It is used to show progress in the news, business reports and even in some software loading or refreshing commonly.
- Create a simple progress circle chart in Excel
- Add conditional formatting to the progress circle chart
- Create a simple progress circle chart in Excel with an amazing feature
- Download Progress Circle Chart sample file
- Video: Create progress circle chart in Excel
To create a simple progress circle chart, please do with the following steps:
1. Enter the percentage value into cell B1 which indicates the completed percentage, and then enter this formula =1-B1 into cell B2 to calculate the remaining percentage, see screenshot:
2. Then, select the two cells of the percentage values, click Insert > Insert Pie or Doughnut Chart > Doughnut, and then, a doughnut chart is inserted as below screenshots shown:
3. Then, click the doughnut to select it, and then right click, then choose Format Data Series from the context menu, see screenshot:
4. In the opened Format Data Series pane, under the Series Options tab, adjust the Doughnut Hole Size to 65% or other size you need, see screenshot:
5. Still on the Format Data Series pane, click Fill & Line tab, in the Fill section, choose Solid fill and then specify a color you need for the chart, then in the Border section, choose Solid line, and specify a darker color than the fill color. See screenshot:
6. After specifying the border color and fill color, now, double click to select the remaining data series, adjust the Transparency to 60% for the fill color, see screenshot:
7. At last, delete the unneeded elements, and edit the chart title to your need, see screenshot:
8. In this step, you should add text box in the center of the chart, after inserting the text box, click to select the outside border of it, in the formula bar, type the equal sign =, then select the completed percentage value cell B1, and press Enter key. This will link the textbox to cell B1, when the completed percentage changes, the chart will be updated automatically.
9. And then, select the text box, then do the following operations to format the textbox to your need:
- Increase the font size;
- Center the text within the textbox;
- Remove the textbox border.
10. Now, the progress circle chart has been created at once, see screenshot:
The above progress circle chart is only display one color for the completed percentage, sometimes, you may want to show different colors when the actual percentage value changes. For example, when the actual value is greater than or equal to 80%, the doughnut color is orange, when the actual value is between 50% and 80%, the doughnut color is green, and if the actual value is less than or equal to 50%, a blue doughnut is colored as below demo shown.
To create this type progress circle chart, please do the following step by step:
1. First, type a percentage value which belongs the level 1, such as 95%, then you should insert some formulas to get the data for creating the chart based on:
2. After inserting the formulas, and then, select cell B4 and B5, and then, click Insert > Insert Pie or Doughnut Chart > Doughnut, a doughnut chart is inserted as below screenshot shown:
3. Then, put the cursor at the right border of the cell B5, and it will become a double-headed arrow, then drag the cell to B8, and you will get a chart as below demo shown:
4. Then, double click to select the actual data series, and then click Format > Shape Fill, and specify an orange color for this level, see screenshot:
5. And then, enter a percentage value between 50% and 80% which belongs level 2, for example, type 73%, and then double click the actual data series, and then click Format > Shape Fill, and specify a green color for this level, see screenshot:
6. Now, go on typing a percentage value less or equal to 50% which belongs level 3, for example, type 35%, and then double click the actual data series, and then click Format > Shape Fill, and specify a blue color for this level, see screenshot:
7. After changing the colors for each actual value, now, please format a color for the remaining data series, double click to select the remaining data series, click Format > Shape Fill, and specify a light grey color for it, see screenshot:
8. At last, insert a textbox and link it to the actual percentage value, and format the textbox to your need, and now, a dynamic progress circle chart has been crested successfully, see below demo:
Kutools for Excel provides dozens of special types of charts that Excel does not have, such as Bullet Chart, Target and Actual Chart, Difference Arrow Chart and so on. With its handy tool- Progress Ring Chart, you can create a progess circle chart with ease in Excel workbook. Click to download Kutools for Excel for free trial!