Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , I have a requirement to view a 24 month period on a pivot , but there should not be a scroll.
Isthere a way to disable the scroll on a pivot?
What would removing the scroll bar achieve? Either your columns fit on the screen, or they don't... if they do there won't be a scroll bar, and if they don't then you can't achieve 24 months without scrolling.
I am exploring the pivots functionality, if it has a setting similar to the bar chart that allows all the data points to show without the scroll.
You mean the mini chart? That's still a scroll bar, when you get down to it.
Note that with the new pivot table object, you can size the columns much smaller and perhaps fit them all on one screen, which would negate the need for scrolling. Not sure if that helps.