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/ExcelTemplates/simple-gantt-chart.html 👍 Remember to Subscribe and Turn on Notifications (click on the bell) 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 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/ExcelTemplates/simple-gantt-chart.html 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/ExcelTemplates/simple-gantt-chart.html GANTT CHART TEMPLATE My original free Gantt chart template for Excel (and Google Sheets) can be found here: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html ANOTHER GREAT TUTORIAL Check out the following channel for another detailed tutorial showing how to add advanced features to a Gantt Chart in Excel: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html FOLLOW VERTEX42 HERE: Instagram: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html Facebook: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html Pinterest: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html Twitter: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html 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.

gantt chart

make a gantt chart

create a gantt chart

gantt chart in excel

excel gantt

excel gantt chart

excel tutorial

project schedule

project plan

project scheduling

project planning

project management


gantt chart tutorial

gantt chart excel

gant chart

project manager

excel gantt chart tutorial

gantt chart for project management

gantt chart excel template