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

  1. Good work but I observed that the start date on the Gantt chart doesn't tally with data.

    1. Hi Sammies,
      You can change the start date as explained in Step 6. Improve the design of your Excel Gantt chart.

  2. Thanks Svetlana - this was very easy to follow.
    Clear, concise steps with suitable screen-shots.
    Much appreciated!

  3. very appreciated for the sharing! It's very helpful to me!

  4. This is IT, so informative it has helped me a great deal

  5. Thank you very much for such a detailed step by step explanation. This really helped me to generate my own Gantt chart in such an easy and time saving way. Thanks once again. God bless! :)

  6. Thank you for very informative article
    One questions: how did you make the date labels show the mid of the month and then the end of the month? By setting the "major units" at 15, makes the labels to be shown every 15 days, which not necessarily falls on the mid or end month, since some months will have 31 days.
    How to show the labels as: Jan 1, Jan 15, Feb 1, Feb 15, Mar 1, Mar 15, etc ?

  7. Thank you for the simple, straightforward instructions. Just what I needed and I have my own template now that I can quickly fill in and put to use.

  8. Thank you, It was explained well.

  9. Thank you so much! Very informative and useful.

  10. Thank you so much, you helped me out of a sticky situation. so kind of you to share your knowledge.

  11. Thank you so much for this Svetlana. Very easy to follow and perfect for what I need. Excellent work!!

  12. Thanks very nicely explained.

  13. Thank you for the excellent step-by-step instructions with example screen shots.
    With your instructions I was able to create a Gantt chart in my existing spreadsheet that provides an nice visual to target dates.

  14. Hi. what if you have several tasks to do in one day? how will you reflect that in your gantt chart in such a way that the time for each task follows each other without spilling into other days?

  15. Hi there
    I'm in the process of making a GANTT for a project I'm working on which has specific dates for events/meetings etc alongside tasks which may take between 1 week and 2 months to complete. Is there a way to incorporate these into a GANNT in addition to blocks of time?

  16. Svetlana,
    I cannot thank you enough for the Excel Gantt chart process and tips you provided. It certainly saved me a great deal of time tonight and my presentation is now ready to go! Your efforts are truly appreciated! Thank you very much.

    Regards,
    Lynn

  17. Thanks...very useful...

  18. this tutorial is great and setting up from scratch works way better than most available templates due to formatting.

  19. great explanation step by step in detail... thank you team.

  20. Let great thanks be posed to the developer and publisher of the tutorial. It has been extravagant helpful and self explanatory thus eases quick understanding.
    Thanks a lot

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

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

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

  24. SvetlanaChka;
    Ochin Harasho, otlichno, Spazibo

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

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

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

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

    your response will be highly appreciated.
    Thank you.

  29. lol there is a gantt chart template anyway now

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

  31. Very helpful,thank you very much.

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

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

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

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

  36. Really helpful tutorial! Thanks!!

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

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

  39. Really useful and intuitive tool
    Thanks! wayne

  40. good and excellent one for begineers

  41. Thank you for an easy and effective tutorial.

  42. Thank you So much for sharing :)

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

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

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

  46. Thank you! This was a life saver!

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

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

  49. Thanks, the article was really helpful.

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

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