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)

OTHER VIDEOS IN THIS SERIES:

THIS VIDEO:
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

GANTT CHART TEMPLATE PRO:
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:

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

FOLLOW VERTEX42 HERE:
Instagram:
Facebook:
Pinterest:
Twitter:

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

Nguồn: https://inst-wd.com/

Xem thêm bài viết khác: https://inst-wd.com/tong-hop/

46 COMMENTS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Please enter your comment!
Please enter your name here