In Excel Gantt, you can use actual start and finish dates. So You can identify the schedule is delayed or ahead by entering the actual start and finish dates.
1. Schedule change management setting
Click the "Options" button on the ribbon menu > XLGantt tab to choose schedule option.
If you choose "Managing Schedule Changes", the following fields are displayed: Actual Start Date, Actual Finish Date, and Actual Total Work.
2. How to enter the changed schedule
There are three ways to enter the changed schedule.
1) When the task is completed and you enter the actual start date and actual finish date.
- If you enter the actual start date and the actual finish date directly, the %Work Complete is automatically entered as 100%.
- If the planned schedule differs from the actual schedule, the background color of the date is displayed in yellow and the Gantt chart displays the actual schedule in blue lines.
2) If a task is completed as planned
If a task is completed on the same schedule as the planned schedule, you can enter 100% of the %Work Complete only. If you do not enter the actual start date and actual finish date, they will be filled with the same date as the planned start date and finish date.
3) If a task is not completed yet
If a task is not completed, enter only the actual start date and the %Work complete. If you enter the actual finish date, the task is considered completed, so you only need to enter the actual start date.
[ Using XLGantt(Excel Gantt) ]
- Excel Gantt Chart - How to #15 – Setting WBS Area and Color Theme
- Excel Gantt Chart - How to #14 – Workload calculation
- Excel Gantt Chart - How to #13 – Importing Server Data
- Excel Gantt Chart - How to #12 – Integration with Excel Features
- Excel Gantt Chart - How to #11 – Calendar
- Excel Gantt Chart - How to #10 – Importing Schedules
- Excel Gantt Chart - How to #9 - Multilingual Support
- Excel Gantt Chart - How to #8 - Adding Tasks to Microsoft Outlook Calendar
- Excel Gantt Chart - How to #7 – Deliverables
- Excel Gantt Chart - How to #6 – Managing Schedule Change
- Excel Gantt Chart - How to #5 – Analysis Report
- Excel Gantt Chart - How to #4 – Keeping track the progress of the project
- Excel Gantt Chart - How to #3 - Setting Gantt chart display styles
- Excel Gantt Chart - How to #2 - Enter tasks, Update schedule
- Excel Gantt Chart - How to #1 - Getting Started With XLGantt
