Drawing of Stakeholder map
Project Management Meanings and Definitions
  • Concise, focused guide that cuts through the clutter
  • Step-by-step instructions for creating a project plan in under a day
  • Master essential skills like work breakdowns and task sequencing
  • Real-world troubleshooting for 20 common scheduling challenges
  • Rapidly get up to speed if you're new to Microsoft Project
  • Includes glossary, support resources, and sample plans
The cover of the book 'Essential Microsoft Project: The 20% You Need to Know'

Free Milestone Chart Template for Excel

Milestone chart illustration comparing baseline and forecast dates for build, testing and go-live.

Which dates have moved, and by how much? This Excel milestone chart puts your original plan beside your latest forecast, so a slipping deadline has nowhere to hide.

Use it in a project highlight report, a sponsor update or a delivery review. Enter five key milestones, update the dates and let the timeline show completed checkpoints, forecast delays and the reporting date.

Download the milestone chart

One editable Excel workbook with a timeline, input sheet and worked example. No macros or add-ins required.

Download milestone chart (.xlsx)

Five milestone rows · Baseline versus actual / forecast · Calendar-day variance

See the milestone chart

Excel milestone timeline. Select the preview to enlarge it.

Each row compares a milestone’s baseline date with its actual or forecast date. A connecting line makes the difference visible, while the label gives the date and variance. A positive value such as +7d means seven calendar days later than planned.

What is in the workbook
WorksheetWhat it does
TimelineShows the chart, reporting date and a summary of baseline dates, actual / forecast dates, variance and position.
MilestonesHolds the project name, reporting date, five milestone inputs, calculated results and supporting chart calculations.

The chart is an editable Excel chart. The date scale adjusts to the entered dates. It is useful for reporting key checkpoints; task durations, dependencies and the critical path belong in your detailed project schedule.

How to use the milestone chart template

Milestone input sheet. Select the preview to enlarge it.
  1. Set the project and reporting date. On Milestones, change the project name in B3 and the reporting date in B4. The example uses 22 May 2026. Enter your report date, or use =TODAY() for a date that updates when Excel recalculates.
  2. Replace the five examples. Edit the pale blue cells in A8:F12. Use milestone names that describe a result, such as “Design approved” or “Testing signed off”.
  3. Enter the baseline dates. Column B holds the approved plan. Keep these dates fixed so you can see changes against the original commitment.
  4. Update the forecast. Put your current expected completion date in column C. Leave column D, Actual, empty until the milestone is complete. Clear the sample actual dates when replacing the example.
  5. Set the latest agreed date and owner. Column E is the approved limit for that milestone; column F records who owns it. Set the latest agreed date equal to the baseline if there is no agreed tolerance.
  6. Record completion. Enter the actual completion date in column D. It takes precedence over the forecast, and a completed milestone turns green once the required dates are present.
  7. Review the Timeline sheet. Check any amber or red milestones and explain the cause, impact and next action in your report.

Keep the formulas in columns G to I and the supporting calculations below the instructions. This version is set up for five milestones; adding worksheet rows alone will not extend the chart.

What the milestone colours mean

Status rules used by this workbook
PositionRule
CompleteAn actual date has been entered. A late completion stays green, with its delay still visible in the variance.
On trackThe unfinished milestone’s forecast is on or before its baseline and latest agreed date, and is not before the reporting date.
AmberThe forecast is later than baseline, or is before the reporting date with no actual date recorded, but does not exceed the latest agreed date.
RedThe unfinished milestone’s forecast is later than its latest agreed date. This takes precedence over amber.
Missing dateA named milestone is missing its baseline, latest agreed date, or both its actual and forecast dates. Complete these inputs before interpreting the chart.

These are schedule rules, not an overall project health assessment. An on-time milestone can still face a quality issue, a funding problem or an unresolved decision.

Worked example: a launch moves by seven days

The example go-live milestone has a baseline of 30 June 2026, a forecast of 7 July 2026 and a latest agreed date of 7 July 2026. The chart shows +7d and an amber marker: the forecast has slipped, but remains within the agreed limit.

Move the forecast to 8 July and the milestone becomes red. Enter an actual date of 7 July once the launch is complete and it becomes green, while the seven-day variance remains visible.

Keep the baseline intact. Moving it every time the forecast slips would remove the comparison your report is meant to show.

Frequently asked questions

Can I use it for another project or year?

Yes. Replace the project name, report date and milestone dates. The timeline uses your entered dates rather than a fixed calendar year.

Can I add more than five milestones?

The supplied chart is configured for five rows. More milestones require changes to the chart series and supporting formulas. For a report, choose the five checkpoints that matter most; use a separate milestone list for the full detail.

Does the variance use working days?

No. It uses calendar days: actual date minus baseline, or forecast minus baseline where there is no actual date. Weekends and public holidays are included.

Why did changing a forecast not move the marker?

Check the Actual column first. If it contains a date, the chart uses that date instead of the forecast. Also check that you entered an Excel date rather than text and that workbook calculation is set to Automatic.

Can I put the chart in a highlight report?

Yes. Copy the chart from the Timeline sheet into your report. Pasting it as a picture keeps a fixed snapshot for that reporting period. Keep the Excel workbook as the editable source.

How do I save it as my own template?

In Excel, choose File > Save As and select Excel Template (.xltx). This preserves the chart, input cells and formulas together. To save just the chart design, right-click the chart border and choose Save as Template (.crtx). A chart template does not include the supporting worksheet calculations.

What is the difference between this and the milestone calendar?

This chart compares planned dates with actual or forecast dates to show slippage. The milestone calendar places checkpoints in monthly and yearly views so you can see what is coming up.

Which spreadsheet application should I use?

The workbook is designed for Microsoft Excel. Other spreadsheet applications may display the custom chart and labels differently. No macros are required.