Because everyone approaches data entry differently, the columns in the Timeline Data tab can be customized to suit your needs.
Note: Changes made to Timeline Data tab will be reflected in the Chronology Report.
In this article
Customizing columns
Columns in the Timeline Data tab are customizable. The width and order of columns can be changed, and columns can be hidden, renamed or deleted. New columns can also be added.
Please note: Some columns, because of their integral role in the timeline, can be renamed, but not removed. If renamed, they will retain their original functionality, regardless of the name assigned. These columns are: Event/Task Name, Start, End, Duration, and Category. The ID column can not be deleted or renamed.
To show/hide a column
- While viewing the Timeline Data tab, select the Home tab.
- In the View group, click the Columns button.
- Select the column you wish to show or hide from the drop down list of available columns. A checkmark indicates that the column will be displayed in theTimeline Data tab.
Tip: You can also hide a column using the right-click menu. To do so, right-click on the column header you wish to hide and select Hide.
To insert or delete a column:
- Right click on the column you wish to delete, or on the column next to where you wish to insert a new column.
- If inserting a column, select Insert Before or Insert After, according to your preference. Select a column from the list of available columns, or create a new column by selecting New, then name the column and press the Enter key.
- If deleting the column, select Delete.
Tip: if you choose to delete a column that contains data, that data will also be deleted.
To rename a column:
- Right-click on the column you wish to change and select Rename Column.
- Enter the new name and press Enter on your keyboard.
To change to order of the columns:
- Click on the heading of the column you wish to move and drag it to its new location.
- Repeat with other columns, as desired.
Note: The Checkbox and Attachments columns are static and not adjustable.
To change the width of a column:
- Double-click on the column boundary to increase/decrease the width to the size of the longest text in the column.
OR
Rest the pointer on the column boundary you want to move until it becomes a double headed arrow. - Drag the boundary until the column is at the desired width.
Sorting the data
Once data is entered, it can be sorted according to any of the column details, in ascending (A – Z) or descending (Z – A) order.
To sort the data by column:
- While viewing the Timeline Data tab, select the*Home* tab
- In the View Group, click on the Sort By button and select the column you wish to sort by. Selecting it once will sort the list in ascending order. Selecting again will sort the list in descending order. Alternatively, you can select the Ascending and Descending options in the Sort By drop down menu.
OR
Click on the column heading you wish to sort by. This will sort the list in ascending order. If you wish, you can click again on the same heading to sort in descending order.
Tip: An arrowhead (up or down) in the column heading indicates the sorting column and direction of the sort.
Date Format
You can choose how date and time will be displayed in the Timeline Data tab. Your preference selected in the Timeline Data tab will not affect previously created charts, but will be used as the default format for subsequent charts.
To choose the date and time format:
- While viewing the Timeline Data tab, select the*Home* tab
- In the View Group, click the Date Format button.
- Select the desired display style. A checkmark indicates the style in use.
_Tip: For more information on entering dates and times for your events see Entering Dates
Need more help with this?
Don’t hesitate to contact us here.