+ Reply to Thread
Results 1 to 2 of 2

Scaling Charts in Excel 2007

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Scaling Charts in Excel 2007

    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?
    Last edited by HangMan; 07-12-2011 at 04:58 PM.

  2. #2
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Scaling Charts in Excel 2007

    OK, figured it out, simply adjust the size in the VBA code...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1