Chart Location Choice

[Geoff]

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 T]

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

 

[Geoff]

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

Peter:
The worksheets are unprotected.

 

[Peter T]

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