+ Reply to Thread
Results 1 to 3 of 3

Resizing or Moving Chart Shapes and Screen Resolution

  1. #1
    Registered User
    Join Date
    11-23-2009
    Location
    asdad
    MS-Off Ver
    Excel 2003
    Posts
    11

    Resizing or Moving Chart Shapes and Screen Resolution

    Hi,

    I am trying to use vba to automatically create charts. But, I can't get the chart shapes such as plot area and legend sized or moved properly that is uniform accross all different screen sizes/resolution. For example, if I were to set the sizes according to a 1280x1048 screen, running the same code on a 1680x1280 screen would totally distort it...it would keep the plot size small and only adjust the chart size. So the actual chart size gets adjusted, but the shapes inside it do not do not.

    I am using Excel 2003 and the code I am using to size is the following:

    Please Login or Register  to view this content.
    Any advice would be appreciated.

    Thanks.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Resizing or Moving Chart Shapes and Screen Resolution

    Your code adjusts only the plot area.
    Perhaps you should be adjusting the actual chart object.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-23-2009
    Location
    asdad
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Resizing or Moving Chart Shapes and Screen Resolution

    I do size the actual chart object and it works just fine. The issue is only with objects within the chart.

+ 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