# How to Make a Progress Monitoring Chart in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to make a progress monitoring chart of sales to understand the sales condition for earning a profit for a company. Making a progress monitoring chart in Excel is an easy task. This is a time-saving task also. Today, in this article, weâ€™ll learn two quick and suitable steps to make a progress monitoring chart in Excel effectively with appropriate illustrations.

Watch Video â€“ Make a Progress Monitoring Chart in Excel

## How to Make a Progress Monitoring Chart in Excel: 2 Quick Steps

Letâ€™s say, we have a dataset that contains information about several projects of the Armani group. The name of the projects, the total working duration, the working days, work completed in percentage, and due work are given in columns B, C, D, E, and F respectively. First of all, we will make a dataset with parameters. After that, we will make a progress monitoring chart to understand how much percentage of work is completed. Hereâ€™s an overview of the dataset for our todayâ€™s task.

### Step 1: Make a Dataset with Proper Parameters

In this portion, we will create a dataset to make a progress monitoring chart in Excel. We will make a dataset that contains information about several Projects of the Armani group. We calculate the percentage of work on those projects to understand the progress of the projects. So, our dataset becomes.

### Step 2: Make a Progress Monitoring Chart from Dataset

Now, using Insert ribbon, we will import a progress monitoring chart from our dataset. This is an easy task. This is a time-saving task also. Letâ€™s follow the instructions below to learn!

• First of all, select the range of data to draw a progress monitoring chart. From our dataset, we select B4 to B12 and E4 to F12 for the convenience of our work.

• After selecting the data range, from your Insert ribbon, go to,

Insert â†’ Charts â†’ 2-D Bar

• As a result, you will be able to create a progress monitoring chart using the dataset that has been given in the below screenshot.

• Now, we will check the Axes, Axis Title, Chart Title, Data Labels, and Legend from the Chart Elements option.

• Hence, we will give the style of the progress monitoring chart like the below screenshot.

• After completing the above process, you will be able to make a complete progress monitoring chart in Excel which has been given in the below screenshot.

## Things to Remember

ðŸ‘‰ #N/A! error arises when the formula or a function in the formula fails to find the referenced data.

ðŸ‘‰ #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.

## Conclusion

I hope all of the suitable steps mentioned above to make a progress monitoring chart will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## 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.
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF