#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Chart location

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default Chart location

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

"hederman" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to specify chart location as obj in current sheet? Dr Dan[_2_] Charts and Charting in Excel 6 February 23rd 07 03:25 PM
Fixed Chart Location Dave_AD Charts and Charting in Excel 2 December 26th 06 03:57 PM
Location of pivot chart C Tate Charts and Charting in Excel 1 December 16th 05 05:01 AM
location of chart bludik Charts and Charting in Excel 4 May 24th 05 12:24 PM
How to move location of chart within a worksheet? [email protected] Excel Discussion (Misc queries) 1 May 17th 05 11:38 PM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"