I have a series of charts displayed on a UserForm, however they are too small. If I scale the charts in the worksheet by selecting the chart, going to the format ribbon and selecting 'Scale' from the 'Size and Properties' dialogue, even though my charts will scale on the worksheet, when viewed on the UserForm, they appear at the size they were before I scaled them and when I close the UserForm, the charts themselves also revert back to their pre-scaled size?
Is there anyway to actually permanently scale charts in 2007/2010.
I also am trying to figure out the correlation between the size units VBA uses and Excel uses. I had read that VBA uses TWIPS but when converting TWIPS to CM this doesn't seem to tally. I want to scale my charts to fit the ImageControl size I have set up on my UserForm - is there an easy, obvious way to do this?
Bookmarks