Microsoft Office Tutorials and References
In Depth Information
Using a timeline
Figure 83-3: Using slicers to filter a pivot table by state and by month.
Using a timeline
A timeline is conceptually similar to a slicer, but this control is designed to simplify time-based
filtering in a pivot table. Timelines are new to Excel 2013, and (unlike slicers) this feature is for pivot
tables only.
A timeline is relevant only if your pivot table has a field that’s formatted as a date. This feature does
not work with times. To add a timeline, select a cell in a pivot table and choose Insert➜Filter➜
Timeline. A dialog box appears listing all date-based fields. If your pivot table doesn’t have a field
formatted as a date, Excel displays an error.
Figure 83-4 shows a pivot table created from the data in columns A:E. This pivot table uses a timeline,
set to allow date filtering by quarters. Click a button that corresponds to the quarter you want to view,
and the pivot table is updated immediately. To select a range of quarters, press Shift while you click
the buttons. Other filtering options (selectable from the drop-down in the upper-right corner) are
Year, Month, and Day. In the figure, the pivot table displays data from the first two quarters of 2012.
You can, of course, use both slicers and a timeline for a pivot table. A timeline has the same type of
formatting options as slicers, so you can create an attractive interactive dashboard that simplifies
pivot table filtering.
Search JabSto ::

Custom Search