How to Make a Progress Pie Chart in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to show information in charts for our convenience. This not only helps understand a report better but also makes the report look exquisite. Pie charts are good options to represent data in graphical form. In this article, I will describe how to make a progress pie chart in Excel with some easy steps.


What Is Progress Chart?

The name “Progress Chart” itself implies that this will indicate the progress of any particular task. With a progress chart, one can understand what portion of a task is complete and what portion is in process. Knowing that one can plan for his or her further activities. A progress chart may take the form of a bar, a pie, or a doughnut.


How to Make a Progress Pie Chart in Excel: 4 Steps

This is the dataset for today’s article. Suppose there is task A. The task is partially complete (say 45%). Now, I will demonstrate this information with the help of a pie chart.

how to make a progress pie chart in excel


Step 1: Prepare Dataset to Make a Progress Pie Chart

First of all, you have to prepare the dataset. We will use a simple formula to create the dataset so that our chart becomes a dynamic one. Let’s do that step by step.

  • Firstly, go to D5 and write down the following formula,
=100%-C5

  • Then, press ENTER. Excel will calculate the in-progress portion considering the entire task to be 100%.

how to make a progress pie chart in excel


Step 2: Create Pie Chart from Insert Tab

It’s time to create a pie chart for this dataset. To do so,

  • First of all, select the range B4:D5.

  • Then, go to the Insert.
  • After that, go to the Pie or Doughnut.
  • Finally, choose a pie chart. I am choosing a 2-D Pie.

how to make a progress pie chart in excel

  • Excel will create a pie chart.


Step 3: Add Data Label to Pie Chart

Now, I will add a data label to this pie chart. To do so,

  • Select any portion of the chart.

how to make a progress pie chart in excel

  • Then, right-click your mouse to bring the context menu.
  • After that, select Add Data Label.

  • Excel will add the data labels.

how to make a progress pie chart in excel

  • Now, edit the labels the way you want. I have modified them in the following way.

Read More: How to Make Progress Chart in Excel


Step 4: Format Chart to Complete Task

Now, we will concentrate on formatting the chart to look visually exquisite. There is no hard and fast rule for formatting. You can do formatting as you wish.

First of all, I will edit the chart title. To do so,

  • Hover your mouse and select the chart area.

how to make a progress pie chart in excel

  • Then, give it a suitable title. I am giving the title Task A.

You can also change the color of the pies. To do so,

  • Select any pie slice.
  • Then, right-click your mouse to bring the menu.
  • After that, go to Fill.
  • Finally, choose any color.

how to make a progress pie chart in excel

  • Excel will change the color of the pie.


Final Output

Finally, with further modification, your progress chart will look like this (see the screenshot below).

how to make a progress pie chart in excel

This chart is dynamic. Because, if you change the percentage from your original dataset, the area of the chart will alter automatically.


Things to Remember

  • A progress pie chart will illustrate the portion of any task completed.
  • You can even draw a 3D pie chart if you wish.
  • You can plan for the future according to these charts.

Download Practice Workbook

Download this workbook and practice while going through the article.


Conclusion

In this article, I have demonstrated 4 easy steps on how to make a progress pie chart in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo