How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!)
David McLachlan David McLachlan
103K subscribers
1,221,204 views
0

 Published On Feb 28, 2022

⭐️⭐️⭐️ GET THIS TEMPLATE PLUS 52 MORE here: https://www.etsy.com/au/listing/11998...
👍 Ready made and ready to use.

How to make the absolute BEST weekly Gantt Chart in Excel, that looks like Microsoft Project and is easier and better to use! Your managers and team will ask you "Where did you get this from?" and "Can I use it?" because it looks so good when you're updating your project.

Features include: milestone diamonds, automatic Gantt chart bars, automatic counting number of working days, automatic percent complete on Gantt bars, coloured bars for complete tasks and for blocked tasks, and automatic calendar.

Timestamps:
00:00 Gantt Chart overview
01:53 Getting Started
02:31 Creating the Calendar
05:26 Adding lines and borders
06:40 Number of Working Days
07:24 Status drop down list
09:21 Adding milestone diamonds
10:27 Adding the Gantt bars
12:33 Adding the percentage complete on the bars
13:12 Adding the complete golden colour
14:03 Showing blocked items
15:12 Freeze panes for scrolling

#ProjectManagement

All the Project Template Excel and Powerpoint videos:    • How to Create Excel and PowerPoint Te...  

show more

Share/Embed