...
At this point, you should pull up our Timeline guide for quick reference. This gives you the specifics for data formatting. In general, you'll use individual chart guides in our Visualization Index to find out about formatting.
Here, we're making a simple spreadsheet. Enter all required labels at on the top row of the spreadsheet. These are:
- title
- description
- startdate
- enddate
Make sure to copy the names exactly as they're written abovein the index.
Now, fill in your data for each cell. You'll see from the Timeline guide that each row represents an event on the timeline. We've entered four events in the example below. . This data was taken from the Thomas Jefferson Foundation's website.
Now that you’ve entered your data, it’s time to format it.
| Anchor | ||||
|---|---|---|---|---|
|
If If you pull up our Timeline reference guide, you'll see that the first row you filled out contains data labels. We need to “freeze” this row. This helps Audio-Video read the data you entered.
To freeze the first row, click View in the top menu, then Freeze. Choose 1 row. A grey line will appear under this row.
The Timeline reference guide also has specific data types for each column. Luckily, our example is easy: every column should be in the plain text data type.
To set the data type, select your column. Click Format from the menu, then Number. Choose Plain Text. Do this for each column.
Now your data is ready to go, and you can move to Audio-Video.
...