Hi There,
Is is possible to move the position of a pivot chart dynamically if a list box or something similar is checked.
E.G. I have a Pivot Chart that will increase/decrease in columns based on a value selected by a list box.
I then have another pivot chart right next to the first pivot chart that fits perfectly if all columns are being displayed. However if the columns are reduced on the first pivot chart, the second pivot chart stays in the same position which makes ther report looks very spaced out.
Any solutions out there for this?
Thanks a lot,
Kevin.
