Resizing or Moving Chart Shapes and Screen Resolution

**jubaitca** · 01-09-2012, 10:53 PM

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:

    ActiveChart.PlotArea.Select
    Selection.Height = 210
    Selection.Left = 15
    Selection.Top = 18
    Selection.Width = 335

Any advice would be appreciated.

Thanks.

**Andy Pope** · 01-10-2012, 08:06 AM

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

    with ActiveChart.parent
        .Height = 210
        .Width = 335
    end with

**jubaitca** · 01-11-2012, 11:47 PM

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

Thread: Resizing or Moving Chart Shapes and Screen Resolution

Thread Tools

Display

Resizing or Moving Chart Shapes and Screen Resolution

Re: Resizing or Moving Chart Shapes and Screen Resolution

Re: Resizing or Moving Chart Shapes and Screen Resolution

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions