How to show progress as a part of the Gantt Chart Bar Chart

Hi folks,

I have successfully imported the Task, Start, Finish, Status from a different project mgmt tool to MS Project (my favorite) and trying to develop a decent Gantt Chart for our director. Below shows what I have but now, all I need to do is to show a Progress Line or Bar with a different color as a part of each Bar. Please see below,

So the Progress Line or Bar will show based on today's date 11/21/2023) or any kind of formula to show the progress.

Could you please let me know how this can be accomplished since when I select the below option in MS Project, it put a Red Dot Symbol at the beginning of each Project shown above. There is no dependencies between these bars and each is based on an independent project. We just need to show Progress for each Bar.

Let me know if you have any questions and thanks for your time in advance.

Amini --

What you are describing is NOT how to enter progress in your Microsoft Project schedule. You need to manually enter the task progress using the % Complete field for each of your tasks individually. Otherwise, how could Microsoft Project possibly know what progress has been made on tasks? In the real world, projects DO NOT progress as expected. Some tasks may be ahead of schedule, some tasks may be behind schedule, and some tasks may not have even started yet even though they should have started. Also, in addition to using the % Complete field, you can have more accurate task tracking using the Actual Start, % Complete, Remaining Duration, and Actual Finish fields. But at a minimum, you should be using the % Complete field. Hope this helps.

Dale A. Howard [MVP]

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you Dale for your time.

I like what you are recommending for using the Remaining Duration. I was trying to see if the progress can be shown based on a calculation of Start Date of the project and Today's Date especially for the projects that have not been Completed. Therefore the LIne or Bar inside the main Gantt Chart will show based on the Starting Date and what have been done as of today. Please see what I develop in Power BI in the past.

Or even better The Bar Chart showing the Duration based on the Begin and End Date.

I don't know if it's doable in MS Project.

Thanks,

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

More information would help a lot.

It's all do-able, but not the way you are doing it. For a start, you need all tasks to be auto scheduled. Here is an example of one auto scheduled task with one resource person (me) assigned to it at 50%. That means 4 hours of work each working day 08:00 - 12:00.

The task is "in progress". It has an actual start date/time, some actual duration and some remaining duration, and a planned/forecast finish date/time.

So there is also actual work, and remaining work, also actual cost and remaining cost.

Most important, the status date/time is last Friday 17:00, and this is the red vertical line on the chart.

The bar formatting has been exaggerated to show the green progress bar which goes from the actual start up to the status date and no further.

Everything actual is in the past and everything planned is in the future.

Hope this helps

Trevor Rabey
PERFECT PROJECT PLANNING

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated November 25, 2024 Views 1,245 Applies to: