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

  1. Very nice, thanks man

  2. Thanks

  3. Gret

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

  5. Thank you heaps!

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

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

  8. Thank You, Very well explained.

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

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

  11. This is so detailed and was really helpful. Thanks.

  12. This was so detailed and helpful. Really appreciate.

  13. thank you very much... it was very helpful...

  14. Thank you...

  15. As others have said (but I have to reiterate because of how thankful I am), this is a fantastic help and so well explained. Thank you so much!

  16. This is awesome and very helpful!

  17. Thank you so much for such a nice way to guide us to learn Gantt Chart.

  18. Thanks svetlana. I am also amazed by learning from yourself. Many many thanks to you.

  19. very easy to follow, thanks a bunch

  20. excellent, very clear...Thanks.

  21. please try to use pictures for every step for better understanding.

  22. Dear Svetlana,

    Thanks for most simplified explaination. I have trouble in chart when I use 2 axis. One is Date and another is % compeletion of the project. In this my axis is not working great. So, the data for and chart is not matching. A to Z all Date axis has correct data but on secondary axis A to Z is showing data for % in Z to A.

    Kindly support if possible.

  23. Thank you very much.I had no idea about creating a Gantt chart

  24. Dear Svetlana,
    I was supposed to create a GANNT chart and had no idea howto do that. Luckily, I have come across you wonderful step-by-step manual and I have managed to do one! Thank you so much for such a detailed and easy manual!

  25. This was so very helpful. I knew nothing and was able to complete my construction timeline with your very thorough steps. Thank you, thank you, thank you, thank you

  26. Explained extremely well!!

  27. well explained

  28. Thanks for the Article. There are many benefits of implementing project management software in the business and which can actually make the task very easier for project managers and the teams. I have found the best project management software after looking at its features and advantages to the users.

  29. Hello, the Blue bars doesn't got removed in my case. Can you please help.

  30. Thank you so much dear Svetlana for your simply explanation on Gantt Chart. I am very happy and pleased on your presentation which was received by me as a wonderful guideline. Thank again.

  31. great tutorial, thank you so much

  32. Very helpful. Thank you so much

  33. THANK YOU SO MUCH! VERY USEFUL!

  34. Super! Thank you very much !

  35. Great and very accurate!!! thank you so much!

  36. Am so grateful for this.
    A managed to make my grant chart for my reseach presentation.

  37. Hi, I explained very well. I love you so much

  38. Thank you

  39. Two thumbs up! Thanks!

  40. Excellent step-by-step instructions - thank you!

  41. Thanks for this post, very clear and helpful!

  42. Awesome step by step explanation.

  43. Amazingly straightforward. Really clear instructions and excellent use of visual aids/screenshots to assist the process.

  44. this is rubbish tutorial because it doesn't work and its making me really angry

  45. amazing and well explained!!!

  46. Dear Svetlana,
    I have no words to thank you for the above detailed draft illustration. Really, really thank you. I did my UNI Guntt Chart following your instruction and it was all accomplished within 30 minutes.

    Thanks you

    God bless

  47. I have an additional line for each Task that is for the Actual Duration and is directly under the estimated Task line. I'd like the colors on the gantt chart to be different for the Actual Duration but have no idea how to do this in excel. Please help!

    Current formulas:
    (GREEN) =AND($E8=K$6)
    % complete basically
    (BLUE) =AND(NOT(ISBLANK($E8)),$E8=K$6)
    % incomplete basically

    Column E is Start Date
    Column F is Completion Date
    Column K is the Start Date
    Column H is % Complete

    I think the equations would remain the same, but how do I ONLY have that formatting work for rows that are "Actual Duration"? And keep the original formatting for everything else?

  48. This was really helping!! Although i has some trouble with Step 5, number 2 and had too play around with some of the options.

  49. Thanks so much for the detailed step by step method of creating a Gantt chart. It was really helpful.

  50. Hi,
    Thanks for this useful, clear and helpful tutorial!
    I made a gantt chart and after few days I wanted to edit it and while clicking select data saw the message . Do you know the reason and way to fix it?
    Regards, Itzhak

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