Scrollbar to change Pivot Table Date Filter

Hi.

I am relatively new to VBA/Macros etc, and am struggling with this problem.

I want to have a scroll bar that changes the pivot table filter so that I can scroll between dates, and what was performed on these dates.

I have attached the excel document.

Hope someone can point me in the right direction.

Many thanks.
Scrollbar change PT date.xlsx

Sorry, I should have explained further.

I want to link a pivotchart to the pivot table, and with each click of the scrollbar, be able to scroll between dates, showing what happened each day.

Does that make sense?

Thats the idea but I want it to only show one day at a time. So the scroll bar changes it from day to day and the graph only shows that day.

Sorry, just trying to solve this issue asap.

Many thanks.