Spreadsheet format
Each row represents an event on the timeline. The Timeline spreadsheet requires exact data labels. Add these to your spreadsheet's first row exactly as they are written on this table.
| Column | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Label | id | startdate | enddate | title | description | image | link | icon | importance | low_threshold | high_threshold | date_display |
| Data Type | plain text | plain text | plain text | plain text | plain text | plain text | plain text | plain text | number | number | number | plain text |
| Contents | A short, unique id for the event | Marks the start date for the event in plain text
| Marks the end date for the event in plain text | The label for the event. This will appear on the timeline. | Describes the event. This will pop up on the timeline when a user clicks the event's label. | An image URL. This adds an image link to the event. | A URL. This adds a link to the event's popup. | An image filename. This adds an icon next to the event's label on the timeline. | Represents the relative importance of the event. This determines the event's size and visibility on the timeline. | Determines the minimum zoom value at which the event is visible on the timeline. | Determines the maximum zoom value at which the event is visible on the timeline. | A variable that determines how a given day appears on the timeline. Note:
|
| Optional | x | x | x | x | x | x | x | x | x |
Customization Options
Source of events
- Go to "Data source url" in Common Options for Graphs
Title of timeline: sets the title that displays in the header of the timeline
- Enter a title
Description: describes the data represented in the timeline
- Type in a short description
- Note that, by default, the description is only visible when a user clicks the "info" link
- Set the "Show the description?" option to "true" to have the description automatically open when your timeline loads on a page
Center date of timeline: sets the initial center of the timeline
- Enter a date
- Note that this value can vary in specificity -- from years, to minutes and seconds
Initial zoom of timeline: sets the initial perspective of your timeline
- Type a number -- the lower the number, the shorter the timespan
- Guidelines for choosing a zoom number:
- 60: show 1,000 years of the timeline
- 55: show 350 years of the timeline
- 50: show 100 years of the timeline
- 45: show 35 years of the timeline
- 40: show 10 years of the timeline
- 35: show 3 years of the timeline
- 30: show 10 months of the timeline
- 25: show 3 months of the timeline
- 20: show 1 month of the timeline
- 15: show 10 days of the timeline
- 10: show 3 days of the timeline
- 5: show 8 hours of the timeline
Minimum zoom of timeline: controls the minimum zoom factor of the timeline
- Type in a number (1 - 100)
Maximum zoom of timeline: controls the maximum zoom factor of the timeline
- Type in a number (1 - 100)
Image lane height: controls the height of the images at the top of the timeline
- Type in a number
Maximum # of Popups: sets how many popups to keep open at one time
- Type in a number
- Note that after the maximum number is reached, the first opened popup will close
Show the footer?: Choose whether to show the date of an event and whether to have "previous" and "next" buttons at the bottom of the timeline
- True shows the footer
- False hides the footer
Show zoom bar?: choose whether the zoom bar is visible in the timeline
- True shows the zoom bar
- False hides the zoom bar