Creating a PivotTable Timeline

Contact Us or call 1-877-932-8228
Creating a PivotTable Timeline

Creating a PivotTable Timeline

You can now use the PivotTable Timeline feature to filter your data by time.

To create a PivotTable Timeline:

  1. Click the PivotTable.
  2. From the PIVOTTABLE TOOLS ANALYZE tab, in the Filter group, select Insert Timeline.
  3. In the Insert Timeline dialog box, check the check box of the date fields you want in the timeline.
  4. The timeline is displayed. To filter by date, click the arrow next to the time section and make a selection.
  5. Drag the scroll bar to see the filtered data.
  6. To see a specific time period, click and drag the timeline handles.
  7. Click the Clear Filter button to clear the timeline.
Next