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