How to Make a Gantt Chart in Excel

Learn how to Make a Gantt Chart in Excel, including features like a scrolling timeline and the ability to show the progress of each task. Watch as I create the Simple Gantt Chart template from scratch, or download the template:

👍 Remember to Subscribe and Turn on Notifications (click on the bell)


0:20 Step 1 – Start with a List of Tasks and Dates
0:44 Step 2 – Set up the Timeline Labels
2:20 Step 3 – Add Initial Formatting to Style the Gantt Chart
4:05 Step 4 – Add the Bars of the Gantt Chart via Conditional Formatting
5:10 Step 5 – Make the Timeline more Dynamic
6:28 Step 6 – Add a Scroll Bar Form Control
7:20 Step 7 – Highlight Today’s Date using Conditional Formatting
7:51 Step 8 – Add Columns for ‘Assigned To’ and Progress (% Complete)
9:07 Step 9 – Show Progress in the Gantt Chart by Shading a Portion of the Bars
11:31 Step 10 – Define Print Settings

A Gantt Chart is an extremely useful tool for project management. You can create a very simple project plan like the one in this tutorial, but if you are a project manager and want more features such as changing the view between daily/weekly/monthly, entering the duration of a task in work days, or color-coding the bars of the chart, download Gantt Chart Template Pro:

My original free gantt chart template for Excel (and Google Sheets) can be found here:


MUSIC: A Good Mood, by Young Rich Pixies, licensed via ArtList


Xem thêm bài viết khác:


  1. Do you offer any more formal training for excel or do you just have your YT tutorials? You’re truly a wizard at Excel!!

  2. @Vertex42 thank you very much for the video… It was really helpful! Does anyone know if there is any way that you can make the stuff written under the TASK column to be changing as the date changes? If so, what is the formula that can be used for that? Thanks!

  3. This is a wonderful tutorial. Thank you so much for saving my day!!!

  4. Did I use the same.Excel with you? What a great job!

  5. Brilliant.. This is the video which actually shows me the power of excel and what we can do in it. thanks alot

  6. Mastering of Excel in 12 minutes….. awesome

  7. hi..thanks for that it was really helpfull..however i have one question….when i set "display week to 25" i want to show 25 th week of the year and not the 25th week of my timeline…how do i do this? thank you

  8. Will this chart still work if I add in line items e.g. task 2.1.1?

  9. Is it possible to add dependent tasks?? Thank you very much for your help!!

  10. The most productive and concise YouTube I've ever watched. I followed the project through from beginning to end and produced the Gantt chart that I needed in my current work. It took me two hours of carefully following every step, but the results speak for themselves.

  11. Or you can just use the Excel template. Job done.

  12. u are simply awesome!!!

  13. learn so much! thank you sir…

  14. Not gonna lie…this was actually really fun.

  15. Terrific presentation. I was wasting time and becoming increasingly frustrated fooling around with charts and should've been using conditional formatting all along! Thank you!

  16. i stopped at this point
    =AND(E$5>=$B7, E$5<=$C7)

    when i apply the above rule exactly like the video it doesn't show the chart or anything

  17. My programme is spanning years rather than weeks. Is there a way I can get the date header to simply show Monday and years? Rather than specific days?

  18. Hi i cannot get the last part for the progress. I keep getting errors I have done this chart 4 times and the same error keeps happening. I could use some help

  19. Excelente video, gracias por el aporte. Saludos.

  20. You did it great. Can you add a section in the tutorial on how to split duration of a single activity? Thanks so much.

  21. Great video! But does anyone know how to change the 'Display Week' field so that it actually displays the calendar week? At the moment the calendar week and 'Display Week' (which you could call the "Project Week"), don't match another so it is very difficult to navigate the file when you are working from dates. Thanks!

  22. Excellent tutorial. I was having a heck of a time trying to figure out displaying the progress in percentages. Big help. Thank You!

  23. Absolutely amazing video this is the best tutorial video I've ever seen!!! Thank you!!

  24. This video just changed my life

  25. I considered myself an above-average Excel user, but boy, was I humbled.
    Thank you so much for sharing this!

  26. Thank you very much for such an elaborate video. Cant wait to try it!

  27. This is how you should make a tutorial. Simple and to the point. This video is a template for all the online videos on how to make perfect videos.

  28. Great job! One of the best Gantt chart tutorial for Excel. Thank you so much!|

  29. I want to know how to manage inventory in excel.
    For construction projects, we use bill of quantity for estimating the cost.
    During the project, the data need to be updated to measure the progress. For example, compression between estimates and actual budget.
    Not only that but S-curve can help understanding to situation very well.
    It’s quite complicated. An expertise in excel can ease out this problems.
    Thank you.

  30. Loved this video and all the new information. Wondering if you have any tips for managing a portfolio of projects by month?

  31. Fantastic video on using Excel to manage a project.., brilliant stuff and thank you.

  32. Microsoft should reward you. Excellent video on Gantt chart.

  33. Good video how to…. Thanks

  34. Most helpful video. This was a super awesome experience of learning and doing stuff. Greatly Appreciated

  35. Awesome! Very detailed. Could you please let us know how to add planned % vs Actual percentage for a given task. For example, Task 1.1 started 4/11 and end on 11/7. That means, planned percentages as 30 %, 30% and 40% for these start and end date. And the actual % progress given as 20%, 30% and 30%..(assuming). How to represent these planned vs actual on the chart for each and every task.

  36. Brilliant work… Thanks for this tutorial 👍

  37. This is way cool. Thanks for sharing.

  38. Hi @Vertex Amazing Job!!!! thanks… I have a questions: how can I put a limit of weeks? in order to limit the number of week at the scroll bar? Greetings

Leave a Reply

Your email address will not be published. Required fields are marked *