Gantt Chart Maker – Google Sheet Template
Originally published: 12/12/2022 15:41
Publication number: ELQ-91589-1
View all versions & Certificate
certified

Gantt Chart Maker – Google Sheet Template

Gantt chart is the most common method used to visualize projects. This Google Sheet template allows one to easily create Gantt charts instantly.

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.

This Best Practice includes
1 PDF File with link to download your copy of the Google Sheet Template

Acquire business license for $20.00

Add to cart

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...