Creating a Scroll bar to filter a Pivot Table (By Time) Excel 2010.

[vhookup]

I have the below Pivot table (it goes through to zone 8), The data in the columns is number of people in an area at a given time. I would like to add a scroll bar connected to the pivot to filter this table (a total of 17 positions) i.e. position 1 showing 06:30 and position 2 showing 07:30 etc. I have Slicers set up to filter different dates (of which there are many). The end result is going to be a conditionally formatted map where you can scroll through the timeline (scroll bar) to view population of certain zones - (this bit i have figured out, i just need help to filter the time so I can see one row in my Pivot table that is controlled by the scrollbar - as you go along the bar horizontally the time increases and vice versa)

I have tried recording macros and adapting other similar projects in VBA but had no luck, I'm new to the VBA side of things (not used anything like that since before the turn of the century) I have also seen there is a timeline function in later versions but I'm only in 2010.

Time	Zone 1	Zone 2	Zone 3
06:30:00	1	1	0
07:30:00	4	5	8
08:30:00
09:30:00
10:30:00
11:30:00
12:30:00
13:30:00
14:30:00
15:30:00
16:30:00
17:30:00
18:30:00
19:30:00
20:30:00
21:30:00
22:15:00

<tbody>
</tbody>

Thanks in advance for your help.

 

[SpillerBD]

The timeline feature won't get to hours. Finest granularity is "Day" of month.
You will need some VBA for an Event so that when you change your desired Control Element, it will apply to your Pivot Table.
Start at the Developer's Ribbon and work through the Controls. Probably a slider control with a range of 17 values. Feed that to cell that is monitored by ChangeEvent to get the update and apply to the Pivot Table.

However, there are huge benefits to being on 2016 and Office365. The Slicers feature does seem like a great fit to your goal.

 

[vhookup]

You will need some VBA for an Event so that when you change your desired Control Element, it will apply to your Pivot Table.
Start at the Developer's Ribbon and work through the Controls. Probably a slider control with a range of 17 values. Feed that to cell that is monitored by ChangeEvent to get the update and apply to the Pivot Table.

However, there are huge benefits to being on 2016 and Office365. The Slicers feature does seem like a great fit to your goal.

Unfortunately I'm stuck with this version of Excel until the company decided to update it. So I'm kinda pleased the timeline function isn't the answer.

I've got the scroll bar set with the parameters. Does a slider allow you to input time values as a range?

I'm off to do some research on that "change event" you mentioned. Thanks for the input. I'll report back.