Samuel has attended:
Excel Intermediate course
Pivot table. How to make the time line header in range , not onl
I did try the above time line header in range but fail. Could you let me know how to work this out ?
RE: Pivot table. How to make the time line header in range , not
Hi Samuel,
Thank you for the forum question.
It sounds like you're trying to customize the timeline filter in a PivotTable in Excel so that the header displays a range of dates rather than just individual time periods (like months or days). Let me clarify a few things and guide you through what’s possible:
What You Might Be Trying to Do
Use a timeline slicer to filter your PivotTable by a range of dates.
Display the selected date range in a cell or header (not just on the timeline control itself).
What You Can Do
Excel's Timeline slicer allows you to:
Filter by Years, Quarters, Months, or Days.
Select a range by dragging across the timeline.
However, the header of the timeline itself cannot be customized to show a custom label or range directly. But you can display the selected date range in a cell using formulas.
How to Display the Selected Timeline Range in a Cell
Insert a Timeline:
Click on your PivotTable.
Go to PivotTable Analyze > Insert Timeline.
Choose your date field.
Link the Timeline to a Cell:
Right-click the Timeline > Report Connections to ensure it's connected to your PivotTable.
Use the FILTERS or CUBERANKEDMEMBER functions to extract the selected range.
Use VBA (Optional): If you want to dynamically show the selected range in a cell (like “From 01-Jan-2024 to 31-Mar-2024”), you’ll need a small VBA script because Excel formulas can't directly read the timeline slicer selection.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
