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" <(E-Mail Removed)> wrote in message
news:584C1657-A616-41C4-ABE9-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:584C1657-A616-41C4-ABE9-(E-Mail Removed)...
> >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