• 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

    Hui...

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

Pivot Table with Scroll Bars?

foste158

New Member
I've created a heat map for a dashboard using a pivot table and conditional formatting.

The problem: It's 80 columns wide and 100 rows deep - it's messing up the formatting of my dashboard. Can I put a scroll bar on the pivot table so that it only shows 10 columns and 10 rows at a time?

Any other ideas or recommendations are welcomed! Thank you in advance for your help.
 
You can put the pivot elsewhere, and in your dashboard create a grid that reads data from the pivot.
Google use offset function. On Chandoo's bog, there is certainly a tutorial on this to be found.
 
Back
Top