This is…

a Gantt Chart template designed for those who love to plan their work & life with no fuss. Visualizing your plan has never been this easy!

What It Has to Offer?

  • Gantt charts & task links (dependency lines) visualization
  • Color customization
  • Automatic highlighting for dependency issue
  • Tasks grouping
  • Daily & weekly views
  • Automatic highlighting for holiday
  • Up to 365 days of project duration

Get This Template Now!

You can get the trial version to test it out first.
👉Download Trial Version Here👈

Then purchase the full version from Etsy.
🎁Purchase from Etsy 🎁

How to Use This Template?

Prerequisites

  • Microsoft Office 365/2013/2016/2019 for Windows, or Microsoft Office 365 for Mac
  • Excel Macro: This workbook utilizes Excel macro – please refer to this link to see how to enable macro for Excel workbook.

Project Setup

1. Click at the Configs button.

2. Select/enter the values for the following configurations

  • Project Start : Start Date for your project (NOTE: The template supports for upto 365 days of project duration)
  • Weekend Mode : Select the most appropriate option the reflect the weekend days of your project.
  • Show Weekend : Choose whether to display weekend days in the project timeline area.
  • Show Summary on Gantt Chart : Choose whether to display summary (label) on the gantt chart.
  • Holidays (optional) : Enter the list of holidays for your project period. This information will be used for dates calculation as well as for the display in calendar area (i.e. holiday will be displayed in grey color).

3. Click Save Configs to apply the configurations and return to project view.

Adding/Editing a task

1. Double click at a cell below the Task column, an input form will appear on your screen.

2. Ensure that Task type is selected in the Type drop down, then type in the Summary.

3. Click at the Start Date button and use your mouse to select start date from project timeline. For your convenience, you can either the target date cell, or any cell under the same column – the corresponding date will be picked for you.

4. Either
(A) enter number for Net Workdays field, then the Finish Date will be automatically calculated; OR
(B) click the Finish Date button and select the finish date, then the Net Workdays will be automatically calculated

5. Optionally, you can choose to enter the % Commplete now or come back to update it later. Chart color can also be customized from the color options buttons on the bottom left corner.

6. Click Save to finish.

7. To edit a task, simply double click at the cell below the Task column which corresponds to the task you wish to edit.

Creating Dependency Link

1. Click at the gantt bar representing your predecessor in the Canvas area – the bar’s outline will become thicker.

2. Click at the gantt bar representing your dependent task the Link Type form will appear. Select the desired link type and click Save.

About Link Type:
FS (Finish-to-Start) - The dependent task cannot begin until its successor is completed.
SS (Start-to-Start) - The dependent task cannot begin until its successor begins.
FF (Finish-to-Finish) - The dependent task cannot be completed until its successor is completed.
SF (Start-to-Finish) - The dependent task cannot be completed until its successor begins.

3. To delete a dependency link, click at the dependency line twice and confirm the deletion.

4. If you mistakenly selected a gantt bar or a dependency line, and you want to deselect it, simply click at any cell.

Creating A Milestone

1. Double click at a cell below the Task column, an input form will appear on your screen.

2. Select the Milestone in the Type drop down, then proceed to enter its Summary, Start Date, then click Save.

Creating A Group

1. Double click at a cell below the Task column, an input form will appear on your screen.

2. Select the Group in the Type drop down, then proceed to enter its Summary, then click Save.

3. The tasks or milestones right under this Group item will be treated as group’s children.

4. To collapse or expand a group, double click at the corresponding triangle icon.

5. To collapse or expand all groups at once, double click at the white triangle icon at the top-left corner of the table.

Moving / Deleting / Inserting A Row

1. Click at an item cell under the Task column. You will see a set of action buttons shown on the right of the selected cell.

2. Click at the desired action i.e. Move up/down, Delete, Insert.

Note: If the selected item is a Group:
Move action will move the whole group.
– Delete action : You will be asked whether to delete the group’s children or not

Known Issue : Sometimes the action buttons do not appear – When this happens, please try zooming in/out of Excel worksheet, and then the buttons should appear.

Switching Views

  • To switch between Daily and Weekly views, click at the Weekly/Daily button.
  • To show or hide item details, click at the Toggle Details button.

Other Actions

  • Click at Select Today button to select the current date column in the project timeline
  • Click at Help to access this help page
  • To Reset the project sheet, click at Configs button and click at Reset Project. This will delete all the tasks/milestones/groups from the project sheet.