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 11. Total comments: 426

  1. Thank you for an easy and effective tutorial.

  2. Thank you So much for sharing :)

  3. 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

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

  5. 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

  6. Thank you! This was a life saver!

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

  8. 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.

  9. Thanks, the article was really helpful.

  10. 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

  11. Great and helpful work. Thanks

  12. Thank you so much

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

  14. 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

  15. 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!

  16. was really helpful

  17. 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).

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

  19. Any templates for Ghatt chart

  20. Awesome article! very helpful.

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

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

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

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

  25. very helpful thanks

  26. 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.

  27. I can't change the date

  28. 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.

  29. Thank you so much for this article.

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

  31. This guide is brilliant, well written, the step by step makes it easy to follow.
    Excellent work, keep them coming.
    Thanks!!!

  32. This is brilliant and so helpful. Good work, thanks

  33. Just wanted to say thank you! this was excellent!

  34. What an incredible guide, thank you!

    In the first technique described in post, would it be possible to create conditional formatting so the colors of the task are tied to the assigned "champion"?

    For example, say Gather Requirement and UI Design will be championed by "Bob" and the rest of the tasks by "Billy". Is it possible to automatically assign "Bob" orange and "Billy" blue so it is clear who's doing what?

  35. Excellent!
    It was very helpful. Thanks.

  36. Very helpful - thank you!

  37. Great and clear tutorial, thank you.

  38. Excellent tutorial! Thank you.

  39. i really enjoy the program.
    Please include me in the group, really to expound my knowledge on gantt charts especially conditional formatting

  40. It has truly been a help in creating Gantt Chart. Great and clear instructions.

  41. That's was Great

  42. How do you name your chart inside the GANTT chart?

  43. Any chance we can modify the color/legend of gantt chart template from MS ?

  44. You have made it easy to create a great looking chart, that I probably could not have figured out myself. Thank you so much!

  45. A warm thank you for all your help, guidance and support through these easy to follow steps.
    It was very easy to follow and the final output was just as I expected.
    Thanks and know we appreciate the effort you took to prepare this tutorial.

  46. Thank you.. you are saving me time at work by helping me keep the boss pacified.. which means I can get home and spend more time with my wife.
    Plus it's sunny outside today.. who wants to spend more time in the office?

  47. Thank you so much for the much needed information! Very helpful indeed in my journey of seeing things in another perspective. More power and God Bless!

  48. Hi there,

    Thank you so much for the tutorial. I have followed all the steps and everything seems to work fine but my x-axis comes up with 'bounds' instead of the dates and I was wondering if you knew how to fix this? I'm using excel 2017 for mac.

    Thank you so much!!

  49. I had been using MarketXLS for this and it's great.

  50. THANKS A MIL FOR THE STEP BY STEP. I COULD DO IT MYSELF EVEN THOUGH IM NOT A PRO IN THE AREA. :)

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