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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


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

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com


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