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

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

  2. This helped so much thank you!!

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

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

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

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

  7. This is fantastic!

  8. Great. Excelactly what I needed.

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

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

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

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

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

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

  15. Hi Svetlana,

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

    God richly bless you.

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

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

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

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

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

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

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

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

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

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

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

  27. Great Stuff!!

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

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

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

  31. Thank you for this. really helpful for a novice.

    shaun
    0731370322

  32. Is there any way to create this GANT Chart based on the 8-hours day?
    Just like we do in MS Project, we put duration (in hrs.) and Start date, and Finish date is calculated based on it.
    Like If, duration is 8 it should add 2 days to Start date.

    1. Did anyone answer your question? I'm still looking at hourly gannt charts stretched over 3 days.

      1. You can do it by changing the cell format to Date/time so you can see the time.
        Also change the duration cell format to custom [hh:mm] so you will see the accumulated hours between tasks.
        Notice that the hours calculated are based on 24 hours a day.

  33. HI! Svetlana,
    it's really explained very easily but i have only one concern while making it.
    some bars aren't reaching to the month for which i have mentioned the end date.
    example:- i have an activity ending in 20-May'21 but its bar is just reaching to Mar'21.
    please support

  34. Thank you very very much for this!

  35. super fantastic! Free and easy to use! thank you so much.

  36. Thank you..After 2 hours of brain ticking finally made my sheet with the help of your explanation..

  37. Excellent! So nicely explained every detail along with reference to ready to use charts. Though I used the methods you explained and was able to get a nice Gantt Chart for a big project.
    Thank you so much!

  38. Thank you so much for making life easy for novice like us.
    this is one of the best tutorial on gantt chart.
    Gracias!

  39. Well explained. You have made my assignment easy. Thank you

  40. How do you put the dates on top but one cell equals one week?

  41. Absolutely brilliant this walk through.
    I'm chuffed with my Gantt chart.
    Thanks for taking the time to make this page.

  42. Thank you so much for this simple powerful tutorial.

  43. Thank you very much for your help.
    Keep up the good work!

  44. Many thanks for this simple yet informative explanation - I have wasted a whole day looking at other versions but this is the easiest to follow.

    Anne

  45. Very Useful. Thank u

  46. Thank you so much for this clear set of instructions on creating a Gantt chart! It has helped me immensely.

  47. Nothing is difficult if one is capable for teaching. Thank you very much Svetlana.

  48. Thanks Svetlana for this amazing tutorial!
    I'm using Excel for Mac v16.34 and could easily follow your step-by-step guide.
    I do have a couple of questions though:
    a) The timeline follows a 7-day calendar week, but I need it to show a 5-day working week. How can this be done?
    b) Is it possible to add a red vertical line that automatically indicates the current date?

  49. Thank you for the step by step instructions along with the graphics. I Have not been on Excel for a few years and yet I could follow every step quite easily.
    I do have a question. I am using your Gantt chart approach to display my ancestry, generation by generation for all seven generations on one page, therefore there are fourteen bars which represent the birth and ages of each generation. (The Tasks are people and the beginning dates are their birth dates and durations are ages.) After creating the Gantt chart all seven pairs (14 tasks) are blue. I would like to make the Males blue and the Females pink so people seeing the chart can see the flow of husbands and wives more easily across generations. But Excel does not allow conditional formatting (I do have a column for Sex(M and F)). I wondered if you had a straightforward solution? My other question is Can I put their ages at the end of each bar?
    Thank you so much!!

  50. Can you edit details after already saving your Gantt chart? For example, I tried to change the options from 30.0 yo 2.0 on the fixed Axis Options, but it vouldn't

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