In this article, we will show how to create a progress doughnut chart in Excel. The Progress Doughnut Chart shows the percentage of progression of a task. It is a very useful tool for representing the progress of a task. You can easily make this chart in Excel. So, without any delay, let’s start the discussion.
Download Practice Workbook
To practice by yourself, download the following workbook.
Step-by-Step Procedures to Create Progress Doughnut Chart in Excel
To demonstrate the method, we will use a simple dataset of a task. In the dataset, there will be information about what percentage of the task is completed. From this dataset, we will create a progress Doughnut Chart in Excel.
STEP 1: Make Dataset Ready
- We have taken the following dataset.
- Here, 80% of the task is completed.
- Now, we have to calculate what percentage of the task is remaining.
- To do so, write the following formula in the C6 cell:
=100%-C5
- After that, press OK to see the percentage of the remaining task.
Read More: How to Make Doughnut Chart with Total in Middle in Excel
STEP 2: Insert Chart
- In the following step, we will insert the doughnut chart.
- To do so, select the B5:C6 range.
- After selection, go to the Insert tab and click on the drop-down menu of the Insert Pie or Doughnut Chart.
- Instantly, a wizard will come out and select Doughnut from there.
- As a result, the doughnut chart has appeared before us.
- In the next step, we will modify the chart.
Read More: How to Insert Leader Lines into Doughnut Chart in Excel
STEP 3: Change Chart Title
- In this step, we will change the chart title.
- So, double-click on the Chart Title.
- Now, you can type the relevant title of the chart.
- Here, we have given the title Progress Doughnut Chart.
STEP 4: Format Color of Progress Doughnut Chart
- In this step, we will try to beautify the chart by changing its color and format.
- In Excel, there are many options available for color and format.
- Here, we will show you an example of how you can do modifications.
- So, click on the blue bar of the chart.
- Instantly, some icons will be floating beside the chart.
- Now, click on the following Chart Styles icon.
- Now, a wizard of Style and Color has appeared before us.
- In the Color tab, select the range of colors.
- Here, we have selected the following range of colors.
- As a result, the color of the doughnut chart has changed.
- After that, we want color difference between Complete and Remainder.
- That’s why, select the Remainder bar of the chart and go to the Format tab.
- In the Shapes Style group, click on the drop-down menu of the Shape Fill option.
- As a result, you can watch the color option.
- Therefore, select any relevant color.
- As a result, the color of the Remainder bar has changed to the Ash color.
Read More: How to Change Color Based on Value in Excel Doughnut Chart
STEP 5: Reform Legend of Chart
- Here, we do not need these types of legends.
- For this reason, click on the legends and press Delete on the keyboard.
- Instead of legends, we will use a textbox to show the percentage.
- To do so, select Insert >> Text Box to draw the textbox.
- Instantly, an icon can be seen.
- Here, you have to place the icon in a place where you want to draw your textbox.
- That’s why we have put our textbox in the middle of the chart.
- Now, you can modify the shape of the textbox by dragging the radio buttons of the textbox.
- After shaping the textbox, click on the textbox.
- So, it will open in the editing mode and write down the following formula in the formula bar:
=C5
- So, the textbox will show the value of the percentage of completed tasks from the C5 cell.
- Then, press Enter to show the result.
- In the following step, click on the text of the textbox.
- Then, change the color and size of the text.
- To change the color, go to the Home tab.
- After that, click on the drop-down menu of the Font Color from the Font group.
- Then, change the color of the text in such a way that the color matches the chart.
- For this reason, we have selected blue color.
- After that, we will increase the font size of the text.
- To do so, click on the Home tab.
- Then, type 37 in the Font Size option of the Font group.
STEP 6: Modify Edges
- In the following step, we will do some other modifications.
- To do so, click on the blue bar of the chart and double-click on the mouse.
- Instantly, the Format Data Series window will appear beside the Excel Sheet.
- Then, click on the Fill & Line panel.
- After that, select Solid Line in the Border field.
- And, make the Width 4 pt.
- Now, return to the sheet and our progress doughnut chart is almost ready.
STEP 7: Adjust Dataset for Conditional Formatting
This step is an optional procedure. You can follow the steps below to take your progress doughnut chart to another level.
- In the following step, we will show different colors in the chart according to level of task.
- If the task is under 50% completed, then it is at Beginner level.
- If the task is in the range of 50% to 75% completion, then it is at Mid-level.
- If the task is over 75% completed, then it is in Almost End level.
- In the Complete column, we will take the value from the C5 cell.
- But, if the level of the task is Beginner, then we will insert the value in the D9 cell.
- Therefore, write down the following formula in the D9 cell:
=IF(C$5<=C9,C$5," ")
- Then, press Enter.
- Then, type the formula in D10 cell:
=IF(AND(C5>C9,C5<=C10),C$5," ")
- Press Enter.
- After that, in the D11 cell, write down the following formula:
=IF(C$5>C10,C$5," ")
- Then, press Enter to proceed.
- Then, we will insert the calculated value of the C6 in the D12 cell by using the following formula:
=C6
- Now, hit Enter.
STEP 8: Apply Conditioning Formatting
- Now, click on the chart and right-click on the mouse.
- Instantly, a dialog will open up and click on the Select Data option
- Instantly, the Select Data Source window will open.
- Under the Legend Entries(Series) field, click on the Remove button.
- As a result, previous entries are deleted.
- In the following step, click on the Add button.
- In the Series name field, write “=’Doughnut Chart’!$B$5”.
- Here, we are referring to the B5 cell of the Doughnut Chart sheet.
- And here, we have given the name of our Excel Sheet as Doughnut Chart and B5 represents the header which is Complete.
- As our Excel Sheet name is Doughnut Chart, write “=’Doughnut Chart’!$D$9:$D$12” in the Series Values field.
- Then, press OK.
- After that, press on the following Chart Style icon.
- Here, you can change the color of the chart.
Final Output
- Finally, our Progress Doughnut Chart is completed.
- For checking purposes, change the completion of the task.
- Therefore, type 0.1 in the C5 cell.
- As a result, the completion is showing blue color and the remaining showing yellow color.
- After that, type 0.6 in the C5 cell.
- As a result, the completion is changed to orange color.
- For final checking, type 0.95 in the C5 cell.
- As a result, the completion is showing the ash color and the remaining is showing yellow color.
- So, depending on the progress level, the chart is showing different colors.
Conclusion
In this article, we have demonstrated step-by-step procedures for creating a progress doughnut chart in Excel. There is a practice workbook at the beginning of the article. Go ahead and give it a try. To read similar articles, check out the ExcelDemy website. Last but not least, please use the comment section below to post any questions or make any suggestions you might have.