Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table, something like below.Anytime I select from a list box my chart columns resizes to the selection. I want to keep the view as is with no selections. Is there a way to prevent the resizing?
Central Division North Division
Central east Central West North east North west
You may need to use {1} set identifier in your expressions to ignore selections.
I don't want to ignore the selections. I just want to keep the chart the same size when selecting from my list boxes.
Which version you are using, I was just checking in version 12, the demo app 'Data Visualization' which comes along with desktop edition and could see that column size is not changing when selecting values from list box, in fact showing 3 dots ... when value length is higher than column size.
Sorry, just got that you mentioned ver no in the subject
11.2
See if Unchecking 'size to data' in pres tab helps -
It doesn't. I have also tried sheet properties--->security properties uncheck "Move size sheet objects"
Not sure then hope others will help you out on this, if you are using Ajax client then someone else also faced similar issue -
Hi,
Share qvw so that we can check it.