Timeline – a very nice Excel 2013 feature
We all like a good pivot table don’t we? But to get the full range of summary option we sometimes need to add more than we’d like.
For instance, in my personnel database I want a summary of salary and bonus for each department. But I also want to be able to filter the results by the start date of the staff.
To do this I would have produced a pivot table similar to the one below and then used the custom date filter to filter by the correct period.
I could group the data, but once again, it’s less than elegant. It would also be possible to create an activex control or some VBA to make this more flexible but it’s becoming increasingly complex.
Excel 2013 has a beautifully simple Timeline filter that provides a simple slider type interactive filter.
To use this just create your pivot table as normal. It is not necessary to include the date field you will use the Timeline filter on in the pivot table:
On the insert ribbon you will find the Timeline tool
When you use the tool it will identify any fields that the Timeline filter can . . well . . filter.
Pick your field, and your timeline is ready for use!
You can change the periods it filters
Pick your period, and your Pivot table will be filtered
You can move or extend the period filtered
Very simple, very nice!
If you have any Excel questions or hints and tips you would like shared get in touch!
Remember – If you’ve been on a Happy Computers course you get 2 years free helpline access. Call the helpline on 0207 375 7373.