You could reset the chart's formatting (Chart menu Chart Type, check the
Default Formatting checkbox). Unfortunately that resets everything, not just
the autosizing of the chart area. I don't know whether this default behavior
can be individually reset.

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


"jack" wrote in message
...
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.