Gantt Chart Excel Tutorial in Hindi || Make a gantt chart with automatic chart update with dates ||

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

[@meetoswal101]

Thankyou

[@riettefourie8928]

Thank you for assisting me. From Cape Town South Africa

[@rahuljha5972]

Sir kaafi knowledgeable videos hai please Inn formula pr videos banee

[@CourseforcivilEngineering]

Plz make video for weekwise instead of datewise.
Means W1,W2,W3,W3 for perticular month then same for next month.

[@rohitnrg]

Your are excellent
Very greatfull to you for making this.

[@dhirajgawde6819]

Baljeet Bhai , Very informative video. Thanks for sharing your valuable knowledge

[@gcsindia528]

Ek video men formula samjhayye aaram se plz, excellent teaching sir

[@engr.muhammadishaque8918]

Help me alot to complete my task

[@akshaytone1897]

Valuable information share...thanks

[@piyushrvyas]

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

[@mbaljeetsingh]

Get Excel File here: mbaljeetsingh.gumroad.com/l/jlXoQy

[@Waseemyounus15]

Thank you so much sir.

[@lelounga7932]

It is good, please also make weekly and monthly project chart for longer projects
Thank you

[@lawrencejiwan7158]

Very nice and easy to und.Thanks.

[@RajanandSinghSupport675]

Thank you sir
Maine bana Diya sir ji

[@TheKiranlntecc]

Very useful brother tq

[@Rmujib47]

lovely to see nd very informative ...thank you so much

[@ashishq2002]

Thanks, Very nicely explained, looking forward for more videos.

[@mohd.ibrahim737]

So too hard work
Kuch easy ho skta h kya

[@anwarpatelrazvi]

Zabrdast paaaji

[@RS_Randy]

🙏nicely Explain👌

[@flowcharttocodeconverter936]

Good information

[@thomastung1378]

SO helpful for me. Thank you guy!

[@nehagoyal5236]

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.

[@aishwaryakamra2034]

Helpful!
Thank you!

[@pratikmishra19]

Hi Sir, Can you provide the formula where i can start with number of week, not with date?

[@govindkerai8717]

Good work
Needful

[@osyuvancmanjunathan1452]

Wonderful

[@trickshot.]

Sir please make video on gantt chart on hourly basis for daily planing.

[@rojahazarika8960]

Was really helping THANK YOU SO MUCH SIR

[@DeepakRajput-ik1qm]

Good video sir

[@user-ju6kv3tc4m]

thank you very much

[@abdulwahabal-anesi1961]

Good Gant Chart

[@balasaheblokhande391]

Sir please request to week wise or month wise schedule required

[@csukani]

Very useful video... but just want to know .. how we can eliminate sunday .or weekends.... & particular day... in such kind of charts

[@kapileshdubey2597]

Superb, Sir 👍

[@harshadpatkar5346]

Help full.. Thank You

[@vipsingh7273]

Thank sir✌

[@farooqbashir4111]

Very Good. Kindly add one Column cor Duration = No. Of Days. Again Thank You.

[@kamleshmishra8020]

Sir thanks

[@samirparmar3318]

Dear please send me this template for my use, it's great

[@rakeshghosh741]

Just loved it🧡.. thanks a lot 🙂🙏

[@edilbertoaustria19]

I like your gantt format but i can understand the way you do it, it's complicated

[@juststart8387]

Got it.. 🙂

[@JustSharing]

Its help me in my project

[@sibanandamishraeeedept1831]

Sir , How to keep print out of this gant chart for record.

[@solooutvlog]

Kindly monthly base pr kesy bnayegy gantt chart.

[@noufalsm]

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 .

[@iqbalsingh6311]

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.

[@AbhaySingh-or6bj]

Sir jo ye activity hai usme hm kuch bhi mention kr sakte hai

[@devendrakushwaha5048]

Can colorblind poeple make this chart?

[@kathirvel6565]

What happens if we only have start date not knowing the exact end date

[@balvinderjp]

I want to add holidays into Gantt chart

[@cartoon_TVDc]

Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere

[@vinodsharma-ud6bc]

Please upload the excel file of this Gantt chart in description so that one can download

[@mbaljeetsingh]

Get Excel File here: mbaljeetsingh.gumroad.com/l/jlXoQy

[@s2_p_2524]

@@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 🙏🏼

[@nanda2.037]

​@@s2_p_2524for file u need to be pay money

[@dineshkumarsaxena1939]

Sir I want to know how to take task duration.

[@pawankishore4933]

sir i am not able to get "X " on the start date of the month

[@irfanzia4147]

Baljeet Paaji how can we do it in month & not in week

[@sivaprabhu9243]

Jii in this chart how do we avoid the weekend days with manual entry

[@iqbalsingh6311]

Hi Siva, you can simply not write formulas for weekend at first place. That should help

[@noufalsm]

Can you please provide the formula which is avoid Friday
=IF($B5="","",IF(AND($C5=F$3),"x",""))

[@iqbalsingh6311]

You can simply delete column having friday and copy the same for all weeks

[@edilbertoaustria19]

Can you explain it in English

[@Godblessforeveryone]

Subtitle Sir 🙏🙏😁

[@user-xp8kp2zk7w]

Paaji bahut he tedious method hai, bahut time lagega,

[@shakifrauf2204]

isse zyada bakwas video maine nahi dekheya abhitak
Sorry

[@josephneequaye7206]

English . Selfish man

[@cartoon_TVDc]

Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere