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.

Examples

Expenses
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 Timeline.
  4. Change how the chart looks, set min and max values, and more.

Related articles

Was this helpful?
How can we improve it?