• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using a scrollbar on a pivot table


New Member
Hello, I'm new and I've tried looking for this answer everywhere.

I'm in the process of creating a dashboard with pivot table. I have huge data (included few in the attached file) so having a scroll bar will help visualize the data efficiently. I have referred few threads on adding scroll bar to pivot and attempted to incorporate it, but could not. I could not see data scrolling/moving along with bar (could not loop the data with scroll bar). can we do it only when we have numbers or counts included in the pivot? Any leads in resolving this would be greatly helpful!
Do we have any other option for the same?

In the attached file is a small sample of the source data, actual file has 1500+ entries.

Many thanks!