How to Make a Simple Gantt Chart in Excel

In this video, I will show you how to make a simple Gantt chart using Microsoft Excel.

This Gantt chart has changing cells such as the project start and week display, where it makes the calendar dates and chart dynamic.

I just applied very simple formulas that are easy to follow so you can create your own version after this tutorial.

Thanks for your time and I hope you learn something from it. :)

Help me to reach my target audience by sharing my videos with the right people. :)

[FILFLYCONSTRUCTION]

ang galing nyo ms.lineth keep on sharing your knowledge po, salamat this is very helpful.

[sjgvxfy]

Super helpful po ma'am, thank you po. Merry Christmas. 🎉

[ravasthi]

my head's paining after trying to copy this... too complicated, but the author is really an expert

[vanessaencina]

Does anyone know how to remove the weekend from the dates? I only want to show the work week (Mon - Fri).

[eriklacorte]

Hi po Ma'am, bakit po ayaw gumana ng last step para sa progress comparison? tama naman yung formula ko, ginaya ko lang yun nasa video pero parating 0 yung value, dapat magiging 1 tapos babalik sa zero, video 14:40 po na final step para makita yung progress. Salamat po

[pitzbonilla]

Hi Ma'am Lineth. Please help. I get a "circular reference" error message using the formula =C3-WEEKDAY(project_start, 3)+(week_display-1)*7

[kennethtansh]

How to did anchor on the task_start, task_end and progress? After clicking name manager, there is no option for anchoring

[annasemisomberi]

Could you please explain how to copy the formula and paste it in conditional formatting l am stuck up there

[leapinglizard]

Has anyone managed to follow along and not miss anything? I can only use half of the formulas. 2m50sec? 6m58? How did the the pre project start week go back to Dec 2020? Weekly Display did not update G5 and the rest of that row. Any help?

[MyatThinzarMonica]

I cannot use this formula for completed progress in google sheet. How can I do? Please advise me. Thank you

[phillippalbertespino]

How to do this in a monthly basis per week? Thanks

[MyatThinzarMonica]

I didn't see what you input in the custom field before insert the data bar.

[mayonalbay]

HI PAANO KUNG HINDI MO ISAMA ANG WEEKEND LIKE SUNDAY? THANK YOU

[laimajanaudite]

Mine says false even tho it should be true

[stevenkim]

could you go (much) more slowly, please?