Overview

 

Data Sheet

1
There is First Column in "Data
Sheet" name "Options"
by selecting any cell you can add and delete rows.

1.1
You can add Project, MileStone and Task for the project.

1.2
Days Required will be calculated automatically.

1.3
You can add any date by double clicking on activecell for the
date columns.

1.4
After updating the "Data Sheet" you have to press the "back to
Gantt Chart" option to update "Gantt Chart".

Gantt

2
There is button in the "Gantt" which only
"Filters the Projects".

2.1
There are other three button which shows the view of
"Gantt Chart" for "Days", "Weeks" and
"Months" separatly.

2.2
There is "ComboBox" which filter the each
"Task" Separatly.

2.3
You can scroll the Gantt Chart right to left using scroll
buttons.

2.4
The Last Column of Gantt Chart Header has "Data
Validation" to update different "Columns Data" from "Data
Sheet"

Calculations

3
In "Calculation" Tab you can modify any value
according to your needs but do not change the header name.

Youtube Video: https://www.youtube.com/watch?v=n7Rxl0tkKBI

Tags
Reviews Add a review
No reviews yet

More From Hafiz Ali

Browse our top rated business templates. See All
Dynamic Gantt Chart Excel
1,316
0
  Data Sheet 1 There is First Column in "Data Sheet" name "Options" by selecting any cell you can add…
Monthly Payroll Template
1,572
0
It is a payroll document in which you can record payroll data for multiple employees along with a automated Salary…
Recruitment Template (HR)
1,665
0
 1. Information:  I have created this template to help you conduct a follow-up in the employee recruitment process. - Know…
Bitcoin Excel Spreadsheet Template
1,665
0
ConfigDefine your starting date and the initial equity that will be invested. On a second tab, list all cryptocurrencies that…
Learning and Development Planning
1,742
0
NOTE: After downloading the Template please upload it into Google Sheets without making any changes (If you face any problem…
Resource Planning Template
1,805
84
Resource Planning TemplateResource Bandwidth HeatMap  
See All