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

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

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

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

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

  5. very helpful thanks

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

  7. I can't change the date

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

  9. Thank you so much for this article.

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

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

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

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

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

  15. Excellent!
    It was very helpful. Thanks.

  16. Very helpful - thank you!

  17. Great and clear tutorial, thank you.

  18. Excellent tutorial! Thank you.

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

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

  21. That's was Great

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

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

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

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

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

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

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

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

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

  31. Hi Svetlana,

    Just stumbled across this article while trying to create a Gantt chart in Excel. This was extremely helpful, straightforward, and useful. Thank you so very much for writing it =) =)

  32. Svetlana, I cannot tell you how helpful this is. Thank you very much for this fantastic document.

  33. Hi There, How do I extend dates past the dates given on the template? For example, if I want a project to go into July, i can't get the blue bar to reflect into July even when I duplicate the week number, day, etc...

    Thank you,

  34. Thank you so much, Svetlana! This short tutorial and the resources listed at the end are fantastic!

  35. I'm not sure if someone else has already asked this, but does anyone know how to write the start/end dates properly? Whenever I type down 31-Jan-17 it automatically changes to 31/01/17.how do I stop this?

    1. Hello Tannglynn,

      When you type a date in a cell, Excel automatically converts it to the default date format. To display dates in your own format, do the following:

      - Select the cells where you want to enter (or have entered) the dates and press Ctrl+1 to open the Format Cells dialog.
      - On the Number tab, and select Date in the Category list.
      - Under Type, pick a desired date format, and click OK.

      For more information, please see How to change date format in Excel.

  36. Anyone know how to make my tasks name appear in full within the gantt chart?

    2. Not sure if this is what you mean, but to make the column bigger to fit the words you can slide your mouse to the lines separating the rows. Once you do that your on-screen mouse will change to the four arrows and you can pull your column outwards by moving the mouse or your finger if you're on a touch screen device

      1. Alternatively,having seen such kind of four arrows as instructed,just left double click the mouse, then the column will be adjusted automatically to fit the size of the information to be accommodated.

  37. THANK YOU

  38. I need to do a Grantt cash and C-flow?

  39. Thank you very much. Your explanations were very helpful I was able to create my first Gantt Chart on my very first try. :)

  40. Chart is not take actual date on X-Axis. Kindly help to take the actual date.

  41. GOOD DAY
    Is there a way to edit Gantt chart planner in Excel like I want completed task percentage bar to look green but in excel planner its purple in color so I want it to look green.

  42. When I copied my text for my task list on my gantt chart, it looks to be automatically right justified. Is there a way to left justify this text on the gantt chart?

    Thank you

  43. Thank you for this posting - You just saved me.
    I needed a quick fix to not having MS Project in a rush situation.
    Much appreciated.

  44. Repeat of a question asked several times above but not answered--is there a way I can make this work for repeated tasks? The above steps work well for linear tasks, but let's say I need 'documentation' to appear every 60 days in my chart, ie I have more than one start and end dates for a single line item. How do I reflect that?

    1. I am wondering about that too but looks like Svetlana is choosing to not respond to that.

  45. Adding more task didn't affect the chart. how's it done? thanks

    1. This is happening to me as well. When I change the dates from the original chart it is reflected in the bars, but when I add tasks they are not being added to the Gannt chart....

  46. Thank you! It was very useful

  47. Thank you for the support, this was very helpful

  48. how about in tablet or phone how to combine the task?

  49. I just wanted to say thank you for such a fabulous and easy to use tutorial. In my 12 years as a legal assistant, I've never been asked to create a Gantt chart until today, and I impressed my boss! Thanks for helping me not look like an idiot...because let's get real, I didn't even know what this was until today!

  50. How do I add an additional task once the chart has been completed and in use?

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