Each row represents a data point on the timeline. The chart below shows what data you should include in each column. Learn more about using spreadsheets with Visualizations at Use Spreadsheet Data.
Column 1 | Column 2 | Column 3 | Column 4 | |
---|---|---|---|---|
Data Type | date or datetime | number | text | number |
Contents | The date of your data point in a MM/DD/YEAR format. This sets the x-axis value for your data point. Note:
| The value for your date on the y-axis. This creates your first timeline. Note:
| The annotations for your data points. Note:
| A second value for your date on the y-axis. This creates a second timeline. |
Required | x | x | x |
Use this spreadsheet template to guide your data entry. To use it, just copy and paste the cells into your own Google sheet. You can click on a cell to get more information about a specific column, or reference the table above.
These options are exclusive to the annotated timeline. Learn about other options at Common Customization Options.
sets the transparency of the fill color under the graph's curve
formats the date that appears in the top right corner of the timeline
controls whether or not annotations appear on the chart
controls whether numeric values on the legend are exact or rounded
adds ornamental dots to the legend
shows a point's value on the legend when your cursor rolls over a point
adds a separator bar (|) between the legend and the date at the top right of the chart
adds shortcuts to different zoom levels within your timeline
determines which point will highlight based on the position of your cursor
controls the legends' placement