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: https://www.vertex42.com/ExcelTemplat...

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

THIS VIDEO
0:00 Introduction
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

OTHER VIDEOS IN THIS SERIES:
Check out the next videos to see how to work with workdays and weekends, how to change the display to weekly or monthly, and how to add dynamic color-coding:
https://www.vertex42.com/ExcelTips/ho...

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:
https://www.vertex42.com/ExcelTemplat...

GANTT CHART TEMPLATE
My original free Gantt chart template for Excel (and Google Sheets) can be found here:
https://www.vertex42.com/ExcelTemplat...

ANOTHER GREAT TUTORIAL
Check out the following channel for another detailed tutorial showing how to add advanced features to a Gantt Chart in Excel:
   • How to create Ultimate Excel Gantt Ch...  

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

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

NOTE: This video is for educational use and for use in making a Gantt chart for your own projects. Reproducing or copying this video in part or in whole for commercial gain (including advertising or making products for sale) is not permitted.