I am trying to create a chart in an Excel 2002 worksheet, but as I go
thru the chart wizard the "As object in" option is turned off. It will
only create a chart as a new sheet. When I click on Insert Obect, I
get an error message "Can't insert object". Does anyone know how to
fix this?
Thanks,
Steve
Nick Hodge - 26 Jan 2005 16:03 GMT
Steve
Is the worksheet protected?

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>I am trying to create a chart in an Excel 2002 worksheet, but as I go
> thru the chart wizard the "As object in" option is turned off. It will
[quoted text clipped - 4 lines]
> Thanks,
> Steve
Gord Dibben - 26 Jan 2005 16:53 GMT
Sounds like the worksheet is protected.
Tools>Protection. Is Protect Sheet available or do you see only Unprotect
Sheet?
Gord Dibben Excel MVP
>I am trying to create a chart in an Excel 2002 worksheet, but as I go
>thru the chart wizard the "As object in" option is turned off. It will
[quoted text clipped - 4 lines]
>Thanks,
>Steve