Building a project timeline in Excel and keeping it current

The fastest route to a project timeline in Excel is a free template: Microsoft publishes timeline and Gantt templates, and so do several project software vendors. Download one, replace the sample tasks and dates, and you have something presentable in under an hour. The catch is that most templates are drawings, not models. When a date changes, someone has to redraw the chart by hand, and after a few weeks nobody does.

This article covers both halves of the job. First, how to pick a template that fits the kind of timeline you need. Second, how to build one yourself from a task table so that the chart redraws when a date changes, using the exact menu names in current Excel. The last part is about the routine that keeps it current, and the signs that a spreadsheet has stopped being the right place for it.

Two kinds of timeline, two kinds of template

Search results for "project timeline template excel" mix two quite different things, and choosing the wrong one creates work later.

	Milestone timeline	Gantt-style schedule
What it shows	Phases as blocks, key dates as markers along one line	One row per task, a bar per task across days or weeks
Typical size	5 to 20 items	20 to 200 rows
Audience	Clients, executives, steering meetings	The people doing the work
Updated	When a milestone moves	Every week
Usual Excel build	Scatter or line chart with labels, or shapes	Stacked bar chart, or conditional formatting on a date grid

If the timeline is for a slide, a milestone template is right, and the effort to keep it current is small because it changes rarely. If the timeline is how the team knows what happens next week, it is really a schedule, and the template matters less than whether the dates drive the chart.

A quick test for any template you download: change one start date in the table and see whether the bar moves. If it moves, the template is built on data. If it does not, the bars are shapes or manually filled cells, and every change will be manual from now on.

What Excel gives you, and what it does not

It helps to know the starting point. Microsoft's own support article on Gantt charts is direct about it:

Though Excel doesn't have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks. Source: support.microsoft.com

That article, checked on October 8, 2026, applies to Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016, on both Windows and Mac. So every timeline in Excel is one of two constructions: a chart that has been coaxed into looking like a timeline, or a grid of cells colored by formula. Both work. Both have limits worth knowing before you invest in one.

What Excel does provide that helps a lot:

• Date arithmetic. WORKDAY returns a date a given number of working days after a start date, skipping weekends and an optional list of holidays. NETWORKDAYS counts working days between two dates. These two functions turn a list of durations into real calendar dates.
• Tables. Converting the task list to an Excel table (Insert, then Table) means charts and formulas extend automatically when a row is added.
• Conditional formatting with formulas. A rule can color a cell when its column date falls inside a task's start and end dates, which is the basis of the grid-style timeline.
• Co-authoring. A workbook saved in OneDrive or SharePoint can be edited by several people at once in Excel for the web or the desktop app.

What it does not provide: dependencies that move later tasks automatically, a baseline to compare against, owner notifications when a date changes, or a history of who moved which date. Those can be approximated with formulas and comments, but each approximation is something one person has to maintain.

Building a timeline that redraws itself: step by step

The build below follows Microsoft's stacked bar method, with the formulas that make it update on its own.

1. Set up the task table. Use these columns, in this order: Task, Owner, Start, Duration (working days), End, Status. Select the range and use Insert, then Table, so new rows inherit the formulas.

2. Calculate the end date. In the End column, use a formula along the lines of =WORKDAY([@Start], [@Duration]-1, Holidays), where Holidays is a named range listing non-working days. Typing only start dates and durations, and letting End calculate, is what keeps the chart honest later.

3. Chain dependent tasks. If a task cannot start until the previous one ends, set its Start to =WORKDAY(E2, 1, Holidays) pointing at the predecessor's End. Change the first task's duration and every chained task moves. This is a manual dependency, but it is far better than retyping dates.

4. Add a helper column for the chart. Stacked bar charts need a duration in calendar days for the bar length. Add a column Bar Length with =[@End]-[@Start]+1.

5. Insert the chart. Select the Task, Start and Bar Length columns. Go to Insert, then Recommended Charts (or the bar chart menu), and choose Stacked Bar.

6. Hide the first series. Click the Start part of the bars. On the Format tab, choose Shape Fill, then No Fill. What remains looks like floating bars: a Gantt chart.

7. Fix the task order. Excel draws the first row at the bottom. Right-click the vertical axis, choose Format Axis, and under Axis position, select Categories in reverse order.

8. Tighten the date axis. Right-click the horizontal axis, choose Format Axis, and set the Minimum bound to the project start. Excel stores dates as serial numbers, so type the date into a spare cell, format it as a number, and use that value. Set the Major unit to 7 for weekly gridlines.

9. Add a today line (optional). Add a series with today's date (=TODAY()) plotted as a scatter point with error bars, or more simply, add a conditional format to the table that highlights any row where End is before today and Status is not "Done". The second option is easier to maintain and shows the same thing: what is late.

The alternative is the grid-style timeline. Put dates across row 1 starting in column H, tasks down the left, then select the grid and use Home, Conditional Formatting, New Rule, "Use a formula to determine which cells to format", with a formula such as =AND(H$1>=$C2, H$1<=$E2). It is easier to read at a glance and prints well, but it gets wide quickly: a six-month plan by day is around 130 working-day columns.

Keeping it current is the real job

Templates and formulas solve the first week. The weeks after are about habit. A timeline in Excel decays in a predictable way: the person who built it updates it diligently for two or three weeks, then a busy week arrives, then the dates are a fortnight stale, and the timeline quietly becomes a historical document.

A routine that small teams can actually keep:

• One owner, one day. Pick the person and the weekday. The update happens before the weekly meeting, not during it.
• Update status first, dates second. Mark what finished. Then change the start dates of anything that did not start as planned, and let the formulas move the rest.
• Keep a frozen baseline. At kickoff, copy the Start and End columns as values into two Baseline columns. Add a Variance column, =[@End]-[@Baseline End]. That one number answers "how late is it, and since when?" without debate.
• Log the reason. Add a Notes column for why a date moved. Three months later it is the only record.
• Archive, do not overwrite. Save a dated copy at each milestone. It costs nothing and settles arguments.

The weak point in all of this is that the update depends on information that lives elsewhere. Task status is in a chat thread, a decision is in an email, a delay was mentioned in a stand-up. The timeline owner spends the update collecting rather than updating. That collection step is what eventually stops.

Sharing without creating copies

Most timeline problems in Excel are really sharing problems. The usual pattern: the file is emailed to a client as an attachment, the client comments on their copy, someone saves "Timeline v4 final (2)" to a shared folder, and there are now three versions of the truth.

Practical rules that reduce this:

• Store the single live file in OneDrive or SharePoint and send a link, not an attachment.
• Give view-only links to people outside the team. Editing rights go to the people who update the timeline.
• For a client snapshot, export a PDF with the date in the file name. It is clear that it is a snapshot, and it cannot drift.
• Keep the comments in the file, using Excel's comment threads, rather than in email replies.

Co-authoring works well for a handful of editors. It works less well when many people need to update their own row: two people sorting or filtering the same table at the same time interferes with each other's view, and a formula overwritten by a typed value breaks the chain from that row down without any warning.

When a spreadsheet stops being the right place

A spreadsheet timeline is the right tool for longer than people expect. It stops being right when one of these becomes routine:

1. More than one or two people need to update dates every week. The single-owner routine no longer fits, and shared editing of formulas is fragile.
2. The team discusses tasks somewhere else. If every status update requires reading a chat to find out what happened, the timeline will lag.
3. There are several projects at once. Each in its own file means nobody can see the combined load on one person.
4. Someone needs a history. Who moved which date, when, and why is hard to reconstruct from a workbook.

At that point the choice is between a heavier spreadsheet (more tabs, more formulas, possibly a macro) or a tool built around tasks, where the timeline is a view of the same cards the team already updates. In the second kind of tool, a Gantt view is drawn from each card's start and due dates, dragging a bar changes the dates on the card, and a today line shows what is late without a formula. Some include a list view that turns a single typed line, such as a task name followed by a date, an @ owner and a # label, into a card with all of those set. Free tiers in this category typically cover a small team: one tool's free plan, checked on October 8, 2026, allows 5 people and 10 boards with Gantt, kanban, calendar and list boards included, and charges $5 per user a month (or $4 billed annually, excluding tax) from the sixth person. The trade-off is that a board tool does not do arbitrary formulas, and an Excel user will miss them for cost tracking.

A reasonable middle path is common: keep costs and formulas in Excel, and keep the schedule where the people doing the work already update their tasks. The pricing page and the comparison with Trello show what a board-based approach includes at each size.

What to change first

If the current timeline is a drawing, rebuild it from a task table with Start, Duration and a calculated End, so a changed date moves the chart. Freeze a baseline today and name one owner and one weekday for updates. If that owner is already chasing status across chat and email every week, try moving the schedule into a board tool such as Pinateca, where the timeline is drawn from the cards people already update.

Q1. Does Excel have a built-in project timeline or Gantt chart?

No predefined Gantt chart type exists in Excel. Microsoft's own guidance is to customize a stacked bar chart by hiding the start-date series, or to use one of its free templates. A grid colored with conditional formatting is the other common approach.

Q2. How do I make an Excel timeline skip weekends and holidays?

Calculate end dates with the WORKDAY function and pass it a named range of holiday dates. Enter only start dates and durations in working days, and let the formula produce the end date. NETWORKDAYS does the reverse and counts the working days between two dates.

Q3. Why does my timeline chart not update when I add a new task?

The chart is probably pointing at a fixed range. Convert the task list to an Excel table with Insert, then Table, and rebuild the chart from the table. New rows added at the bottom of a table are then included in the chart automatically.

Q4. How can I show which tasks are late on an Excel timeline?

Add a conditional formatting rule to the task table that highlights a row when its end date is before TODAY() and its status is not Done. This is easier to maintain than a today line drawn on the chart and shows the same information at a glance.

Q5. Can several people edit the same Excel timeline at once?

Yes, if the workbook is stored in OneDrive or SharePoint and opened in Excel for the web or a current desktop version. It works best with a few editors. When many people update rows at once, overwritten formulas and conflicting sorts become common.