Resize chart automatically when window size changes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top