I have one spreadsheet with lots of charts but for some reason I cannot
select the chart location. The only one allowed is "As new sheet". The
alternate ""As object in" is ghosted out! what did I do wrong?? I have
checked tools-option? I disabled macros?