Chart Wizard "as object in:" turned off

[Guest]

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

 

[JulieD]

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

 

[Norman Jones]

Hi Nedrgr21,

Try:

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