Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

As your project progresses, you can review how work on its tasks is affecting the overall project schedule.

What do you want to do?

Review schedule differences

As you track progress through your project, you can review the differences between planned, scheduled, and actual work. This helps you assess whether work on your project is progressing as expected. You can compare work amounts for tasks as a whole, or for resources and their individual assignments.

The easiest way to compare work amounts with your original plan is to apply the Work table to a sheet view, such as the Gantt Chart view or Resource Usage view. The value in the Work field represents the current scheduled work value, showing the total of actual and remaining work for tasks that have started, and showing the latest projected work value for tasks that have not yet started.

If you saved a baseline, then your original planned work amounts are stored in the Baseline field. With this field, you can compare work amounts in your original plan to currently scheduled work amounts. The Variance field shows the calculated variance between planned and scheduled work, that is, the difference between the Baseline and Work fields.

You can also review actual work amounts in the Actual fields. For completed tasks, the Work and Actual fields contain the same value.

Compare...

Description

How?

Current task work with your original plan

You can examine whether your tasks are using more or less work than planned by using the Gantt Chart with the Work table applied.

On the View tab, click Gantt Chart. In the Data group, click the arrow on Tables, and then click Work. Compare the values in the Work and Baseline fields.

To see the variance between the Work and Baseline fields, review the Variance field. For finished tasks, this variance represents the difference between actual and planned work. For tasks currently in progress, the Work field is the total of Actual Work and Remaining Work. For tasks not yet started, the Work field is the current projection, and is often the same as the Baseline.

The Variance field compares just the Work and Baseline fields; it does not compare other baseline fields (such as Baseline1, Baseline2, and so on).

Current task and assignment work with your original plan

You can examine whether tasks and their assigned resources are using more or less work than planned by using the Task Usage view with the Work table applied.

On the View tab, in the Task Views group, click Task Usage. On the View tab, in the Data group, click the arrow on Tables, and then click Work.

Review total work values in the sheet portion of the view. In addition to the Task Name field, the table shows the Work, Baseline, Variance, Actual, Remaining, and % W. Comp. (percent work complete) fields. The summary rows show the total work values for each task while the italicized entries show the individual work values for each assignment.

Review timephased values of work for each task and assignment in the timesheet portion of the view under each time period.

Current resource and assignment work with your original plan

You can examine whether resources and assignments are using more or less work than planned by using the Resource Usage view with the Work table applied.

On the View tab, click Resource Usage. On the View tab, in the Data group, click the arrow on Tables, and then click Work.

Review total work values in the sheet portion of the view. In addition to the Resource Name field, the table shows % Comp. (percent complete), Work, Overtime, Baseline, Variance, Actual, and Remaining fields. The summary rows show the total work values for each resource, while the italicized entries show the individual work values for each assignment.

Review timephased values of work for each resource and assignment in the timesheet portion of the view under each time period.

Note: Resource data is baselined at the project level. As a result, baselined resource data can vary widely depending on a number of factors. For example, you have a project with many tasks, and many resources allocated to those tasks. When you save a baseline, the resource allocation data is captured at the project level. If you add a task at a later time and configure the new task to roll up to the project level, the resource allocation baseline will not change.

Top of Page

View project work over time

By viewing work that is broken down by time period, you can see work within periods ranging from one minute to one year.

  1. On the View tab, in the Task Views group, click Task Usage, or in the Resource Views group, click Resource Usage.

  2. In the Zoom group, click the arrow under Timescale. In the list, select Timescale, and then click the Top Tier, Middle Tier, or Bottom Tier tab.

    Note: You can click one of the options in the Timescale list to set the bottom timescale tier.

  3. On the tab for the displayed timescale tier, in the Units box, click the time unit you want to use.

    For example, if you want to see work broken down by weeks and then by days, click Weeks in the Units box on the Top Tier tab, and then click Days in the Units box on the Middle Tier tab.

    Note: To show fewer than three timescales, under Timescale options select the timescales you want to appear in the Show list.

  4. To format the appearance of the timescale, enter the values you want to use in the Label, Align, and Count boxes. Select or clear the Use fiscal year and Tick lines check boxes, and then click OK.

  5. On the Format tab, in the Details group, select Work, ActualWork, Cumulative Work, Overallocation, Cost, or Remaining Availability.

Notes: 

  • To add or view more options, click Add Details. The Detail Styles dialog appears. On the Usage Details tab, in Available fields, select the fields that you want. Click Show. Conversely, to remove options, you can select fields in Show these fields, then click Hide to remove options. Use the Move arrows to change the order in which fields appear. Click OK.

  • You can also view the work associated with a selected task using a split view, sometimes known as a combination view. To create a split view, select the view that you want to appear on the top pane of the view, and then, on the View tab, in the Split View group select Details. In the list select the view that you want. The view in the bottom pane shows detailed information about the tasks or resources in the top pane view. For example, when you display any task view in the top pane and the Resource Usage view in the bottom pane, the view in the bottom pane shows the resources assigned to the tasks selected in the top pane, with information about those resources. The resource information shown pertains to all assigned tasks for each resource, not just to the tasks selected in the top pane.

Top of Page

Identify tasks that are behind schedule

If you have set a baseline for your project, you can see how tasks progress over time and see whether their start and finish dates are slipping. You can track progress by comparing baseline and scheduled or actual start and finish dates.

  1. On the View tab, click the arrow on Gantt Chart, then select Tracking Gantt.

  2. In the Data group click the arrow on Tables, and then select Variance.

    If the variance fields are not visible, adjust the view splitter or press TAB to move through the fields to display them.

The Tracking Gantt view displays two task bars, one on top of the other, for each task. The lower bar shows baseline start and finish dates, and the upper bar shows scheduled start and finish dates so that you can see the difference between your plan and the current schedule. In addition, on the Gantt Chart Tools Format tab you can click Baseline to display the chart baselines.

You can also see whether the start and finish dates for task assignments are slipping, using the Slipping Assignments filter. This filter shows resources that are assigned to tasks that are not yet complete and that have been delayed from the finish date of the baseline. To use this filter, you must have saved a baseline plan.

  1. On the View tab, click Resource Usage.

  2. In the Data group, in the Filter list, select More Filters.

  3. In the More Filters list, next to Filters, select Resource. In the list, click Slipping Assignments.

  4. If you want to show only those assignments that are slipping, click Apply. If you want to show all assignments with a colored highlight on the slipping assignments, click Highlight.

Top of Page

Find slack in my schedule

The amount of slack in your schedule tells you how much you can delay tasks before other tasks or the project end date is affected.

  1. On the View tab, in the Task Views group, click the arrow on Gantt Chart, select More Views.

  2. The More Views dialog appears. In the Views list, click Detail Gantt, and then click Apply.

  3. On the View tab, in the Data group, click the arrow on Tables, and then click Schedule.

    In the chart portion of the view, slack appears as thin bars to the right of tasks, with slack values adjoining the regular Gantt bars.

    Press TAB to move to the Free Slack and Total Slack fields if they are not visible in the sheet portion of the view.

    Notes: 

    • If you know where slack exists in your schedule, you can move tasks when certain phases of the schedule have no slack and other phases have too much.

    • Slack values may also indicate a schedule inconsistency. For example, a negative slack value occurs when one task has a finish-to-start dependency with a successor task, but the successor task has a Must Start On constraint that is earlier than the end of the first task. Negative slack can also occur when a task is scheduled to finish after its deadline date.

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×