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