How to Make a Timeline in Excel (SmartArt or Real Dates)

There are two kinds of timeline you can make in Excel, and they suit different jobs. A SmartArt timeline is a quick, good-looking graphic for a presentation or a one-page plan, but every step is spaced evenly whatever the dates. A chart timeline places events at their real dates, so a gap of six months looks bigger than a gap of a week. Pick the one that matches what you need to show.

Which timeline should you make?

Type	Best for	Dates to scale?
SmartArt timeline	Project phases, launch plans, history of a business	No, steps are evenly spaced
Scatter chart timeline	Milestones where the gaps matter	Yes
Gantt-style bar chart	Tasks with start and end dates	Yes

How to make a SmartArt timeline in Excel

1. Go to the Insert tab and click SmartArt. You may need to open Illustrations first.
2. Choose Process on the left.
3. Pick Basic Timeline, or another process layout you like, and click OK.
4. Click each [Text] box and type a date and event, or open the Text Pane with the small arrow on the left edge and type there.
5. To add another point, select a shape, then on the SmartArt Design tab click Add Shape and choose Add Shape After or Add Shape Before.
6. Change colours and style from the SmartArt Design tab.

The Text Pane is the quickest way to work: type one event per line, press Enter for a new point, and Tab to indent a detail under the event above.

The catch with SmartArt timelines

SmartArt spaces every point evenly. A timeline running January, February, then December looks as though the events were a month apart each time. That's fine for showing order, but it can mislead anyone reading it as a schedule. If the gaps matter, say so in the labels, or use the chart method below.

How to make a timeline chart with real dates

1. Make three columns: Date, Event and Height.
2. In Height, enter small numbers like 1, 2, 3, then repeat. They only decide how high each label sits, so labels don't overlap.
3. Select the Date and Height columns and choose Insert, then a Scatter chart.
4. Click the chart, then the plus button, and add Error Bars. Format the vertical error bars to go down to the axis, which draws a line from each point.
5. Add Data Labels, then set them to show the value from cells and choose your Event column.
6. Delete the vertical axis and gridlines so only the date line and events remain.

This takes longer, but the spacing tells the truth: events cluster where the work was busy and spread out where it wasn't.

Changing the look of a SmartArt timeline

Once your events are in, select the graphic and open the SmartArt Design tab. Change Colors gives you ready-made colour sets, and the styles gallery adds depth or a flatter look. If Basic Timeline feels plain, switch the layout to another option in the Process group, such as one with circles or arrows, and your text moves across without retyping. You can also select a single shape and change its fill on the Format tab to pick out one milestone.

Tips for a clear timeline

• Keep each label short: a date and a few words.
• Use colour to group events, such as planning, launch and follow-up.
• Don't cram too many points in. Split a long history into phases.
• Put the most important milestone in a different colour so it stands out.

Ideas for timelines

• A product or course launch plan.
• The history of your business for an about page or pitch.
• A content calendar showing key campaign dates.
• A client project with phases and sign-off points.

Copying your timeline into a presentation or document

A SmartArt timeline copies cleanly into PowerPoint or Word, and it stays editable there, so you can tweak the wording without going back to Excel. A chart timeline can be pasted too, either linked to the workbook so it updates when the dates change, or as a picture if you want it fixed. For a timeline you'll update every week, keep it linked. For a one-off slide, paste it as a picture so it can't shift when the file is opened elsewhere.

Timelines that update themselves

If your timeline comes from a list of tasks or dates you change often, the chart method is the one to choose, because the chart reads straight from the cells. Change a date and the point moves. SmartArt is typed text, so every change has to be made by hand in the graphic. That's the real trade-off between the two: SmartArt looks polished in minutes, but a chart keeps itself accurate.

If you're planning content around your timeline, my guide to measuring social media success helps you decide which milestones to track.

My verdict

For a quick, tidy timeline, use Insert, SmartArt, Process, Basic Timeline, and type your events into the Text Pane. Just remember SmartArt spaces everything evenly, so it shows order, not time. When the gaps between dates matter, build a scatter chart with real dates instead, and it'll stay accurate as dates change. For presenting the result to clients, see dashboards for marketers.

Frequently asked questions

Does Excel have a timeline template?

Excel's SmartArt has timeline layouts under Insert, SmartArt, Process, such as Basic Timeline.

How do I add more events to a SmartArt timeline?

Select a shape, then use Add Shape on the SmartArt Design tab, or press Enter in the Text Pane.

Why are the gaps on my timeline the same size?

SmartArt spaces points evenly. Use a scatter chart for dates to scale.

Can a timeline in Excel update automatically?

A chart-based timeline does, because it reads from the cells. SmartArt doesn't.

Can I copy an Excel timeline into PowerPoint?

Yes. SmartArt stays editable, and charts can be pasted linked or as pictures.

What's the best timeline for a project with tasks?

A Gantt-style bar chart, which shows each task's start and end.