Gantt Chart Maker – Google Sheet Template

Description
Features:

1. Applicable to projects of any size (that span across days, weeks, months or years)
2. Create two levels of Tasks (WBS – Summary tasks and subtasks)
     i. Summary Tasks’ dates are automatically calculated based on subtasks
3. Multiple views (Plan, Actual, Actual vs Plan or Current Status)
4. Simple and easy data entry
     i. Automatic End Date calculation
     ii. Exclude Holidays & Weekends as non-working days
     iii. Enter Actual dates only where there is variance
5. Option to use automatically calculated % of Work Days complete or user input
6. Control which tasks are displayed
     i. Filter to select tasks easily
     ii. Show only summary-level tasks or Milestones
     iii. Show tasks of one resource
     iv. Incomplete tasks and delayed tasks are automatically identified
7. Visualization
      i. Assign each task a color. Assign each resource a color.
     ii. 10 colors available (4 of them are theme based)
     iii. Milestone markers are automatically created
8. Output
     i. Ready to print. Or export as a PDF and share
9. Extension possibilities
     i. 52 periods (days/weeks/months/years) are shown at a time. Can be extended.
     ii. View 40 tasks at a time by default. Can be extended.

The Gantt Chart Maker Google Sheet template can be used for projects of all sizes. You can choose to view the Gantt chart by Daily / Weekly / Monthly / Yearly.

You can create two levels of tasks (Summary and Subtask) easily. By default, all tasks are summary tasks. Just choose ‘Subtask’ in the task type while entering. Start and End Dates are automatically calculated for summary tasks based on Subtasks. They are also shown in bold font.

Four different views
You can choose from 4 different views of the data. 
View 1) Plan, 2) Actual, 3) Compare Actual vs Plan or 4) Current Status.

With simple data entry, the Gantt chart is printable and ready to use.