Resize chart automatically when window size changes?

[XYMooseHunter]

I have a chart, created by another, that changes size automatically when I
expand or shrink the Excel window. He can't remember how he did this, and I
would like to duplicate this feature on other charts. Can't find anything in
documentation or on-line. May not be using correct "Microsoft speak."

Thanks

 

[Jon Peltier]

This works only on chart sheets. Select the chart, go to Tools menu >
Options > Chart tab. Find and check Chart Sized with Window Frame.

- Jon

 

[Alan]

There's a small problem with your answer- it's only valid for Excel pre-2007.
The option was removed from the 2007 product.

Why- who knows? But if you know of a VBA script ormacro that RESTORES this
function, I'd sure like to hear about it