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

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

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

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

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

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

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

  7. Great Stuff!!

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

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

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

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

    shaun
    0731370322

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

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

  14. Thank you very very much for this!

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

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

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

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

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

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

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

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

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

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

  25. Very Useful. Thank u

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

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

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

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

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

  31. Thank you very much for clear detailed instructions! You have saved me a lot of time!

  32. Thank you very much, out of interest. Can you add a "completed" column which turns the duration cells to Green if you mark a "Yes" in the completed column?

  33. thank you so much for the tutorial, it's very interesting for any planner.

  34. Thank you very much for this short massive tutorial, in fact it is simple but much helpful in my job activities. I need you to send me all the steps in an Microsoft.so that i will practice everyday during my free times.

  35. Dear Svetlana,
    it is a very helpfull Article but i think that there is a mistake at the End Date calculation formula. The formula is :
    End Date = Start Date + Duration - 1 Because End Date is included in Activity Duration.
    I think that spreadsheet might need recalculation.
    I'm sorry for the mistakes but English is not my first language
    Thank you

    1. Hi Nick,

      Thank you for your comment! In fact, End Dates are not needed for building a Gantt chart. I just explained how to calculate Duration if someone has Start Dates and End Dates.

      1. I think you are right, I focused to the tree and I've lost the forest.

  36. Thank you very much for this! One little question, If I want to show quarters instead of years (Q1,Q2,Q3,Q4) how would I do that? I have tried using 0.25 as MAJOR, this split my years in 4 quarters which is what I wanted but they were labelled ex.2020.25, 2020.5, 2020.75 etc.. How can I change this to label my year decimals as quarters?

    Thank you!

  37. Really helpful thanks!

  38. YOU SAVED ME A LOT OF TIME. THANK YOU VERY MUCH! MAY GOD BLESS YOU & YOUR FAMILY.

  39. HEY UR RIGHT

  40. AMAZING AMAZING AMAZING!THANKS SO SO MUCH FOR THIS

  41. Very nice, thanks man

  42. Thanks

  43. Gret

  44. WHAT A NICE STEPS
    I MAIL MY MAM BECAUSE I DON'T UNDERSTAND THIS BUT I HELPS ME
    THKX .MALIKKKKKKKKKKKK

  45. Thank you heaps!

  46. Thanks for such a nice explanation. Keep it up. God bless you.

  47. Really well played.

    Thought the formation was a bit deep but our attacking prowess was exquisite.

    4/10.

    All the best
    God bless
    Frank Instein

  48. Thank You, Very well explained.

  49. How do you format it so that a same task is repeated throughout the project but is undertaken at different times. (i.e. multiple bars displayed for the same task at different dates across the page)
    Thanks

  50. Thank you for the step by step directions. Question. Is there a way to display multiple start/end dates on the same task on the same line. I don't want to see 12 lines, just 1 line with 12 durations. Example: Distribute material Jan 1-5, then again each month on the same days. So 12 blocks on 1 line/task with blanks in-between?

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