Excel Tutorials · Lesson 101
A project timeline answers one question fast: what happens when. This lesson covers the three ways to build one in Excel, a milestone chart driven by real dates, a SmartArt process graphic for a summary slide, and a conditional formatting calendar grid that fills itself in, plus how to decide which of the three fits the plan you actually have.
The same free Excel Xpert companion workbook used in the video, one tab per lesson. No login, no email required.
A project timeline is a visual sequence of what happens when across the life of a project. At minimum it shows dates and the events attached to them, arranged left to right so the order and the spacing between events are both immediately readable. It is the thing you put in front of a client, a sponsor or a board when they need the shape of the plan rather than the detail of it.
That is the distinction from a Gantt chart. A Gantt chart shows durations, one bar per task, sized by how long the work takes and stacked so overlaps are visible. A timeline shows moments, points on a line marking when things happen. Gantt charts are for running the work; timelines are for communicating it. Many projects need both, built from the same underlying table of dates.
Excel offers three genuinely different ways to build one. A scatter-based milestone chart is data-driven and updates when your dates change, which makes it the right answer for anything that will be maintained. SmartArt gives you a polished graphic in about a minute, with the catch that it is drawn by hand and knows nothing about your data. And a conditional formatting calendar grid turns a range of cells into a colored timeline that fills in automatically from start and end dates.
Whichever route you take, the work starts in the same place: a clean table with one row per event, a date column that Excel recognizes as real dates, and a short label. Get that table right and all three methods become straightforward. Skip it, and every method turns into manual drawing.
Step-by-step, matching the video above.
Three columns: milestone name, date, and a height value. The height column controls how far above or below the line each label sits, use alternating values like 1, -1, 2, -2 so labels never collide.
Select the date column and the height column, then go to Insert > Charts > Scatter. You will get a spread of plain points along a date axis, which is the skeleton of the timeline.
With the chart selected, use Chart Design > Add Chart Element > Lines > Drop Lines. Each point now connects down to the timeline axis, turning scattered dots into anchored milestones.
Add data labels, then open the label options and choose Value From Cells, pointing at your milestone name column. Untick X Value and Y Value so only the names remain.
Set label positions to Above for points with positive heights and Below for negative ones, which produces the staggered look that keeps a crowded timeline readable.
Right-click the horizontal axis, set the Minimum and Maximum bounds to your project's start and end, and apply a short date format like mmm-yy so labels do not crowd.
Delete the vertical axis, the gridlines and the legend, none of them carry information here. Add a chart title and the timeline is finished.
| A: Milestone | B: Date | C: Height |
|---|---|---|
| Project kickoff | 2026-09-07 | 1 |
| Requirements signed off | 2026-09-25 | -1 |
| Design approved | 2026-10-09 | 2 |
| Build complete | 2026-11-06 | -2 |
| UAT sign-off | 2026-11-27 | 1 |
| Go live | 2026-12-04 | -1 |
The height column carries no real meaning, it exists purely to stagger the labels so six milestones inside three months do not overlap into an unreadable stack. Alternating positive and negative values with two different magnitudes gives four distinct label rows, which is usually enough for a timeline of this density.
Fastest to build, best looking, and completely disconnected from your data.
Go to Insert > SmartArt > Process and pick a layout. Basic Timeline, Circle Accent Timeline and Basic Chevron Process are the three that read most clearly as a project sequence.
Click the arrow on the left edge of the graphic to open the text pane, then type one line per phase. Press Enter for a new phase and Tab to add a sub-point beneath one.
The SmartArt Design tab offers color schemes and 3D styles that make it presentation-ready in seconds, and the whole graphic can be copied straight into PowerPoint without losing its editability.
SmartArt has no connection to your data and no sense of scale. Two phases a week apart look identical to two phases six months apart, and every date is typed by hand. Use it for a summary slide, never for a plan you will actually maintain.
The most maintainable option, and the one that scales to a long task list.
Put task names down column A, start dates in B and end dates in C, then fill row 1 across with consecutive dates or week-start dates using a simple =previous+7 formula dragged across.
Select the whole grid, choose Conditional Formatting > New Rule > Use a formula, and enter =AND(D$1>=$B2,D$1<=$C2). Set a fill color and every cell falling inside a task's date range colors itself.
The mixed references are the whole mechanism: D$1 locks the row so the rule always reads the date header, and $B2 locks the column so it always reads that row's dates. Get these wrong and the coloring appears in scattered nonsense.
A second rule using =D$1=TODAY() with a contrasting border highlights the current column, giving you the same at-a-glance status marker as a Gantt chart's today line.
Add a third rule with =WEEKDAY(D$1,2)>5 and a light gray fill so non-working days are visually distinct from the working week behind your task bars.
| Task | Start | End | Wk of Sep 7 | Wk of Sep 14 | Wk of Sep 21 |
|---|---|---|---|---|---|
| Discovery | 2026-09-07 | 2026-09-17 | █ | █ | |
| Design | 2026-09-15 | 2026-09-29 | █ | █ | |
| Build | 2026-09-28 | 2026-10-19 | █ |
Nothing is typed into the grid cells themselves. Every colored block comes from the single AND rule comparing the date in the header row against the start and end dates on that row. Change one end date and the shading redraws instantly, which is the advantage this method has over anything drawn by hand.
Three approaches, three clearly different jobs.
When the spacing between events carries meaning, and when the dates will change, the scatter method is the only one of the three that stays honest as the plan moves.
When you need five phases on a page for an executive audience and precise dates are not the point, SmartArt gets you there in a minute and looks better than anything you would build manually.
When there are twenty or more tasks and someone will be updating dates weekly, the conditional formatting grid handles the volume and maintains itself.
If the important information is how long each task takes and where work overlaps rather than when things happen, you want a Gantt chart instead, built from the same table of start dates and durations.
The difference between a timeline you rebuild and one you maintain.
Convert the milestone list with Ctrl+T before charting it. Charts built on an Excel Table pick up new rows automatically instead of ignoring them.
Where one phase follows another, calculate the start from the previous end with a formula. Then moving one date shifts everything downstream instead of requiring six manual edits.
Store the original planned dates in a separate column that never changes, so you can compare planned against current and see how far the schedule has drifted.
An IF or IFS comparing each end date against TODAY() can label rows Complete, In Progress or Upcoming, which then drives the color of the milestone or the grid cell.
Two of the three methods carry over, one is replaced by something better.
Google Sheets includes a built-in Timeline view under Insert > Timeline that reads a range with start dates, end dates and labels, then renders an interactive timeline with zoom and grouping. There is no Excel equivalent.
The AND formula rule and its mixed references behave identically in Sheets, so a calendar grid transfers between the two applications without changes.
Sheets has no SmartArt. For a presentation graphic, build the timeline in Google Slides using its diagram layouts, or use a drawing inserted into the sheet.
Imported or pasted dates often arrive as text that only looks like a date. Charts will plot them as evenly spaced categories rather than by real position, and conditional formatting rules will never fire.
SmartArt is drawn by hand and knows nothing about your data, so every date change is a manual edit and the spacing between events is meaningless. It belongs on a slide, not in a working plan.
Without staggered heights, every label sits at the same level and any two milestones close together overlap into an unreadable pile.
The mixed references are what make the calendar grid work. D$1 must lock the header row and $B2 must lock the date column, or the shading appears in scattered, meaningless places.
A timeline marks moments. Trying to show how long each phase lasts on top of that produces a cluttered hybrid, use a Gantt chart when duration is the point.
Excel picks its own minimum and maximum, which usually pads the chart with empty months on both sides and compresses the part you care about. Set the bounds explicitly.
A timeline shouldn’t go stale the day after you build it.
Free 14-day trial. No credit card required.
A timeline marks moments, showing what happens when as points along a date axis. A Gantt chart shows durations, one bar per task sized by how long the work takes and stacked to reveal overlaps.
Yes, several are available through File > New by searching for timeline or project, though building one from a milestone table gives you a chart that updates as your dates change.
Build a table of milestones, dates and staggered height values, insert a scatter chart from the date and height columns, add drop lines, then label the points using Value From Cells.
It staggers the labels vertically so milestones close together in time do not overlap. Alternating values like 1, -1, 2 and -2 give you four distinct label rows.
Go to Insert > SmartArt > Process, choose a timeline layout, and type one phase per line in the text pane. It is fast and polished, but entirely disconnected from your data.
Lay out task names with start and end dates, fill a header row with consecutive dates, then apply a formula rule of =AND(D$1>=$B2,D$1<=$C2) across the grid to color the cells inside each range.
Almost always the mixed references. D$1 must lock the header row and $B2 must lock the date column, and the rule must be entered relative to the top-left cell of the selected range.
Add a second conditional formatting rule using =D$1=TODAY() with a contrasting fill or border, which highlights the current column automatically each day.
Add a rule with the formula =WEEKDAY(D$1,2)>5 and a light gray fill, which colors Saturday and Sunday columns behind your task bars.
Convert the source data to an Excel Table with Ctrl+T so charts pick up new rows automatically, and derive dependent start dates from previous end dates with formulas rather than typing them.
Yes, keep a baseline column holding the original planned dates alongside the current ones, then plot both or compare them with a formula to show how far the schedule has drifted.
A milestone chart when spacing and dates matter, SmartArt for a summary slide with five or so phases, and a conditional formatting calendar grid for a working plan with many tasks.
Yes. Sheets has a built-in Timeline view under Insert > Timeline that reads start dates, end dates and labels, and the conditional formatting grid method works there identically.
The chart is treating your dates as text categories. Confirm the dates are real date values, and make sure you inserted a scatter chart rather than a line chart.
Every business starts with a spreadsheet. Updoot is where you scale past it, with timelines that move when the work moves.
Start Your Free Trial →