Chart Location Choice
 

I have one spreadsheet with lots of charts but for some reason I cannot
select the chart location. The only one allowed is "As new sheet". The
alternate ""As object in" is ghosted out! what did I do wrong?? I have
checked tools-option? I disabled macros?

Chart Location Choice
 

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

"Geoff" wrote in message
...
I have one spreadsheet with lots of charts but for some reason I cannot
select the chart location. The only one allowed is "As new sheet". The
alternate ""As object in" is ghosted out! what did I do wrong?? I have
checked tools-option? I disabled macros?

Chart Location Choice
 

"Peter T" wrote:

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

"Geoff" wrote in message
...
I have one spreadsheet with lots of charts but for some reason I cannot
select the chart location. The only one allowed is "As new sheet". The
alternate ""As object in" is ghosted out! what did I do wrong?? I have
checked tools-option? I disabled macros?

Peter:
The worksheets are unprotected.

Chart Location Choice
 

"Geoff" wrote in message
...


"Peter T" wrote:

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

"Geoff" wrote in message
...
I have one spreadsheet with lots of charts but for some reason I cannot
select the chart location. The only one allowed is "As new sheet".
The
alternate ""As object in" is ghosted out! what did I do wrong?? I have
checked tools-option? I disabled macros?

Peter:
The worksheets are unprotected.

(Only just seen your reply)

Can you insert any other objects on the same sheet, eg a rectangle.

Regards,
Peter T