Resize chart automatically when window size changes?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

XYMooseHunter - 21 Sep 2006 16:58 GMT

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

Reply to this Message

Jon Peltier - 21 Sep 2006 19:13 GMT

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
_______

>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
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Alan - 29 Sep 2007 07:04 GMT

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

> This works only on chart sheets. Select the chart, go to Tools menu >
> Options > Chart tab. Find and check Chart Sized with Window Frame.
[quoted text clipped - 13 lines]
> >
> > Thanks

Reply to this Message