Chart Wizard "as object in:" turned off

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. Does anyone know how to fix this?

Thanks,
Steve

Hi Nedrgr21,

Try:

Tools | Options | View | :Objects | Select the "Show All" option.


---
Regards,
Norman



"nedrgr21" <nedrgr21@discussions.microsoft.com> wrote in message
news:BFAFA576-6FF4-462C-B66F-9B51E2C4FEB0@microsoft.com...
>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. Does anyone know how to fix this?
>
> Thanks,
> Steve

Hi Steve

not sure, but if when you create the chart in a new sheet and choose chart /
location from the menu - is the option available to you then? if not, is
the sheet protected?

Cheers
JulieD

"nedrgr21" <nedrgr21@discussions.microsoft.com> wrote in message
news:BFAFA576-6FF4-462C-B66F-9B51E2C4FEB0@microsoft.com...
>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. Does anyone know how to fix this?
>
> Thanks,
> Steve