Size of the plot area

**shimuno** · 11-23-2011, 04:33 AM

Hello

I am currently working on a macro formatting charts. I would like it to defines the size of the plot area, but so far I have not succeed.

(The macro recorder has not been very helpful...)

Any idea?

**Andy Pope** · 11-23-2011, 04:43 AM

Macro recorder gave me enough code to get started.

Please Login or Register  to view this content.

From the macro code you can see that rather than use the selection object you can use the Plotarea object of the active chart to set size and position.

Please Login or Register  to view this content.

**teylyn** · 11-23-2011, 04:46 AM

Hello,

the Excel 2003 macro recorder captures plot area sizing nicely. What do you get?

Here is the recorded code:

Please Login or Register  to view this content.

which should of course be cleaned up.

**shimuno** · 11-23-2011, 05:06 AM

Okay, I have finally understood where I was wrong. You have to define the position of the plot area before defining its size, otherwise it does not work.

Many thanks.

**Andy Pope** · 11-23-2011, 05:29 AM

You are correct. You can not position or size any chart element such that it would exceed the chartarea dimensions.

This may mean moving, sizing and moving again the object in order to get the desired result.