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.
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,
- Then, press ENTER. Excel will calculate the in-progress portion considering the entire task to be 100%.
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.
- 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.
- Then, right-click your mouse to bring the context menu.
- After that, select Add Data Label.
- Excel will add the data labels.
- 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.
- 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.
- Excel will change the color of the pie.
Finally, with further modification, your progress chart will look like this (see the screenshot below).
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.
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.