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 →

Comments page 10. Total comments: 426

  1. Hi,
    This has been one of the best instructions I've found on the net for anything I needed. I needed to make a gantt chart quickly (in half an hour) and thanks to the instructions given here, I've succeeded.
    Thank you!

  2. I used your technique and have time on the horizontal axis, date on the vertical and am plotting duration. Is there a way to color code my bars according to the task they were doing for each specific duration of time?

  3. This is very helpful. but i need to also actual duration to be reflected on it. so that i can monitor through graph whether i am on or behind the schedule

  4. SvetlanaChka;
    Ochin Harasho, otlichno, Spazibo

  5. How to adjust the time line to Hours & Minutes scale instead of Days?
    This is needed for monitoring small projects with a number of tasks that run through 1 or 2 days.

  6. Thank you for your tutorial. this is extremely helpful. Does anyone know how to add the end date as the label of the bar?

  7. Hi @Svetlana Cheusheva - you are amazing thank you.

    Btw, I followed all your instructions and I am happy to say that i was been able to successfully replicate it. However, whenever I add a new task - it seems that the its not added in the chart and the formula for duration is not following :(
    I tried to drag hoping it will copy the formula but kinda weird that it is not copying.

    Please anyone help.

    Thank you

  8. How to swap task,either above or below one the other?

    your response will be highly appreciated.
    Thank you.

  9. lol there is a gantt chart template anyway now

  10. Thank you so much Svetlana,
    the explanation & its way is so good. I really learnt & I was so happy when the Gantt was building up in parallel to your steps.

    My only problem was that the date format was in numbers, I tried to format it to desired date format, it is not working hence the chart shows huge numbers, nevertheless, I will try again to fix it. Hopefully I can do it.

    thanks a ton for this knowledge
    Wish you Svetlana

  11. Very helpful,thank you very much.

  12. Very easy and useful.
    I was wondering if it is possible to add vacancy breaks in the chart.
    I want to design it so that the tasks that will occur during the vacancies are delayed after the break.Is it possible? Any help appreciated!!

  13. Very helpful, thank you very much for sharing step by step instructions.

  14. I got all the way through the tutorial with no issue until Step 6. What I see now is extra dates to the left of my actual start dates for the project. In other words, I have dates in the top axis that I cannot remove and start before the project actually starts. Any help is appreciated!!

    1. Hi Alayna,

      Please see Step 6. Improve the design of your Excel Gantt chart. It explains how to remove extra dates in the left part.

  15. Thank you! Best instructions I could find. Thank you.

  16. Really helpful tutorial! Thanks!!

  17. thank you so much for this post, you help me alot, but why my horizontal axis cant be name like your's..

    pls tell me what is wrong with my table.

    Thanks in advance.

    1. i was able to figure it out..
      thankss again..

  18. Hello, I just wanted to express my thanks to you so much for the thorough walk through. Keep up the good work!

  19. Really useful and intuitive tool
    Thanks! wayne

  20. good and excellent one for begineers

  21. Thank you for an easy and effective tutorial.

  22. Thank you So much for sharing :)

  23. Up until today never designed a Gannt Chart , the tutorial was very good easy to follow once i got over the Excel glitches and worked my way through it, once I had created the chart and adjusted all the looks it looked impressive from my point of view, Have sent it in for my Diploma assessment, thanks for the good tutorial
    Curious to know is there an easy way to add an additional line to the chart without redesigning it all

  24. This worked very well for my needs. Thanks for making me look like a rock star.

  25. Is there a way I can set different colours based on the contents of another column, like a conditional format / category.

    1. Did you manage to find an answer to this question? This is exactly the same as what I need

  26. Thank you! This was a life saver!

  27. Hi again,
    I was able to figure it out. Great, great tutorial,
    Thank you very much.

  28. Hi, I was able to get the start dates on my chart, but when I tried to get the duration, I got the message that my data range is too complex, but it really isn't. I have, for example duration of 7, 22, 27 days. When I open the select data box and try to do the duration, it will not highlight it. I cannot figure out what I am doing wrong.

  29. Thanks, the article was really helpful.

  30. Loved this! Had to create a Gantt chart for my studies and didn't have a clue where to start - thank you so much! :D

  31. Great and helpful work. Thanks

  32. Thank you so much

  33. I have no idea how I got here!!!!! BUT YOU ARE AMAAAAAAAAZING!!!!!!!!!

  34. I cannot get rid of vertical axis(bottom) showing as percentages instead of my selected data (dates) when I first select the bar graph. I have unlocked the protecton on the cells and reset it but it still shows the axis as percentages. Thanks

  35. Thank you so much for this tutorial. It was very easy to use and I've managed to make my Gannt chart to plan out my dissertation for university!

  36. was really helpful

  37. Hello everyone,

    Why this chart is starting from Jan 11? Here also the earliest activity start date is Mar 1, 2014. I followed the same steps and my first start date is Nov 27 but on my chart's date axis all activities are starting from Nov 11.

    Please explain and tell me what I am doing wrong.

    Thanks and Regards
    Vabz

    1. Hello Vabz,

      Blue bars starting from Jan 11 were only an intermediate result. On step 5, we make them disappear so that only orange bars are visible (the earliest activity start date is Apr 1). To improve your Gantt chart further, please follow the instructions from step 6 that explain how to remove the empty space on the left side of the chart. The result is shown in the screenshot at the end of step 6 (the date axis beginning with Apr 1).

  38. No words to thank you... simply thank you for sharing your knowledge. You people make this earth more beautiful. Thank You So Much.

  39. Any templates for Ghatt chart

  40. Awesome article! very helpful.

  41. Great explanation, very useful feature, already rolled out to my team
    thank you very much

  42. Thank you so much this has been so helpful.

  43. really help even it simple. but ya..we got the main point

  44. Hi there - this is great, thanks! Is it possible to omit weekend (saturday and sunday) from being part of the duration?

  45. very helpful thanks

  46. Thanks to your excellent, easy to follow article, I was able to create a Gantt chart that met most of my requirements. However, I cannot get it to display more than 8 tasks even though I have more than that in my table. I have played around with the Gap Width and Series Overlap values but it doesn't make any difference. Is here a setting that governs the number of bars you can display?

    I am using Excel 2016 in the Office 365 Pro Plus suite.

  47. I can't change the date

  48. Thank you so much for this exceptionally clear and helpful tutorial! I (still) have Office 2011 for Mac, and it was easy to follow your instructions and make a chart that looked exactly the way I want.

  49. Thank you so much for this article.

  50. Thank You! This is very helpful. You saved my day long work.. :)

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 :)