Guide

Planned vs actual Gantt chart: step by step with an example

A planned vs actual Gantt chart draws two bars for every task. One is the baseline, frozen on the day the plan was agreed. The other shows the dates the work started and finished. To compare them, save the baseline before work begins and record actual dates as tasks close. Then measure the gap at each finish and check which gap moved the project end.

What is the difference between planned and actual dates in a Gantt chart?

Planned dates are a promise and actual dates are a record. A live Gantt chart recalculates whenever something changes, so it only ever shows the current forecast. Once a task slips, the original promise disappears from view unless someone saved it separately. That saved copy is called the baseline.

The GAO Schedule Assessment Guide treats a baseline schedule, and tracking progress against it, as part of good scheduling practice. Without a baseline you can say when the project will finish. You cannot say how far it has drifted from what was promised.

How do you compare planned and actual dates in a Gantt chart in 6 steps?

  1. Finish the plan first. Give every task a duration, a person and the tasks it waits for, so the dates mean something.
  2. Freeze the baseline. Save a copy of every start and finish on the day the plan is agreed, before any work begins.
  3. Record actual dates as you go. When a task really starts or finishes, write that date down instead of overwriting the planned one.
  4. Draw both bars. Show the baseline as a thin or pale bar and the actual or forecast dates as a solid bar on the same row.
  5. Measure the finish variance. For each task, count the working days between the baseline finish and the actual or forecast finish.
  6. Trace which slip moved the end. Follow the waiting arrows from the last task backwards to find the delay that pushed the project finish.

What does a planned vs actual comparison look like in a worked example?

The table below is an example: a small website launch, used here as the baseline. The calendar is Monday to Friday with 6 hours of task work a day, so «1 day» means 6 hours of work. Each person does one task at a time. Work starts on Monday 9 November 2026 and the plan finishes on Thursday 19 November 2026.

TaskWhoDurationWaits forStartsFinishes
Finalise the copyLaura2 days—Mon 9 NovTue 10 Nov
Design the pagesMarc3 days—Mon 9 NovWed 11 Nov
Set up the domain and emailYou½ day—Mon 9 NovMon 9 Nov
Build the siteMarc4 daysFinalise the copy, Design the pagesThu 12 NovTue 17 Nov
Review with the clientYou1 dayBuild the siteWed 18 NovWed 18 Nov
Publish and checkMarc½ dayReview with the client, Set up the domain and emailThu 19 NovThu 19 Nov

Build the site waits for both the copy and the design. Design the pages finishes a day after the copy, so the design is what sets the build start. The copy has a day of room before it would push anything. The domain and email task has even more room: it only has to be done before Publish and check begins.

Now imagine three different things go wrong once work starts. The baseline stays the same in each case. Only the actual dates move.

What slipsVariance on that taskEffect on the project end
Finalise the copy takes one extra dayOne day lateNone: it still finishes with the design
Design the pages takes one extra dayOne day lateOne working day later, through build, review and publish
Domain and email takes two extra daysTwo days lateNone: publishing does not start until much later

The lesson of the example is that variance on a task and variance on the project are different numbers. A planned vs actual chart is only useful if you read both.

Which tasks should you watch first when actual dates drift from the plan?

Watch the tasks with no room first. These are the tasks whose finish feeds straight into the next task without any gap, all the way to the last task. A one-day slip there becomes a one-day slip on the project. A slip on a task with room is absorbed until the room runs out.

To find those tasks systematically, follow the method in the critical path guide. Then compare their baseline and actual finishes before anything else.

Which tools keep a baseline for a planned vs actual Gantt chart?

This comparison is as of 2 November 2026 and is based on the pages linked in each row.

ToolHow it keeps the planned datesWhat it does well
Microsoft Project desktopUp to 11 baselines per project, plus interim plans (Microsoft Support)Several saved versions to compare against
Microsoft PlannerBaselines in Planner Plan 3, one per plan (Microsoft Tech Community)Baseline inside a familiar Microsoft 365 tool
ExcelYou keep planned dates in your own columns (Excel Gantt guide)Total freedom of layout, nothing new to learn
tokiduPlan snapshot, one per project, in the Max plan, not on sale yetFree plan explains each forecast date with «Why that date?»

tokidu, the project manager by Sinergia Barcelona, is the product of the team that writes this article. In the Free plan, «Dates that work themselves out» calculates when each task should finish. The «Gantt» shows those forecast dates with arrows for what waits for what. «Why that date?» says what pushes a date: the task it waits for, what that person has first, or which days they do not work. The «Plan snapshot» saves what was promised and later shows how much each date has moved, but it belongs to the Max plan, which is not on sale yet. Project desktop and Planner do better here: they keep baselines you can use today, and Project keeps several of them. The Gantt and dates features are listed on the home page.

When should you re-baseline a planned vs actual Gantt chart?

Re-baseline only when the agreement itself changes. That could be new scope, a new deadline accepted by the client, or a task added or removed by decision. Do not re-baseline just because the project is late. Doing so erases the evidence of the delay and makes every later comparison meaningless.

If your tool can store more than one baseline, keep the old one and save the new one alongside it. If it stores only one, export or note the old dates before overwriting them. If you are still building your first chart, start with making a free online Gantt chart and freeze the baseline once everyone agrees on it. More guides like this are collected under Gantt and critical path articles.

Frequently asked questions

What is a baseline in a Gantt chart?

A baseline in a Gantt chart is a saved copy of every task's planned start and finish, taken when the plan is agreed. It never changes on its own, so later you can compare it with the actual or forecast dates and see exactly how far each task has drifted.

How do you show planned vs actual dates in an Excel Gantt chart?

An Excel Gantt chart is built from a stacked bar chart. For planned vs actual, keep planned start and duration in some columns and actual start and duration in others. Then plot them as two series, giving the baseline bar a paler colour so both appear on each task row.

Does a delayed task always delay the whole project?

A delayed task only delays the whole project if it has no room before the next task that waits for it. Tasks with slack absorb a slip until the slack runs out. Tasks on the longest chain of waiting work pass every day of delay straight to the end date.

How often should actual dates be updated in a Gantt chart?

Actual dates in a Gantt chart should be updated whenever a task really starts or finishes, or at least at a fixed weekly review. Updating late hides slips until they have already pushed other tasks. A regular rhythm keeps the planned vs actual comparison honest and useful.

Should you change the baseline when a project falls behind?

The baseline should not change just because a project falls behind, because that erases the record of the delay. Re-baseline only when the agreement changes, such as new scope or an accepted new deadline, and keep the earlier version if your tool allows it.

Sources

  1. GAO Schedule Assessment Guide: Best Practices for Project Schedulesgao.gov
  2. Create or update a baseline or an interim plan in Project desktopsupport.microsoft.com
  3. Announcing updates to the Baseline feature in Microsoft Plannertechcommunity.microsoft.com
  4. Present your data in a Gantt chart in Excelsupport.microsoft.com

Written with the help of AI from tokidu's real data and features, and checked automatically before publishing.

ShareXLinkedIn
← All news