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:
| |
| Required | x | x | x | Optionalx | x | x x | x |
Customization Options
...
| Table of Contents |
|---|
...
|
...
|
...
|
...
|
Go to Common Customization Options for Charts and Graphs to see the rest of the optionsmore settings
Source of events
sets the data source
- Enter the link to your spreadsheet
- Learn more at Go to "Data source url" in Common Customization Options
Title of timeline
: sets the title that displays in the header of the above the timeline
- Enter a title
Description
: describes the data represented in the timeline
- Type in a short description
- Note that, by By default, the description is only visible when a user clicks the "info" link
- Set the "Show the description?" option to "true" True to have show 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 This value can vary in specificity -- from years, to minutes and seconds
Initial zoom of timeline
: sets the initial perspective of your timeline
- Type in a number -- the lower the number, the shorter the time spanGuidelines for choosing
- Use these guidelines to choose 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
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 After you open the maximum number is reachedof popups, the first opened popup will close
Show the footer?
displays : 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?
adds a : choose whether the zoom bar is visible in the timeline
- "True" shows the zoom bar
- "False" hides the zoom bar