Chart Wizard "as object in:" turned off

N

nedrgr21

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
 
J

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
 
N

Norman Jones

Hi Nedrgr21,

Try:

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