Freezing columns

[jlugo]

Hi,

I have pivot charts from column A through AA up to row 150.

Then I have pivot slicers from the right of columns AB and after up to row 40.


How do I freeze the panes so I can scroll down 11 pivot charts to have the slicers to the right w/out moving?

 

[mrmmickle1]

I may be wrong but to my knowledge you can't. You have to freeze the slicers on the top not the right.

I have made a similar report based off of Frozen Slicers on the top and scrolling down....

 

[jlugo]

I ended up putting the slicers on the top. It works but I know they'd prefer them on the side of the charts.

 

[mrmmickle1]

Glad you were able to resolve your issue. In the past I have been able to make Pivot Charts and Pivot Tables Dynamically. By using a drop down to select the Pivot Table Report..... once the Report is selected a pivot table and corresponding pivot chart are created. This could allow for you to keep all slicers on the right hand side of reports like you mentioned. The only drawback is not being able to compare two charts simultaneously. The other thing is that it took me over a month to code everything. So while you can't freeze the panes there are a few other options.....just not simple options.