How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!)

Channel Avatar
Comment
X
Share
How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!)
How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!)
️️️ GET THIS TEMPLATE PLUS 52 MORE here: https://www.etsy.com/au/listing/1199800561/50-project-management-templates-in-excel
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: https://www.youtube.com/playlist?listPLEWFSKHjyrwydP0YBztsIdu47Csvp5KXf

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

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