How To...Create a Basic Gantt Chart in Excel 2003

Excel doesn't have an option to create Gantt Charts. However, you can use Excel to draw a Gantt chart by following the simple steps in this video.

[Coolg]

Thank you Dr, O'Loughlin! I spent all day using other "tutorials" that did not work. Yours did, thank you and good work.

[ad]

I spent 2 hours trying to make one using some online guides which refused to work. Took about 5 minutes after watching this. Thanks, much appreciated.

[AnastasiaBruceJones]

This video literally just saved my life! I was dying trying to work it out from the dreadful Microsoft explanations - thank you so much :D

[Mattiethekorbat]

This was brilliant and useful! Thank you! I am in an office where they have yet to upgrade software and I was certain I'd never be able to do a gantt chart!

[smeghead]

This was mint!!
Thanks so much!!
I would have failed my ICT coursework without you!!!

[Hayes]

thank you! i just used your video step by step and finished my assignment! thanks!

[rmm]

Genius. Tx a bunch. Where were you 8 years ago...

[TheSearlChannel]

Excellent, this tutorial was extremely useful in helping me complete my university assignment. Dr. O'Loughlin, I like your work!!

[sjoakes]

Thanks for your video. I thought I was going to have to buy some special software to do a project at school, until I watched your video.

[dilinisvm]

thank you sooo much....i just created my gantt chart. Video is clear and so helpful...thank you :)

[EugeneOLoughlin]

Hi Looly,

I've never tried this, but it sounds like you need to change the format of the date cell type. Right click on the date cell and choose to display the date with the year. It should work then.

Hope this helps.

Dr E.

[eejuice]

Well done and useful video! Thank you!

[JBLiff]

thank you for posting this video, it was very useful.

[EugeneOLoughlin]

Hi PrimeAdvisory - first, many thanks for watching my video.

There is no way that I know of to do this in Excel - you many need a formal Project Management tool like MS Project. You could try to add the two days of the weekend as a task, and do this for every weekend of your project.

Dr E.

[trumpssupporter]

Here's a question - is there a way to have a certain column stop, then resume again later in the same column? I want to chart the changes in the mod team of an online community because mods were constantly getting kicked out because of feuds and then returning a few months later. I basically want to chart how often they came and left and shuffled around over time.

[AronMih]

thank you . its very hard to do especially when i still use microsoft xp in 2020.

[לירןזיידמן-גי]

Hello Eugene
Is there a way to add a vertical line on the same grpah so we can see today's date? it would be a good indication for the project on going status.
Thanks

[buffetglider]

If you are looking for a simple to use, completed gantt chart template for excel 2007 and 2010. Take a look at chartgantt. ChartGantt has developed a solution using conditional formatting that enables instant change of view (day, week, month) and schedules all 4 dependency types.

[nitemare]

@FazWardak88

you are sooo right >_<