Comments on: How to make a Gantt chart in Excel

See how you can quickly make a simple Gantt chart in Excel, where you can download advanced Excel Gantt chart templates or utilize the online Project Management Gantt Chart generator. Continue reading →

Table of contents

Comments page 5. Total comments: 426

  1. Absolutely brilliant this walk through.
    I'm chuffed with my Gantt chart.
    Thanks for taking the time to make this page.

  2. Thank you so much for this simple powerful tutorial.

  3. Thank you very much for your help.
    Keep up the good work!

  4. Many thanks for this simple yet informative explanation - I have wasted a whole day looking at other versions but this is the easiest to follow.

    Anne

  5. Very Useful. Thank u

  6. Thank you so much for this clear set of instructions on creating a Gantt chart! It has helped me immensely.

  7. Nothing is difficult if one is capable for teaching. Thank you very much Svetlana.

  8. Thanks Svetlana for this amazing tutorial!
    I'm using Excel for Mac v16.34 and could easily follow your step-by-step guide.
    I do have a couple of questions though:
    a) The timeline follows a 7-day calendar week, but I need it to show a 5-day working week. How can this be done?
    b) Is it possible to add a red vertical line that automatically indicates the current date?

  9. Thank you for the step by step instructions along with the graphics. I Have not been on Excel for a few years and yet I could follow every step quite easily.
    I do have a question. I am using your Gantt chart approach to display my ancestry, generation by generation for all seven generations on one page, therefore there are fourteen bars which represent the birth and ages of each generation. (The Tasks are people and the beginning dates are their birth dates and durations are ages.) After creating the Gantt chart all seven pairs (14 tasks) are blue. I would like to make the Males blue and the Females pink so people seeing the chart can see the flow of husbands and wives more easily across generations. But Excel does not allow conditional formatting (I do have a column for Sex(M and F)). I wondered if you had a straightforward solution? My other question is Can I put their ages at the end of each bar?
    Thank you so much!!

  10. Can you edit details after already saving your Gantt chart? For example, I tried to change the options from 30.0 yo 2.0 on the fixed Axis Options, but it vouldn't

  11. Thank you very much for clear detailed instructions! You have saved me a lot of time!

  12. Thank you very much, out of interest. Can you add a "completed" column which turns the duration cells to Green if you mark a "Yes" in the completed column?

  13. thank you so much for the tutorial, it's very interesting for any planner.

  14. Thank you very much for this short massive tutorial, in fact it is simple but much helpful in my job activities. I need you to send me all the steps in an Microsoft.so that i will practice everyday during my free times.

  15. Dear Svetlana,
    it is a very helpfull Article but i think that there is a mistake at the End Date calculation formula. The formula is :
    End Date = Start Date + Duration - 1 Because End Date is included in Activity Duration.
    I think that spreadsheet might need recalculation.
    I'm sorry for the mistakes but English is not my first language
    Thank you

    1. Hi Nick,

      Thank you for your comment! In fact, End Dates are not needed for building a Gantt chart. I just explained how to calculate Duration if someone has Start Dates and End Dates.

      1. I think you are right, I focused to the tree and I've lost the forest.

  16. Thank you very much for this! One little question, If I want to show quarters instead of years (Q1,Q2,Q3,Q4) how would I do that? I have tried using 0.25 as MAJOR, this split my years in 4 quarters which is what I wanted but they were labelled ex.2020.25, 2020.5, 2020.75 etc.. How can I change this to label my year decimals as quarters?

    Thank you!

  17. Really helpful thanks!

  18. YOU SAVED ME A LOT OF TIME. THANK YOU VERY MUCH! MAY GOD BLESS YOU & YOUR FAMILY.

  19. HEY UR RIGHT

  20. AMAZING AMAZING AMAZING!THANKS SO SO MUCH FOR THIS

  21. Very nice, thanks man

  22. Thanks

  23. Gret

  24. WHAT A NICE STEPS
    I MAIL MY MAM BECAUSE I DON'T UNDERSTAND THIS BUT I HELPS ME
    THKX .MALIKKKKKKKKKKKK

  25. Thank you heaps!

  26. Thanks for such a nice explanation. Keep it up. God bless you.

  27. Really well played.

    Thought the formation was a bit deep but our attacking prowess was exquisite.

    4/10.

    All the best
    God bless
    Frank Instein

  28. Thank You, Very well explained.

  29. How do you format it so that a same task is repeated throughout the project but is undertaken at different times. (i.e. multiple bars displayed for the same task at different dates across the page)
    Thanks

  30. Thank you for the step by step directions. Question. Is there a way to display multiple start/end dates on the same task on the same line. I don't want to see 12 lines, just 1 line with 12 durations. Example: Distribute material Jan 1-5, then again each month on the same days. So 12 blocks on 1 line/task with blanks in-between?

  31. This is so detailed and was really helpful. Thanks.

  32. This was so detailed and helpful. Really appreciate.

  33. thank you very much... it was very helpful...

  34. Thank you...

  35. As others have said (but I have to reiterate because of how thankful I am), this is a fantastic help and so well explained. Thank you so much!

  36. This is awesome and very helpful!

  37. Thank you so much for such a nice way to guide us to learn Gantt Chart.

  38. Thanks svetlana. I am also amazed by learning from yourself. Many many thanks to you.

  39. very easy to follow, thanks a bunch

  40. excellent, very clear...Thanks.

  41. please try to use pictures for every step for better understanding.

  42. Dear Svetlana,

    Thanks for most simplified explaination. I have trouble in chart when I use 2 axis. One is Date and another is % compeletion of the project. In this my axis is not working great. So, the data for and chart is not matching. A to Z all Date axis has correct data but on secondary axis A to Z is showing data for % in Z to A.

    Kindly support if possible.

  43. Thank you very much.I had no idea about creating a Gantt chart

  44. Dear Svetlana,
    I was supposed to create a GANNT chart and had no idea howto do that. Luckily, I have come across you wonderful step-by-step manual and I have managed to do one! Thank you so much for such a detailed and easy manual!

  45. This was so very helpful. I knew nothing and was able to complete my construction timeline with your very thorough steps. Thank you, thank you, thank you, thank you

  46. Explained extremely well!!

  47. well explained

  48. Thanks for the Article. There are many benefits of implementing project management software in the business and which can actually make the task very easier for project managers and the teams. I have found the best project management software after looking at its features and advantages to the users.

  49. Hello, the Blue bars doesn't got removed in my case. Can you please help.

  50. Thank you so much dear Svetlana for your simply explanation on Gantt Chart. I am very happy and pleased on your presentation which was received by me as a wonderful guideline. Thank again.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)