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

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

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 Table.
4. Change how the table looks, sort the table, or add pagination.

Related articles

• Types of charts & graphs in Google Sheets
• Add & edit a chart or graph