Size with Window

[klf-WA]

I'm working on a workbook with several charts. When I "create a copy" of a
worksheet that contains only a chart, the copy comes in automatically set to
"size with window". I don't want this to happen and can't figure out how to
undo the feature. I tried clicking on the icon, using Alt+, etc. to no
avail. Any suggestions?

Telecommuting using Excel 2003 from work.
Thanks!

 

[Jon Peltier]

Nomenclature: if it's a chart-only sheet, it's not a worksheet, it's a chart
sheet. A worksheet by definition has all those rows and columns.

With the chart sheet active, go to Tools menu > Options > Chart tab, and
uncheck the box for Chart sizes with window frame.

- Jon

 

[klf-WA]

Thanks for the clarification - yes it is indeed a chart sheet. I tried
unchecking the icon for "Size with Window" but this was ineffective. Other
suggestions? Thanks.

 

[Jon Peltier]

Sometimes this setting doesn't work properly unless you have a printer
installed.

- Jon

 

[Ray G]

Hello Jon,

I tried to follow your suggestion, but the "sized with window" check box is
grayed out. Is there a way to uncheck it.

Thank you,

Ray G.

 

[Jon Peltier]

This might be one of those features that's inexplicably not available unless
there is a printer installed.

- Jon