> With the help of your answers on my question of July 30 and some digging
> in excel4 I succeeded in making the inside of the plot area exactly a
> square with predefined dimensions.
>
> I made a function that finds the dimensions of a rectangle that encloses
> all elements in the plot including title, axes-titles and text boxes.
>
> Now I want the chart area to fit tightly around all the actual plot
> elements. But I do not succeed in resizing the chart area without
> resizing the plot.

Why not just make the chart area sufficiently large to always encompass
the axis elements? Otherwise you will have to endlessly tweak the chart
area, the plot area, and other elements. You can make the chart area
invisible (no border, no fill) if you want the charts closer together
without apparent overlap.

> Is there some (hidden) feature that switches off autoresizing like there
> is one for the font?

No.

> When I have a solution I will publish the final results of my endeavours
> on this newsgroup of course.

If you are very patient, you could do this with an iterative VBA
approach. The problem is that it is never going to be perfect, and
sometimes it will be off by a pixel, no matter how loudly you admonish
Excel to behave.

One trick is to hide all of the axis ticks and labels, so that the plot
area isn't much larger than the inside area, and so that the margin
between plot area and inside area does not have to adjust for label
format changes, etc. Use the arbitrary axis scale trick from my web site
for your labels, which lets the labels go outside the plot area without
stretching the inside area. See this page for details:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______