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 |
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 |
Customize a timeline chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize
Table.
- Change how the table looks, sort the table, or add pagination.
Table.