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.
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.