Size with Window

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!

Nomenclatu 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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"klf-WA" wrote in message
...
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!

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" wrote:

Nomenclatu 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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"klf-WA" wrote in message
...
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!

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"klf-WA" wrote in message
...
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" wrote:

Nomenclatu 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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"klf-WA" wrote in message
...
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!

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" wrote:

Nomenclatu 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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"klf-WA" wrote in message
...
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!

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Ray G" Ray wrote in message
news
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" wrote:

Nomenclatu 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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"klf-WA" wrote in message
...
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!