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

  1. I am using a Gantt chart to show comparative lifetimes of members of a family tree.
    Works very well although I need to reduce the the gaps between individual's data, so that I can a large family on a single chart.
    Thanks for the help.

  2. When I do this in Excel my minimum Axis defaults to 0 as opposed to selecting the lowest date as yours shows. I understand I can manually override it, but defeats the purpose of a rolling task log that can be used for years

  3. How can I put the task name on the rectangles and show their links

  4. Good work, keep it up

  5. Thank you so much for this! It was really, really helpful.

  6. On my side I want to make annual training sport template that will have months and days.

  7. Great article! Very informative, easy to follow and understand, and the graphics helped tremendously! It's one of the best articles I've found on the web about creating a Gantt chart. Thanks!

  8. Is there anyway to have a start and end date column but have some logic that if the end date is blank only 1 cell is populated?

    I can understand if you want to display multiple days in a single row having a start and end date, but its annoying needing to put an end date for a single day.

  9. Thanks, this is really helpful for the beginner.

  10. How to draw a PERT Chart that is having subtasks or to forward Gantt Chart to PERT Chart?

  11. Thank you So much for Share Grant chat and My project is smoothly completed So may thank you.

  12. You are helping me alot to get my project done.
    Thank you so much.

    From Papua New Guinea.

  13. Hi Svetlana, Brilliant, just brilliant. I have no other adjective to describe you. Thank you for your time and generosity.

    Kind regards,

    Geoff.

  14. Thank you. This was so helpful. Can we keep no. of months instead of dates?

  15. Thank you. This was so helpul.

  16. Thank you so much. You have just saved my life

  17. Wow..this is amazing, you have no idea how much you have helped me out. Thank you so much

    One question, would it be possible to add a straight line, as some sort of DEADLINE/CUTOFF in the excel gantt?

    I saw this: https://www.ablebits.com/office-addins-blog/add-vertical-line-excel-chart/

    Tried to add that in this gantt excel wo any success :'(

  18. How can I make the planned duration a date and not a number?

  19. This is great. Thank you very much.

  20. Thank you very much for this.

    At least you have solved one of my technical challenges

    Thanks again for work well done

  21. Thank you. This is so well written. I would like to emulate the way you write.

  22. This helped so much thank you!!

  23. Thanks. This was helpful article. You delivered it like a teacher?

  24. Is it possible to control the color and transparency of the bars with data? For example, I'd like to have a start date and end date, but also a "level of effort" measure to indicate how much time a person will likely spend on a task within the start/end dates.

    then if that "level of effort" could be used for the transparency that would ideal.

  25. How do we add a vertical line in the chart with the current date?

  26. Excellent tutorial. I'm using Excel on a MacBook so it's slightly different but easy enough to work out the changes necessary. Don't you just love Excel!

  27. This is fantastic!

  28. Great. Excelactly what I needed.

  29. The tutorial is just clear, useful and has helped me. Thank you

  30. Thank you! These instructions were a tremendous help since I've never built a project schedule. The notes and tips gave me an understanding of the basic components using a spreadsheet to retool it into a visual timeline of the project tasks with just start dates and duration # of days.

    I pulled up the Gantt project planner (tool) which may be easier and less tedious formatting than using the Excel Chart Tools in the spreadsheet.

    Hoping to create a final version in MS Teams Planner, but need to learn how it works.

  31. I went from never hearing about a Gantt chart today (familiarity part of job criteria) to your wonderful details. I have bookmarked this for future reference - amazing this is almost 7 years old and as I notice I am not the only one this year complementing you on this post. thank you

  32. Thank you so much. I wasted two hours watching Youtube just for the gantt chart but, damn, wish I had seen this article earlier. Great content guys. thankyou again.

  33. Great explanation and easy to follow. Managed to create a great Gantt chart at 4.am on a night shift.
    Cracking!

  34. Provided Information is very helpful wrt start Date and End Date.
    I would like to know that Is there any way to create this GANT Chart based on the hours/day? I am working on a O&M project and i need to know through Gantt Chart that how many itmes /equipment run in series, so that we could calculate the power in hourly basis.
    Thanks

  35. Hi Svetlana,

    Thanks ever so much for putting together this brilliant tutorial on Gantt Chart.

    God richly bless you.

  36. This was a life saver! Thank you and be blessed!

  37. All I can say is thanks and God bless you!

  38. Thank you SO SO SO SO SOOOOOOOOO much for posting this guide. I have been clicking on countless links that gave me absolutely nothing! And after about 10 hours of searching, I finally came across your post and my gantt chart is now complete.

    Thank you forever!

  39. Will be pleased if you reconsider the computation of the "duration" as used in your example above. it should be ((end date - start date) + 1).

    1. Hi Maggie,

      That sounds very reasonable, thank you! I've added your formula for the duration to the corresponding section.

  40. This is an absolute lifesaver. Thank you so much for this tutorial. Most excellent. Learned something new that I will use for the rest of time. :-)

  41. Thanks! excellent tutorial, clear and easy to follow.

  42. Thanks, this tutorial saved me a lot of time ?

  43. Thanks for this information. I will try and practice it on my own. Never knew one could create a Gantt chart from Excel

  44. One of the best way, it is explained. Thanks

  45. Hi,
    Great solution. Thanks.
    I wanted to add the end date to chart itself, how can I do that?

  46. You're a life saver. Thanks a lot.

  47. Great Stuff!!

  48. Your teachings are good . Well done. I don't know why my chart is of equal length and it doesn't show the duration length,
    Thanks

  49. THIS is exactly what I needed!! Thank you for spelling it out so anyone can understand and follow along. Much appreciated!

  50. Thank you for this. I couldn't follow through because at the range selection of edit series dialog for the duration, the range selection buttons look like little upward pointing arrows and to not take me range selection. Where did I go wrong?

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