Timeline charts

Use a timeline chart to show important events in chronological order. For example, show a list of project tasks and their deadlines.

Learn how to add & edit a chart.

How to format your data

  • First column: Enter the dates or dates and times you want to show in the chart.
  • Second column: Enter numeric data. You can also add a category name (optional).
  • Third and fourth column (Optional): Enter a note about the title.
  • Fourth column (Optional): Enter notes about each event.
  • Rows: Each row represents a point on the chart.


Date Expenses
1/1/2018 $300
2/1/2018 $320
3/1/2018 $200
4/1/2018 $215
5/1/2018 $245
6/1/2018 $400
7/1/2018 $390
8/1/2018 $300
Timeline chart showing expenses

Make a copy

Student attendance
Date Student attendance
7/1/2018 22
7/2/2018 23
7/3/2018 21
7/4/2018 24
7/5/2018 29
7/6/2018 28
7/7/2018 30
Timeline chart showing student attendance

Make a copy

Customize a timeline chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize and then Table.
  4. Change how the table looks, sort the table, or add pagination.
Was this helpful?
How can we improve it?
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu
Search Help Center