A Timeline can be inserted into your PivotChart, if dates are listed in your table. After you insert your PivotChart, add a Timeline, located in the Filters group of the Insert tab.
Watch this short video to see a Timeline in action.

For more ways to make Excel work for you, take an Excel training course from AdvantEdge Training & Consulting!