How to Make a Timeline in Excel: 4 Easy Ways in 2026
To make a timeline in Excel, list your events and dates in two columns, then pick a method. The fastest is a SmartArt timeline from Insert > SmartArt. For dates on a true scale, build a scatter chart with data labels and error bars. You can also start from a timeline template, or let an AI tool build the timeline from your project file.
This guide walks through all four ways with the exact Excel menus. It also explains how a timeline differs from a Gantt chart and a PivotTable timeline, plus an example and common mistakes.
What a timeline in Excel is
A timeline shows events in the order they happen. Each event sits at a point in time, usually with a short label. Project milestones, product launches, company history, and audit dates all suit a timeline.
Microsoft describes the purpose in its timeline guide. It suggests a timeline for "a graphical representation of a sequence of events." Its examples are "the milestones in a project or the main events of a person's life."
Two related Excel features often get mixed up with it:
- A Gantt chart shows tasks as bars with a start and an end. It suits schedules where duration matters. Our guide on how to create a Gantt chart with AI covers that format.
- A PivotTable timeline is a date filter, not a chart. Microsoft calls it "a dynamic filter option that lets you easily filter by date/time." It does not draw events on a line.
This guide covers the first meaning: a visual line of events and dates.
Before you start: what you need
Gather these before you begin:
- A list of events. Keep each label short, ideally under six words.
- A date for each event. Use real Excel dates, not text such as "early March."
- Excel for Microsoft 365, 2021, or 2024. The menus below match current versions.
- A decision on scale. Decide whether the spacing between events must match real time.
Set up the data in two columns, with Date in column A and Event in column B. Sort it from earliest to latest. Clean data makes every method below faster.
Which way to choose
| Way | Best for | Dates to scale? | Time needed |
|---|---|---|---|
| Way 1: SmartArt timeline | A quick visual of 4 to 8 milestones | No | About 5 minutes |
| Way 2: Scatter chart | Milestones that must sit at their real dates | Yes | About 15 minutes |
| Way 3: Template | A polished look with little design work | Depends on the template | About 10 minutes |
| Way 4: AI | Timelines built from a project file or long report | Depends on the output | A few minutes, plus checking |
The key question is scale. If a gap of two months must look longer than a gap of two weeks, use Way 2. If readers only need the order, Way 1 is enough.
Way 1: Use a SmartArt timeline
SmartArt is the fastest way to make a timeline in Excel. Microsoft's timeline guide applies to Excel as well as PowerPoint and Word.
Microsoft's steps are short:
- On the Insert tab, select SmartArt.
- In the gallery, select Process, then double-click a timeline layout.
- Select [Text], then type or paste your dates and events.
Microsoft notes there are "two timeline SmartArt graphics: Basic timeline and Circle Accent Timeline." It adds that "you can also use almost any process-related SmartArt graphic."
To add events, select a shape and use Add Shape on the SmartArt Design tab. Choose Add Shape Before for an earlier date or Add Shape After for a later one. To reorder, use Move Up or Move Down.
You can also change the style. Microsoft says to select Change Colors on the SmartArt Design tab. A SmartArt style then "applies a combination of effects, such as line style, bevel, or 3-D perspective, in one click."
The limit is scale. SmartArt spaces shapes evenly, whatever the dates. Use it when order matters more than distance.
Way 2: Build a milestone timeline with a scatter chart
A scatter chart places each event at its real date. Microsoft explains why. A scatter chart "always has two value axes," so points can be "distributed evenly or unevenly across the horizontal axis, depending on the data."
Set up three columns: Date, Event, and Height. Height is a small number, such as 1, 2, or 3, that sets how high each label sits. Alternate the heights so labels do not overlap.
Then build the chart:
- Select the Date and Height columns.
- Select the Insert tab, then Insert Scatter (X, Y) or Bubble Chart, and pick the first scatter type.
- Add data labels. Microsoft says to select Add Chart Element next to the chart and choose Data Labels.
- Set the labels to show your event names. In the label options, choose Values From Cells and select the Event column.
- Add error bars to draw a line from each point down to the axis.
Microsoft confirms that error bars work in "xy (scatter)" charts. To add them, click the Chart Elements button and "check the Error Bars box." Choose More Options to set the direction and amount. A vertical minus bar of 100% drops each point to the axis.
Finish by hiding the vertical axis and the gridlines. Format the horizontal axis to show months or quarters.
Data labels stay current. Microsoft says "the data labels are linked to values on the worksheet, and they update automatically." Change a date in the sheet, and the point moves.
Way 3: Start from a timeline template
Templates give you a finished design to fill in. Microsoft's timeline guide links to its own timeline templates.
In Excel, select File > New and search for "timeline." Pick a template, then replace the sample dates and events with yours.
Check three things before you use a template:
- How it plots dates. Some templates space events evenly, like SmartArt. Others use a chart that respects the dates.
- Where the data lives. Good templates keep dates in a table, so you edit the table, not the drawing.
- How it prints. Wide timelines often need landscape orientation or a scaled print area.
A template saves design time, but it rarely fits a real project without edits. Plan to adjust labels, colors, and the date range. Templates help most when several teams must share one format.
Way 4: Make a timeline with AI
The three ways above work well when the dates are already in a clean list. They are slow when the dates sit inside a project plan, a status report, or a long PDF. An AI tool can pull out the milestones and lay them out for you.
Here is the method in three steps, using Powerdrill Bloom.
Step 1: Upload your project file
Start with the file that holds your dates. That might be a project tracker in Excel, a CSV export from a planning tool, or a PDF status report. The Free plan lists "Upload Excel, CSV, PDF, and docs."
Step 2: Ask for the timeline in natural language
Describe what you need. For example: "List the project milestones with dates, sorted by date. Then build a one-page recap with a timeline, status, and key decisions."
The AI One-Page Summary Generator lists a "Project recap one-pager with timeline, status and key decisions." It also offers "Project status, KPIs and next steps on a single printable sheet."
For a slide, the AI Proposal Generator lists a "Slide partnership pitch deck with mutual value and timeline."
Step 3: Check the dates and export
Check every date against the source file. A single wrong month changes the story of a timeline. The homepage says "Every number comes back with the page, the row and the figure behind it." That lets you trace each date to its row.
Then export. The one-page summary page says you can export a "print-ready PDF or PNG sized A4 / Letter." If you need the timeline in Excel too, copy the checked milestone list back into your sheet and use Way 1 or Way 2.
Formatting tips for a clear timeline
A timeline is read in seconds, so small design choices matter. These tips work with any of the four ways.
Mark today. Add a thin vertical line or a shape at today's date. Readers see at once which milestones are done and which are ahead.
Color by status. Use one color for completed events, another for upcoming ones, and a third for at-risk items. Keep the palette to three colors.
Label above and below. Alternate labels above and below the line. This doubles the space for text without shrinking the font.
Show the right time unit. Format the date axis to months for a one-year plan and to quarters for a multi-year plan. Daily ticks on a long timeline turn into noise.
Keep fonts large. Event labels should stay readable when the chart is pasted into a slide. Test it at the size it will be shown.
How to update and share a timeline in Excel
Most timelines change every few weeks. Build yours so updates take minutes.
Keep the data in a table. Select the Date and Event columns and format them as an Excel table. New rows then join the chart's source more easily.
Edit the sheet, not the drawing. In a scatter chart, data labels are linked to the worksheet. Change a date or an event name in the sheet, and the chart follows.
Copy it into PowerPoint. Microsoft notes that "You can create a chart in Excel, Word, and PowerPoint." A chart pasted into a slide keeps its look, and the data stays in an Excel sheet.
Print it on one page. Wide timelines often spill onto a second page. Set the page to landscape and fit the chart to one page wide before you print or save a PDF.
Date every version. Add an "Updated" note under the chart title. When a timeline in Excel travels by email, the date tells readers whether it is current.
A timeline in Excel example
Here is a short example for an invented project: the Q1 launch of a mobile app at Northwind Labs. All names and dates below are invented.
| Date | Event | Height |
|---|---|---|
| Jan 6, 2027 | Kickoff | 1 |
| Jan 20, 2027 | Design approved | 2 |
| Feb 17, 2027 | Beta release | 1 |
| Mar 3, 2027 | Security review | 3 |
| Mar 24, 2027 | Public launch | 2 |
With Way 1, the five events appear evenly spaced in a Basic timeline. That reads well in a kickoff deck.
With Way 2, the gap between Design approved and Beta release looks four weeks long. The gap between Beta release and Security review looks two weeks long. Readers see at a glance where the schedule is tight.
The Height column keeps the labels apart. Without it, "Security review" and "Public launch" would sit on the same line and overlap.
Common timeline mistakes
Dates stored as text. Excel cannot place "Q1" or "mid-March" on an axis. Use real dates, then format how they display.
Too many events. Twenty labels on one line become unreadable. Keep the main timeline to the milestones that matter, and move detail to a table.
Even spacing that misleads. SmartArt spaces events evenly. If readers will judge time gaps, use a scatter chart instead.
Overlapping labels. Labels on the same height collide. Alternate the heights or shorten the text.
Mixing a timeline and a schedule. If each task has a start and an end, a Gantt chart shows it better.
No source date. Timelines change. Add a small note such as "Updated March 1, 2027" so readers know how current it is.
For a related chart, see our guide on how to make a line graph. To present the timeline, our guide on how to make a project kickoff presentation covers the slides around it.
Want a first draft from your own plan? Try Powerdrill Bloom with one project tracker, and ask for the milestones sorted by date.
Frequently asked questions
How do I make a simple timeline in Excel?
List your events and dates in two columns. Then select Insert > SmartArt, choose Process, and double-click Basic Timeline. Type your dates and events into the shapes. Use Add Shape to add more events and Move Up or Move Down to reorder them.
How do I make a timeline in Excel with dates to scale?
Use a scatter chart. Put dates in one column and a small height value in another, then insert a scatter chart. Add data labels that show the event names and vertical error bars that drop each point to the axis. Hide the vertical axis to finish.
Does Excel have a timeline template?
Yes. In Excel, select File > New and search for "timeline" to see Microsoft's templates. Replace the sample dates and events with your own. Check whether the template spaces events evenly or by date before you rely on it.
What is the difference between a timeline and a Gantt chart in Excel?
A timeline shows events as points in time, such as milestones. A Gantt chart shows tasks as bars with a start and an end date, so it shows duration. Use a timeline for key dates and a Gantt chart for a working schedule.
What is a PivotTable timeline in Excel?
A PivotTable timeline is a date filter for a PivotTable, not a chart of events. You add it from Analyze > Insert Timeline, then slide across years, quarters, months, or days to filter the data. It does not draw milestones on a line.
Sources: Microsoft Support, Create a timeline · Microsoft Support, Present your data in a scatter chart or a line chart · Microsoft Support, Add or remove data labels in a chart · Microsoft Support, Add, change, or remove error bars in a chart · Microsoft Support, Create a PivotTable timeline to filter dates · Microsoft Support, Create a chart from start to finish. Details read on October 29, 2026.