Preserve Scroll Working position doesn't work on Pivot Charts

[k_burata]

Hi,

I have been looking for a way to solve this seemingly easy problem for quite some time now. How do I make preserve scroll position work on a Pivot chart? It works on Straight Table chart but not on Pivot charts. Whenever I click something on a pivot chart it always bring me to the top of the chart.

Cheers,

[k_burata]

I've included a qvw file to explain further. In the file I have 2 tables, a Pivot (Summary) and a Normal Table (Details). What I want to achieve is that when I click on something in the pivot table it would preserve the scroll position (which it is not doing now) and filter out the details table depending on the selection. I have already ticked the Preserve Scroll Bar Position option on the Pivot Chart Properties.

[daniel_martin_a]

Any answer about it? I have same problem and try to fix with macros without success.

Please, somebody know to fix it? (My problem is that need xscrooll initial position right, but macro not run).

Thanks.

Regards.