How to Make Gantt Chart in MS Excel

Join our virtual classes here:
Facebook Chat: / insightsmanila
Website: www.insightsmanila.com/webina...
Email: [e-mail]
Mobile / Viber: [phone]
Using Conditional Formatting, combined with correct IF statement, you can easily create a Gantt chart in MS Excel that automatically updates based on start date and end date.

[@jaredcardinal4365]

by far the most straight forward and easy to replicate gant chart! much appreciated

[@HeikeWiegand]

Simple and easy to use for Gantt charts in 5 min - awesome! Thank you!

[@nikitaparab5942]

Thank you sir I made it for the first time with your help 🙏🏻thank you ~From India 🇮🇳

[@neodidi]

This is the best I've seen so far that explains the whole magic happening... Others made the tutorial not for beginners...

[@ma.janinaroqueranola8835]

This made me understand easier on how to facilitate the formula to make a gantt chart rather than doing it manually. Thank you again po, sir. 😊

[@ExcelInsights]

Thank you! Glad you liked it

[@yalstudy-life]

THANK YOU SO MUCH SIR

[@lanieamata9798]

Nice!!! Learned new techniques

[@matthewredshaw9353]

Thank you very much, I have been looking for this solution for a long time!

[@katylim6702]

Thank you for sharing! You explained it very well. I appreciate the efforts you put up into this video.

[@ExcelInsights]

Thank you!

[@Noorstud]

How to flag if the date is overlapped?

[@abdullah_alhathloul_]

Thanks

[@wredteevee2973]

Thank you sir

[@RyLe21492]

thank you sir, i will use it for my planning presentation

[@ExcelInsights]

All the best

[@jamesm5213]

VERY HELPFUL THANK YOU

[@ExcelInsights]

You're welcome

[@roderickbalolong6795]

Thank You very much.🙂

[@ExcelInsights]

You're welcome!

[@karlvincentaustriaoliveros6825]

Thank you sir.

[@ExcelInsights]

You're welcome! Thank you for watching

[@iandavis9948]

Thank you 🙏

[@ExcelInsights]

You're welcom

[@smileykotens884]

Thank you very much.mwahh😊😊😊

[@ExcelInsights]

You're welcome!

[@killuazoldyik323]

thank you so much sir 😍😍😍😍

[@ExcelInsights]

Most welcome

[@deunfortunated]

Tyvm bro...

[@ExcelInsights]

You're welcome

[@rodelgarcia7509]

thanks

[@ExcelInsights]

You're welcome

[@iqbalkhan7514]

How does the histogram work if you want to calculate amount of men working? I have tried to =sum(cells) but doesn't work - please help

[@ExcelInsights]

Do you mean that each week will be 1 bar in your histogram and the number of people working will be measured by the bars?

[@iqbalkhan7514]

@ExcelInsights so basically the way you have coded the bars I have used this coding, now at the bottom I want to make a Histogram cell just to automatically calculate total men working for the day, but with the coding used doesn't work

[@PixBlend78]

What if task 1 appeared again later how it is represented

[@ExcelInsights]

Repeating or recurring tasks should appear as new entries.
It is treated as a task separate from the first instance.

[@chethanmurthy2854]

Dear Sir, Can you tell me what formula should be used if I need the time line in weeks

[@ExcelInsights]

Hi, your headers are dates of every 7 days?

[@user-go8fk6oj4n]

Tried to follow the video but mine is not showing any tips saan po ako banda nagkamali sa conditional formula huhu. Thank you!

[@ExcelInsights]

I cannot help you if I do not see the formula you made.

[@stevejones4146]

Your formula does not work I've copied to the absolute letter several times send me the copy paste link to the formula

[@ExcelInsights]

Is your file "absolutely the same" too?