In Excel 2003 I'm creating a very simple area chart with a legend placed to
the right of the plot area. If I move the legend to say bottom of the plot
area (right mouse click and "Format Legend/Placement/Bottom") the plot area
itself automatically resizes to maximise the visibility. This is good news
for me.

The problem occurs when the plot area has been manually resized (using the
mouse). When the legend is now moved it only resizes the plot area if it
overlaps with the legend. This is bad news for me because it doesn't maximise
the possible size for the plot area.

If a plot area is manually altered it somehow turns off the ability for the
plot area to be auto sized (as if it was a new chart). How do I turn this
back on again ?

Any help would be appreciated, Jack.