Create a PivotTable timeline to filter dates

You can use a PivotTable timeline in Excel to filter dates interactively — perfect for dashboards or time-based reports. It works like a slicer but is designed specifically for date fields.

✅ What Is a PivotTable Timeline?

A timeline is a visual date filter you can connect to a PivotTable. It lets you filter by:

• Year
• Quarter
• Month
• Day

Just click and drag across the timeline to filter your PivotTable dynamically.

🛠 How to Insert a PivotTable Timeline

📌 Step 1: Create or Select a PivotTable

1. Make sure your data includes a date field.
2. Create a PivotTable (Insert → PivotTable) or click inside an existing one.

📅 Step 2: Add a Timeline

1. Click inside your PivotTable to activate it.
2. Go to the PivotTable Analyze tab (Excel 365/2021: called PivotTable Analyze).
3. Click Insert Timeline in the Filter group.
4. In the dialog box, select the date field (e.g., Order Date, Transaction Date).
5. Click OK.

✔️ A timeline will appear on your worksheet.

🎯 Step 3: Use the Timeline to Filter

• Use the dropdown to choose the time level: Years, Quarters, Months, or Days.
• Click or drag across the timeline to filter your PivotTable.
• The chart or table updates instantly to reflect your selection.

🖌️ Optional: Format the Timeline

• Resize or move the timeline like any object.
• Use the Timeline Tools → Options tab to:
  • Change styles
  • Adjust caption
  • Set report connections (if you want to link it to multiple PivotTables)

💡 Bonus Tip:

If your date field isn’t recognized as a proper date, Excel may not let you insert a timeline. Make sure your column is formatted as a Date in the original data.