Gantt Chart Excel Tutorial in Hindi || Make a gantt chart with automatic chart update with dates ||
Vložit
- čas přidán 24. 08. 2024
- In this video, I will show you how to make a basic Gantt Chart. This is a basic gantt chart with Project Plan start & End Date and Project actual start and end date. As soon as you enter date in the cells, chart will get updated automatically. We have covered all the steps to make a chart from scratch.
Get Excel File: gumroad.com/l/...
#GanttChart
#ProjectPlanning
#MSExcel
Thankyou
Thank you for assisting me. From Cape Town South Africa
Sir kaafi knowledgeable videos hai please Inn formula pr videos banee
Plz make video for weekwise instead of datewise.
Means W1,W2,W3,W3 for perticular month then same for next month.
Your are excellent
Very greatfull to you for making this.
Baljeet Bhai , Very informative video. Thanks for sharing your valuable knowledge
Ek video men formula samjhayye aaram se plz, excellent teaching sir
Help me alot to complete my task
Valuable information share...thanks
Baljeet, that was wonderful tool you developed. i am a novice in excel, only using basics of excel. Hence request you to please share this file of Gantt so that i can start working and tutoring ourselves
Get Excel File here: mbaljeetsingh.gumroad.com/l/jlXoQy
Thank you so much sir.
It is good, please also make weekly and monthly project chart for longer projects
Thank you
Very nice and easy to und.Thanks.
Thank you sir
Maine bana Diya sir ji
Very useful brother tq
lovely to see nd very informative ...thank you so much
Thanks, Very nicely explained, looking forward for more videos.
So too hard work
Kuch easy ho skta h kya
Zabrdast paaaji
🙏nicely Explain👌
Good information
SO helpful for me. Thank you guy!
helped me a lot, thanks! Just want to know is there is a way to hide weekends (Sat-Sun)? Deleting Sat-Sun is messing up with the date logic.
Helpful!
Thank you!
Hi Sir, Can you provide the formula where i can start with number of week, not with date?
Good work
Needful
Wonderful
Sir please make video on gantt chart on hourly basis for daily planing.
Was really helping THANK YOU SO MUCH SIR
Good video sir
thank you very much
Good Gant Chart
Sir please request to week wise or month wise schedule required
Very useful video... but just want to know .. how we can eliminate sunday .or weekends.... & particular day... in such kind of charts
Superb, Sir 👍
Help full.. Thank You
Thank sir✌
Very Good. Kindly add one Column cor Duration = No. Of Days. Again Thank You.
Sir thanks
Dear please send me this template for my use, it's great
Just loved it🧡.. thanks a lot 🙂🙏
I like your gantt format but i can understand the way you do it, it's complicated
Got it.. 🙂
Its help me in my project
Sir , How to keep print out of this gant chart for record.
Kindly monthly base pr kesy bnayegy gantt chart.
Good Morning . Very Nice Explained and I implemented on my files. I have one question regarding in this. In UAE we consider Friday is Holiday, so accordingly all the activity shall be impact ,could you please explain this logic in this Excel Sheet .
Hi Mohammed Noufal, in the video, all days are mentioned. If you are asking your week to start on satuday, that you can do by changing the weekday function to respective value.
Sir jo ye activity hai usme hm kuch bhi mention kr sakte hai
Can colorblind poeple make this chart?
What happens if we only have start date not knowing the exact end date
I want to add holidays into Gantt chart
Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere
Please upload the excel file of this Gantt chart in description so that one can download
Get Excel File here: mbaljeetsingh.gumroad.com/l/jlXoQy
@@mbaljeetsingh Hi sir , I just watched the video , it’s really helpful . Can I get your email id for further discussion on this pls ? I wanted this file . Thank you 🙏🏼
@@s2_p_2524for file u need to be pay money
Sir I want to know how to take task duration.
sir i am not able to get "X " on the start date of the month
Baljeet Paaji how can we do it in month & not in week
Jii in this chart how do we avoid the weekend days with manual entry
Hi Siva, you can simply not write formulas for weekend at first place. That should help
Can you please provide the formula which is avoid Friday
=IF($B5="","",IF(AND($C5=F$3),"x",""))
You can simply delete column having friday and copy the same for all weeks
Can you explain it in English
Subtitle Sir 🙏🙏😁
Paaji bahut he tedious method hai, bahut time lagega,
isse zyada bakwas video maine nahi dekheya abhitak
Sorry
English . Selfish man
Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere