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

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

  2. Awesome step by step explanation.

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

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

  5. amazing and well explained!!!

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

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

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

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

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

  11. Excellent, thankyou.

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

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

  14. This was really helpful, thank you

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

  16. me too dude!

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

    Thanks,

    Bobby

  18. VERY WELL EXPLAINED

  19. Very very clear. Thank you

  20. Very impressive illustruation made it easier to follow.

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

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

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

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

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

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

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

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

  28. Thank you, It was explained well.

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

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

  31. Thank you so much for this Svetlana. Very easy to follow and perfect for what I need. Excellent work!!

  32. Thanks very nicely explained.

  33. Thank you for the excellent step-by-step instructions with example screen shots.
    With your instructions I was able to create a Gantt chart in my existing spreadsheet that provides an nice visual to target dates.

  34. Hi. what if you have several tasks to do in one day? how will you reflect that in your gantt chart in such a way that the time for each task follows each other without spilling into other days?

  35. Hi there
    I'm in the process of making a GANTT for a project I'm working on which has specific dates for events/meetings etc alongside tasks which may take between 1 week and 2 months to complete. Is there a way to incorporate these into a GANNT in addition to blocks of time?

  36. Svetlana,
    I cannot thank you enough for the Excel Gantt chart process and tips you provided. It certainly saved me a great deal of time tonight and my presentation is now ready to go! Your efforts are truly appreciated! Thank you very much.

    Regards,
    Lynn

  37. Thanks...very useful...

  38. this tutorial is great and setting up from scratch works way better than most available templates due to formatting.

  39. great explanation step by step in detail... thank you team.

  40. Let great thanks be posed to the developer and publisher of the tutorial. It has been extravagant helpful and self explanatory thus eases quick understanding.
    Thanks a lot

  41. Hi,
    This has been one of the best instructions I've found on the net for anything I needed. I needed to make a gantt chart quickly (in half an hour) and thanks to the instructions given here, I've succeeded.
    Thank you!

  42. I used your technique and have time on the horizontal axis, date on the vertical and am plotting duration. Is there a way to color code my bars according to the task they were doing for each specific duration of time?

  43. This is very helpful. but i need to also actual duration to be reflected on it. so that i can monitor through graph whether i am on or behind the schedule

  44. SvetlanaChka;
    Ochin Harasho, otlichno, Spazibo

  45. How to adjust the time line to Hours & Minutes scale instead of Days?
    This is needed for monitoring small projects with a number of tasks that run through 1 or 2 days.

  46. Thank you for your tutorial. this is extremely helpful. Does anyone know how to add the end date as the label of the bar?

  47. Hi @Svetlana Cheusheva - you are amazing thank you.

    Btw, I followed all your instructions and I am happy to say that i was been able to successfully replicate it. However, whenever I add a new task - it seems that the its not added in the chart and the formula for duration is not following :(
    I tried to drag hoping it will copy the formula but kinda weird that it is not copying.

    Please anyone help.

    Thank you

  48. How to swap task,either above or below one the other?

    your response will be highly appreciated.
    Thank you.

  49. lol there is a gantt chart template anyway now

  50. Thank you so much Svetlana,
    the explanation & its way is so good. I really learnt & I was so happy when the Gantt was building up in parallel to your steps.

    My only problem was that the date format was in numbers, I tried to format it to desired date format, it is not working hence the chart shows huge numbers, nevertheless, I will try again to fix it. Hopefully I can do it.

    thanks a ton for this knowledge
    Wish you Svetlana

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