Plot Area Resize

[Chris Gough]

G'day all.

I'm having difficulty with a chart resizing it's plot
area when the chart type is altered. The user can click
one of four buttons (2D, 3D, Line, Pie) to alter the
charts appearance and when 3D is selected the PlotArea is
reduced. I also appear to loose the ability to explicit
the size of the PlotArea in my code.

Any ideas out there would be greatly appreciated.


Regards,
Christian Gough
Analyst Programmer, DBA
HITACHI
Hitachi Construction Machinery (Australia) Pty Ltd
(e-mail address removed)

 

[Jon Peltier]

Chris -

When resizing plot areas, I always shrink the plot area first, maybe to
half its original size, then I move it to where I want it by changing
its .Top and .Left properties, then I expand it to the size I want with
..Width and .Height. Increasing the height only moves the bottom down,
for example, so you have to make room by raising the top of it first.
When the bottom gets to the bottom of the chart, the height can increase
no further.

The plot area "inside" dimensions of a 3D chart are much smaller than
those of a 2D chart, because you need room for those pesky third
dimension formats. The actual plot area "outside" dimensions may not be
changing, but remember, the plot area includes room for axis labels and
ticks.

- Jon

 

[Chris Gough]

Ok: I shrink, reposition then resize the chart and now it
behaves as it should.

Fantastic - I can stop pulling my hair out now!!!

Thanks Jon