Others

Show Planned vs. Actual Work on a Microsoft Project Timeline

Steve KSteve K Nov 22, 2026 868 views

Question details

The user wants to compare planned and actual task information on a Microsoft Project Timeline without displaying a Gantt chart.

Show Planned vs. Actual Work on a Microsoft Project Timeline
Product
Microsoft Project
Device & OS
not provided
Scenario
A project manager wants a timeline that communicates planned and actual work or milestone dates.
Observed behavior
The standard Timeline has fewer planned-versus-actual comparison options than Tracking Gantt and may not display a full baseline-versus-current bar comparison automatically.
Before you start

Identify the planned and actual dates you want to show, and check whether an earlier saved plan contains the original dates. If progress has already been recorded, setting a baseline now will capture the current plan, not automatically recover the original one.

Solution 1Recommended

Add planned and actual milestone markers to the Timeline

Use manually maintained milestones when you need a Timeline-only comparison of key dates.

The standard Timeline may not provide a full automatic baseline-versus-actual bar comparison. Separate milestone markers can show planned and actual dates, but they do not automatically track changes to the original tasks.

1
Create planned markers

In the task table, add a milestone for each key planned date. Give it a clear name such as “Planned completion” and enter the planned date.

2
Create actual markers

Add a separate milestone for each actual date that has occurred. Name it distinctly, such as “Actual completion,” and enter the actual date.

3
Add markers to the Timeline

Right-click each milestone and select Add to Timeline. Review the Timeline to compare the labeled dates.

4
Update markers as needed

When a new actual date becomes available, edit or add its milestone in the task table and add it to the Timeline if needed.

Add planned and actual milestone markers to the Timeline
Milestones show dates, not work bars: These markers compare selected points in time, not the full duration or amount of planned and actual work. Adding milestones changes the project task list.
Free Microsoft Office alternative

Share Project Timeline Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for reviewing and sharing exported project data. Move task dates into a spreadsheet for a simple planned-versus-actual summary; it does not replace Microsoft Project's baseline or Timeline features.

Organize planned and actual dates in a spreadsheet for a shareable comparison.Open and edit Microsoft Excel XLSX files exported from a project plan.Use a familiar spreadsheet interface to make migration easier.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Project show baseline and actual bars automatically on the standard Timeline?

The standard Timeline has limited comparison options and may not provide a full automatic baseline-versus-actual bar comparison. Use labeled milestone markers for key dates or View > Tracking Gantt for baseline and current schedule bars.

Can I set a baseline after recording progress?

Yes. Select Project > Set Baseline > Set Baseline, but the baseline will capture the plan as it stands now. It will not automatically recreate the original plan.

How do I add a task or milestone to the Timeline?

In the task table, right-click the task or milestone and select Add to Timeline. Use clear names to distinguish planned and actual markers.

Do manually added actual milestones update when task progress changes?

No. Separate reporting milestones are manually maintained. Edit their dates in the task table when actual information changes.

What can I do if I never saved a baseline?

Check an earlier saved version of the project for the original planned dates. You can use those dates to create planned Timeline markers, or set a baseline for the current plan using Project > Set Baseline.