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.
Make Excel work for you with a training class from AETC!
