Skip to main content

Create progress circle chart in Excel

Author: Xiaoyang Last Modified: 2021-02-22

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

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:

Note: If the completed percentage is greater than 100%, please apply this formula: =MAX(1,B1)-B1.

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:


Add conditional formatting to the progress circle chart

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:

B5: =IF(B1>=80%,B1," ")
B6: =IF(AND(B1>50%,B1<80%),B1,"")
B7: =IF(B1<=50%,B1,"")
B8: =MAX(1,B1)-B1
Note: Here, use the IF formula to display the progress value for its corresponding level. If the actual value is in the level, then a number will be displayed, if not, a blank is displayed.

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:


Create a simple progress circle chart in Excel with an amazing feature

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!

doc kte progress circle chart 1


Download Progress Circle Chart sample file


Video: Create progress circle chart in Excel


The Best Office Productivity Tools

Kutools for Excel - Helps You To Stand Out From Crowd

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ...
Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup...
Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List...
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

Description


Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations