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 programmatically turn this back on again ?
I know how to calculate a good plot area after the chart has been manually resized, ie activechart.plotarea.height = pixels, but I was wondering if there was an easier option because a new chart already does the calculation for me.
I'm looking for something like :- activechart.plotarea.autosize = true.
This is your challenge if you choose to accept !
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 programmatically turn this back on again ?
I know how to calculate a good plot area after the chart has been manually resized, ie activechart.plotarea.height = pixels, but I was wondering if there was an easier option because a new chart already does the calculation for me.
I'm looking for something like :- activechart.plotarea.autosize = true.
This is your challenge if you choose to accept !