Advanced Planning Analytics
  • Home
    • About Us >
      • Services
      • Contact Us
  • SME TRAINING
    • Engineering, Procurement, & Construction Planning [EPC]
    • Earned Value in P6
    • Advance Work Packaging
    • Schedule Analytics
    • EVM in P6 Online Course
  • ONLINE P6
  • ORACLE P6 TRAINING
    • P6 Fundamentals
    • P6 Advanced
    • Primavera Risk
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • APA Store
  • Engineering Deliverables in P6
  • Project Analytics APP
  • XER P6 Templates

excel gantt basic

I want to post a quick video on creating a Gantt Chart in Excel.  As an example, professionals , managers or project controls may not have access to a scheduling software.  However, their could be a need to create an executive Level 1 or Level 2 schedule.  This method allows for the Gantt to be somewhat dynamic for purposes of updating.

Step 1: Open Excel & Create a Table -in my example I copy & pasted from my P6 Schedule.  Download the Excel File from link below

Picture
Picture

Now follow my instructions on the video.

excel_gantt_template_24-oct-16_rev_draft.xlsx
File Size: 50 kb
File Type: xlsx
Download File

FREE Unlocked Excel Gantt VBA

In case you were not able to build the Gantt, I've added a downloadable example in Excel.

Picture
Privacy Policy

Terms of Use

Excel Gantt Tool
Copyright © 2019 - Advanced Planning Analytics,  All Rights Reserved
  • Home
    • About Us >
      • Services
      • Contact Us
  • SME TRAINING
    • Engineering, Procurement, & Construction Planning [EPC]
    • Earned Value in P6
    • Advance Work Packaging
    • Schedule Analytics
    • EVM in P6 Online Course
  • ONLINE P6
  • ORACLE P6 TRAINING
    • P6 Fundamentals
    • P6 Advanced
    • Primavera Risk
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • APA Store
  • Engineering Deliverables in P6
  • Project Analytics APP
  • XER P6 Templates