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.
Visit my channel: www.youtube.co...
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. :)

[@eriklacorte9430]

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

[@pitzbonilla8597]

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

[@markfamulagan8320]

Grabe ka paspas maam😢😢😢

[@mayonalbay8516]

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

[@m.s.am.s.a3283]

the formula to make the project start day does not work with me. it gives me #name . how to fix this plz

[@MyatThinzarMonica]

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

[@kennethtansh7851]

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

[@MyatThinzarMonica]

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

[@NoemiTaneo]

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

[@leapinglizard3021]

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?

[@annasemisomberi]

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

[@FILFLYCONSTRUCTION]

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

[@r007avasthi]

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

[@stevenkim6869]

could you go (much) more slowly, please?

[@laimajanaudite2141]

Mine says false even tho it should be true

[@phillippalbertespino661]

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

[@vanessaencina4687]

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

[@Deb_deCoder]

2nd video of excel tutorial playlist of vertex42

[@haidermuhammed7220]

thanks

[@nancymiranda1491]

Ang galing mo naman lineth🎉