Chart Location

[DaGoose]

I am trying to inset a chart into a worksheet. I can get the chart set up the way I want it with all the correct information, BUT Excel doesn't offer me the option to insert it into the present work sheet. It only offers to insert a new sheet. I have re-booted and I can do it on other spreadsheets. Just not the one I am working on. I know there must be a "Switch" somehwhere that has been set but for the love of mud I cant find it. Any ideas?

 

[tusharm]

Speculation: Is the sheet locked?

 

[DaGoose]

Nope, Thought of that also. Any one else wanna stab at this one? Has several folks in the office stumped. (But that doesn't take much). It is something on that sheet. I copied all the information to a NEW spreadsheet and I was able to insert the chart. But for some reason that particular spreadsheet wont allow it. Would like to know what it is SO MAYBE, just MAYBE if I ever run into it again I might remember.

 

[tusharm]

Ah, yes. Tools | Options... | View tab. Make sure that in the Objects section 'View all' is selected.

 

[DaGoose]

Sorry it tok so long to get back to this but....Anyway, That was one of the 1st things I checked. Still nothing. I have been "Tinkering" with it off and on today but still cant put the chart on a particular page. Thanks for the help any other ideas?