no effect when setting height of PlotArea with VBA

  • Thread starter Thread starter Enda
  • Start date Start date
E

Enda

Hi all,
Has anyone experienced this problem. I am reducing the height of a chart PlotArea.
The following code has no effect on the .Height property of the PlotArea!

With ActiveChart
With .PlotArea
.Height = .Height - 2

Am I missing something? Is this a bug?

Regards,
Enda
 
Enda -

What version of Excel are you using. I was thinking at first that your
problem was beginner's (bad) luck, but while writing a sample macro I
had some funny things happen too.

- Jon
 
Hi Jon,
Sorry for my delay in replying.

I am using Excel 2000 9.0.6926 SP-3 on Windows 2000. It seems that the
sample code will reduce PlotArea.Height by an arbitrary amount or not
at all!
Have you any suggestions on a work-around that can exactly set
PlotArea Height and Width?

Regards,
Enda
 
Since reading your post, I found out that this is a known issue, but
there's no documentation available. I haven't been playing with Excel
2000 long enough to know how to get around this issue. As always, I have
some ideas to try, in my copious spare time.

- Jon
 
I meant to say, that's the version I'm using, with Win XP Home. The plot
area height likes to increase by 21 points every time I as it to
decrease; in fact, it seems to overshoot the value I command it to by
around 21 points, until it is too large to expand further. Perhaps you
could find your offset, and deduct that:

myOffset = -21
With ActiveChart
With .PlotArea
.Height = .Height - 2 + myOffset


- Jon
 
Hi Jon,
Unfortunately my difference (sometimes an overshoot and sometimes an
undershoot) is not constant. Even iterating with small changes in
PlotArea to approach the desired dimensions does not work.
Thanks for your time.

Enda
 
Back
Top