Excel Gantt Chart - How to #12 – Integration with Excel Features

You can include the formulas and functions of Excel in XLGantt.

1. Display project information using functions provided by XLGantt

You can add rows above the title and use the functions provided by XLGantt to display the project start date, etc. at the range you want.

Functions provided by XLGantt

xlgantt.ProjectName(): Get project name
xlgantt.ProjectStartDate(): Get project start date
xlgantt.ProjectFinishDate(): Get project finish date
xlgantt.ProjectPlanProgress(): Get planned progress of project(Planned %Work Complete)
xlgantt.ProejctActualProgress(): Get actual progress of project(%Work Complete)
xlgantt.ProjectProgressString(): Get project progress summary information
xlgantt.CommentOnHeadArea(): Get comment to display at the top of the Schedule sheet

2. Add columns and enter Excel formulas

You can add columns and enter formulas.

For example, you can easily track the progress of the project by adding the SPI column as follows.

*SPI(Schedule Performance Index): The Schedule Performance Index indicates how efficiently you are actually progressing compared to the planned project schedule.

[ Using XLGantt(Excel Gantt) ]