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