Dynamic Planned vs. Actual Gantt Chart using Stacked Bar Charts in Ms. Excel

This method allows you to track your activities on the project schedule and measure them against the schedule baseline or the planned start and end dates defined for activities.
#projectmanagement #schedulemanagement #ganttchart #baseline #pmb #projectcontrols #dashboards #reporting #plannedvsactual #pmp #msexcel #barcharts

[@BGAWD]

Thank you!

[@Engineeringly]

Thanks to you for engaging with our content!

[@shahwarsiddiqua2958]

Sir u made it very quick n easy.. Adorable

[@Engineeringly]

Hey, thank you very much for engaging with our content. Glad you found it helpful!

[@qairulothman6608]

if the task/activity list is more than 9 example 20. what will be the y axis sequence no.?

[@tmoooz]

Thanks for the video and effort.
Q: When I change the planned stacked bars to (X Y Scatter), the whole chart change not only the planned.
What should I do?

[@Engineeringly]

Hi Ibrahim, please make sure that you follow these two steps. First, make sure to add the locations on the y-axis to the stacked bars and next make sure to select only the part of the stacked bars which represents the values of the locations on y-axis. I believe there won’t be any problem. If it’s still not solved, send me your file on LinkedIn at linkedin.com/in/aqhotak.

[@IronM19]

@@Engineeringly hi. I have the same problem I think and already made sure to follow your advice from above. When I convert the bars into scatter chart it changes the entire chart into some dots and a few vertical bars, the dates go from top to left... I'm using Office 22 wit M365. Do you have a fix for this ?
Later Edit: apparently in newer versions, when you click change chart, there's a "combo" section down below and from the dropdown you select Scater just for the last bar set. So now it works.
Another issue now, if you add more activities (like 40) the "baseline" bars tend to go down further than 1 bar.

[@perclaussen7185]

Nice video, but if you have more than 9 activitites, the planned time errorbar gets dislocated, and you will have to adjust this by correcting the maximum (and min) values for the secondary y axis. Could you look into this, and explain why this happens? And please, let's see a Power BI version of this chart. Thanks :)

[@Engineeringly]

Hi Per, yes that’s absolutely correct that the error bars get dislocated. I’ll have to recheck to see if there is a solution to that. The Power BI version was requested before this too, and we’ll definitely make a video on that. Lastly, your comment helps us make better content. Thank you for engaging with our content.

[@SoumyaPodder]

hi, i am getting problem when i am trying the scatter chart, the shape you are showing , that is not coming, it is getting reverse, i am following your steps, here problem , i am getting, how to solve that?

[@himanshupharawal6752]

Do anone have this template to be able to download?

[@Engineeringly]

Hi Himanshu, thank you for engaging with our content. Can you comment down your email address?

[@RATNESHKUMAR-nz7kq]

Hi can you make for Power BI

[@Engineeringly]

Hi Ratnesh, thank you for the comment. Yes, we will plan to have the video the earliest. And I’ll leave you the link to that under your comment here.

[@simoneruginenti7597]

hi, can you share it?

[@Engineeringly]

Hi Simone, would you please write down your email address?

[@RaviSharma_27]

@@Engineeringly I too need it.

[@Engineeringly]

@@RaviSharma_27 Hi Ravi, may I have your email address please?

[@SoumyaPodder]

may i have your email id please?, then i can share you upto my last prepared steps

[@Engineeringly]

Hi Soumya, send it at [e-mail]