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 how Timeline works!

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