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

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

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

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

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

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

  6. Explained extremely well!!

  7. well explained

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

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

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

  11. great tutorial, thank you so much

  12. Very helpful. Thank you so much

  13. THANK YOU SO MUCH! VERY USEFUL!

  14. Super! Thank you very much !

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

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

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

  18. Thank you

  19. Two thumbs up! Thanks!

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

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

  22. Awesome step by step explanation.

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

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

  25. amazing and well explained!!!

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

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

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

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

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

  31. Excellent, thankyou.

  32. Thank you so much
    تشکر و سپاس

  33. Thanks for step by step instructions. Really enjoyed this.

  34. This was really helpful, thank you

  35. So helpful
    I got it all
    Thank you so much

  36. me too dude!

  37. This is a fantastic tutorial, and such a help to those without access to MS Project. Great job!

    Thanks,

    Bobby

  38. VERY WELL EXPLAINED

  39. Very very clear. Thank you

  40. Very impressive illustruation made it easier to follow.

    Really helped me to finish a Gantt chart under an hour.

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

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

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

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

  45. 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! :)

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

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

  48. Thank you, It was explained well.

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

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

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