Excel like a finance pro.
Pivot tables · Filtering
Timelines
A slicer built for dates that lets you pick years, quarters, months, or days by dragging.
When to use it
A timeline is a slicer built for date fields: drag across years, quarters, months, or days to filter.
The shape of it
- How
PivotTable Analyze, Insert Timeline, choose the date field.
Worked examples
Add a timeline
PivotTable Analyze, Insert Timeline, check Order Date → A bar of months to drag across
Date ranges by hand.
Change the level
Click the level dropdown, choose Quarters → Quarter blocks
Coarser control.
Connect pivots
Report Connections → One timeline for several pivots
Dashboards.
Worth knowing
- The field must be a real date column, not text.
- Clear the filter with the small button in the corner.
- Combine with a slicer for category filters.
Where it goes wrong
- Text dates make the timeline unavailable.
- Very long date ranges need scrolling.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.