graphic1

Use the Time Line

What Do You See? A new Timeline filter will be added to the PivotChart. The default display is Months, but you can change the interval to Years, Quarter, or Days.

 

6. Try it: Use the Time Line

Edit the Timeline as follows:
Display as: Months.
Use the slide bar to select Jan through Jun.

The PivotChart will update as you select the dates. The Chart animation is cool, isn't it?

 

Rename this spreadsheet Slicers and Save your work.

PivotChart Tools ->Analyze ->Filter-> Insert Timeline

Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.1 Create Advanced Chart Elements: Chart Animations

 
pic1