How to Make a Timeline Chart in Google Sheets

There are two things people mean when they say “timeline chart,” and Google Sheets handles them completely differently. Get this wrong and you’ll spend twenty minutes fighting the Chart editor to do something it was never built for. So before you touch a menu, decide which one you actually want.

The first kind is a timeline chart: a line that plots values against dates, with a zoom slider so you can scrub across time. Stock prices, website traffic, monthly revenue — anything measured repeatedly over a period. Google Sheets has a genuine native chart type for this, and it’s excellent. Use it.

The second kind is a milestone timeline: discrete events plotted as points along a horizontal axis. Product launch, contract signed, site went live. Sheets has no dedicated button for this, so you build it from a scatter chart. It’s more work, but it’s the right tool for events rather than trends.

This guide covers both. It does not cover Gantt charts — bars showing task durations across a schedule. If that’s what you’re after, gantt-chart.co.uk is built for exactly that and will save you the stacked-bar workaround.

Method 1: The native Timeline Chart (for trends over time)

This is the modern, correct method when your data is a series of values measured at different dates. It takes under a minute.

Structure your data first

Timeline charts are fussy about input, and almost every problem people hit comes down to badly formatted source data. You need two columns at minimum:

• Column A — dates. These must be recognised as real dates, not text. Type 12/01/2026 and if it right-aligns in the cell, Sheets has read it as a date. If it left-aligns, it’s text and your chart will refuse to plot it. Fix it with Format > Number > Date.
• Column B — values. The number you’re tracking on that date.

Add a header row (“Date,” “Revenue”) — the chart uses it to label your series. You can add more value columns to plot multiple lines on the same timeline; they’ll each get their own colour.

Insert the chart

Select your data range, then go to Insert > Chart. Sheets will guess a chart type, and it usually guesses wrong — a plain line or column chart. That’s fine, you’re about to override it.

In the Chart editor panel on the right, open the Chart type dropdown under the Setup tab and scroll down to the Timeline section. Pick Timeline chart.

What you get looks different from an ordinary line chart in one important way: across the top sit period buttons — 1d, 5d, 1m, 6m, 1y, and max — and below the plot is a range slider with draggable handles. Drag those handles to zoom into a slice of the data. This interactivity is the whole point of the chart type and the reason it beats a static line chart for anything spanning a long period.

Clean it up

A couple of quick customisations under the Customize tab make it presentable:

• Fill area turns the space under the line into a soft colour wash — good for single-series revenue or traffic charts.
• Line thickness — bump it to 2px or 3px so the line reads clearly once the chart is small.

That’s the entire native method. If your data is dates-and-values, you’re done.

Method 2: The milestone timeline (for discrete events)

Now the other kind. You’ve got a handful of key dates — not a continuous measurement, just moments — and you want them marked along a line. The native Timeline chart won’t do this well, so you build a milestone timeline from a scatter chart.

Set up three columns

• Column A — Milestone name (“Kickoff,” “Beta launch,” “Public release”). Keep these short; long labels overlap.
• Column B — Date (formatted as a real date, same rule as before).
• Column C — Position. A number that pushes each label above or below the line so they don’t collide. Alternate values like 1, -1, 2, -2 down the column. This is the trick that makes the chart legible.

Build the scatter chart

Select columns B and C (the date and the position), then Insert > Chart and choose Scatter chart from the Chart type dropdown. You’ll get dots floating at different heights across a date axis.

To attach the milestone names, go to the Customize tab, open the Series section, and add Data labels — then set them to pull from your milestone-name column. Each dot now carries its event name at the height you set in column C.

Finish by setting the vertical axis to hide its gridlines and numbers (they’re meaningless here — the position values were just spacing), and you have a clean event timeline. It’s fiddlier than the native chart, but for launch plans and project milestones it communicates far better than a line ever could.

If you’d rather not rebuild this from scratch every time, our milestone timeline chart template has the position column and label logic already wired up — copy it to your Drive and swap in your dates.

A word on the “Insert > Timeline” feature (it’s not a chart)

Here’s a genuine trap. Recent versions of Sheets have a menu item at Insert > Timeline that opens a “timeline view.” It sounds like exactly what you want. It isn’t a chart.

The timeline view is a project-planning surface — it reads a table with card titles, start dates and end dates and renders horizontal duration bars you can scroll through. It’s essentially a lightweight Gantt view, and it lives in its own tab rather than sitting inside your sheet as an embeddable object. If you’re tracking task durations across a schedule, it’s useful. But it’s a different feature with a confusingly similar name, and you can’t drop it into a Google Doc or Slide the way you can a real chart. When this guide says “timeline chart,” it means the chart types in Methods 1 and 2 — not this view.

Which timeline should you actually use?

Quick decision, because people overthink it:

• Continuous data measured over dates (revenue, traffic, prices) → native Timeline chart, Method 1. No question.
• A set of key events or dates (launches, milestones, phases starting) → milestone scatter timeline, Method 2.
• Task durations you need to schedule and track → not a chart at all. Use the Insert > Timeline view, or a proper Gantt tool.

If you’re still unsure whether a timeline is even the right shape for your data, our guide on which chart you should use walks through the decision by data type.

FAQ

Why isn’t my Timeline chart plotting the dates correctly? Almost always because the date column is stored as text, not dates. Select the column, go to Format > Number > Date, and re-check. Dates that right-align in the cell are real; left-aligned ones are text and won’t plot.

Can I show more than one line on a Timeline chart? Yes. Add extra value columns next to your date column and include them in the selection. Each becomes its own coloured line, and the zoom slider controls all of them together.

How do I add a timeline chart to Google Slides or Docs? Build it in Sheets first, then in your Doc or Slide go to Insert > Chart > From Sheets and pick it. It stays linked, so updating the sheet updates the embedded chart with one click.

Does the milestone method work for a project schedule with durations? No — the milestone method plots single points, not spans. For start-to-end task bars you want the Insert > Timeline view or a dedicated Gantt tool rather than a scatter chart.

Is there a ready-made timeline template I can copy? Yes. See our Google Sheets chart templates collection for copy-to-Drive files, including timeline layouts you can populate with your own dates.