Sale!

Gantt Chart Maker Excel Template

$20

Description

Gantt chart is the most common method used to visualize project schedules. The Gantt Chart Maker Excel template allows one to easily create Gantt charts instantly.

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

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

     

    Gantt Chart Maker - Excel Template - Daily/Weekly/Monthly/Yearly
    Gantt Chart Maker – Excel Template – Daily/Weekly/Monthly/Yearly

     

    Work Breakdown Structure (WBS) – Two Levels of Tasks

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

    Gantt Chart Maker - Excel Template - WBS
    Gantt Chart Maker – Excel Template – WBS

     

    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.

    1. Plan represents the plan schedule.
    2. Actual represents the Actual schedule.
    3. Actual vs Plan shows actual schedule in comparison against the plan schedule.
    4. Current Status shows the Actual schedule, but it shows the work completed as of today vs the future.

     

    Gantt Chart Maker - Excel Template - 4 Views Plan, Actual, Actual Vs Plan, Current Status
    Gantt Chart Maker – Excel Template – 4 Views Plan, Actual, Actual Vs Plan, Current Status

     

    Simple and Easy Data Entry

    Data entry is simplified to save time.

    1. Enter Task Name.
    2. Choose Task as Subtask if it is one.
    3. Assign the task to a resource
    4. Enter Planned Start date and duration. Plan End Date will be calculated by the template.
    5. For Actuals, enter change in duration if there is variance from plan.
    6. Enter Actual Start date only if there is variance from plan.
    Gantt Chart Maker - Excel Template - Data Entry
    Gantt Chart Maker – Excel Template – Data Entry

     

    Optional inputs are available to meet your additional needs.

    1. You can flag certain tasks as Milestones.
    2. You can track % Work complete
    3. A custom column is available to track additional information on each task.
    Gantt Chart Maker - Excel Template - Optional Data Input
    Gantt Chart Maker – Excel Template – Optional Data Input

     

    Holidays and Weekends are accounted for.

    Gantt Chart Maker - Excel Template - Holidays
    Gantt Chart Maker – Excel Template – Holidays

     

    Gantt Chart Maker - Excel Template - Weekends
    Gantt Chart Maker – Excel Template – Weekends

     

    % Complete

    There are two options here. You can use the % of Work Days Complete that is automatically calculated as ‘number of work days of actual work done as of today’ divided by ‘number of work days of actual work scheduled for the task’. Or you can choose to enter your own ‘% Work Complete’ in the input table (shown above).

    Gantt Chart Maker - Excel Template - % Complete
    Gantt Chart Maker – Excel Template – % Complete

     

    It will appear on the Gantt Chart with conditional formatting showing 0% complete as Red, 100% complete as Green and in between as Yellow. You can also decide to not to show any % Complete information by choosing blank in the drop down menu. It’s all about user control. 🙂

     

    Control tasks to display

    You can choose not to show certain tasks on the Gantt chart by entering Y in the ‘Remove from Display’ field in the Data entry sheet.

    Also, on the Gantt Chart itself, you have several options.

    Gantt Chart Maker – Excel Template – Filter Types
    Gantt Chart Maker – Excel Template – Filter Types

     

    Choose to view only Summary Level, only Milestones or all tasks. You can also easily filter to delayed tasks (Actual End Date > Plan End Date) and Incomplete tasks (Actual End Date > Today).

    In addition, choose a specific resource and only see the tasks assigned to that resource.

    Gantt Chart Maker - Excel Template - Resource Tasks
    Gantt Chart Maker – Excel Template – Resource Tasks

     

    Visualization

    You can assign each task a color. You can also assign each resource a color. 10 colors are available.

     

    Gantt Chart Maker - Excel Template - Colors
    Gantt Chart Maker – Excel Template – Colors

     

    On the Gantt Chart, you can choose to view default colors, task colors or resource colors. It’s all up to what view you would like to present for the specific purpose. Of course, you can switch back and forth as needed.

    Gantt Chart Maker - Excel Template - Colors
    Gantt Chart Maker – Excel Template – Color Choice

     

    Output

    The Gantt chart is set ready to print. If you would like to print only a portion, you can change the print settings in Excel as usual. You can also export to PDF and share.

    Gantt Chart Maker Excel Template - Gantt Chart
    Gantt Chart Maker Excel Template – Gantt Chart

  • Gantt Chart Maker - Excel Template - Gantt Chart
    Gantt Chart Maker – Excel Template – Gantt Chart
    • Gantt Chart Maker - Excel Template - Gantt Chart
      Gantt Chart Maker – Excel Template – Gantt Chart

      Gantt Chart Maker Excel Template Current Status
      Gantt Chart Maker Excel Template Current Status

    Extension

    52 periods and 40 tasks are displayed at a time. You can extend easily as needed. Calculation sheet (hidden) accounts for up to 100 tasks. This can be extended if needed.

    This is a regular Excel file with formulas and conditional formatting. No macros or programming. Hence, you can extend this as needed. The Gantt sheet is protected to avoid making unintentional edits. You can unprotect using indzara as password and make changes.

    Notes

    • Task duration is entered in days (not hours).
    • Predecessors are not automatically handled. User will input each task’s plan start date directly.
    • Automatic scheduling based on resource availability is not available. Please see Project Planner (Advanced) for that functionality.

     

Product Tour Video

FAQ

Product Support

Gantt Chart Maker (Excel) – Step by Step User Guide

How to implement predecessor tasks in Gantt Charts?

How to extend limits (tasks, time periods) in Gantt Chart Maker?

Reviews

1 2 3 4 5

You may also like…