Chart location

H

hederman

On one spreadsheet I am not able to embed my chart on the worksheet with the
data.
When I go to location the only option it will let me have is "as new sheet"
The "as object in" choice is grayed out and I can't choose that option.
Help this is very frustratiing.
 
B

Bob Umlas, Excel MVP

You MAY have a setting which doesn't allow objects on the sheet. Try
tools/options/view, and under the Objects section, make sure "Show All" is
selected. (shortcut for that is ctrl/6).
Then try again.
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicating Pivot Chart / Changing Pivot Chart data range 4
How to specify location for chart in VBA 1
Cannot update "Chart data range:" Field 2
Chart Location Choice 3
Many menu options are grayed-out 3
Chart Location Impact On Links When Copying To New Workbook 1
Date Listing 1
Chart Wizard "as object in:" turned off 2

Top