To insert a timeline in a pivot table, you need to:
1. Select a cell in your pivot table.
2. Click the PivotTable Tools Analyze or PivotTable Analyze tab in the Ribbon.
3. Select Insert Timeline.
4. A dialog box appears. Select the check boxes of the date fields you want to use and click OK.
5. Adjust the size and position of the timeline as you wish