How to Make a Simple Gantt Chart in Excel
HTML-код
- Опубликовано: 11 фев 2021
- 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: ruclips.net/user/LinethDelaC...
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. :)
ang galing nyo ms.lineth keep on sharing your knowledge po, salamat this is very helpful.
Super helpful po ma'am, thank you po. Merry Christmas. 🎉
Ang galing mo naman lineth🎉
thanks
my head's paining after trying to copy this... too complicated , but the author is really an expert
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
How to did anchor on the task_start, task_end and progress? After clicking name manager, there is no option for anchoring
Does anyone know how to remove the weekend from the dates? I only want to show the work week (Mon - Fri).
Could you please explain how to copy the formula and paste it in conditional formatting l am stuck up there
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
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?
I cannot use this formula for completed progress in google sheet. How can I do? Please advise me. Thank you
How to do this in a monthly basis per week? Thanks
I didn't see what you input in the custom field before insert the data bar.
HI PAANO KUNG HINDI MO ISAMA ANG WEEKEND LIKE SUNDAY? THANK YOU
Mine says false even tho it should be true
could you go (much) more slowly, please?
Grabe ka paspas maam😢😢😢