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.
Table of Contents
hide
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.
Here, if the completion of the task is 50% or below 50%, then we will insert the completion of the task. Else, we will insert nothing.
- Then, type the formula in D10 cell:
=IF(AND(C5>C9,C5<=C10),C$5," ")- Press Enter.
Here, if the completion of the task is between 50% to 75%, then we will insert the completion of the task. Else, we will insert nothing.
- After that, in the D11 cell, write down the following formula:
=IF(C$5>C10,C$5," ")- Then, press Enter to proceed.
Here, if the completion of the task is over 75%, then we will insert the completion of the task.
- 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.
