Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 371
Default Chart Location Choice

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5,600
Default Chart Location Choice

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

"Geoff" wrote in message
...
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?


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 371
Default Chart Location Choice



"Peter T" wrote:

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

"Geoff" wrote in message
...
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?


Peter:
The worksheets are unprotected.
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5,600
Default Chart Location Choice


"Geoff" wrote in message
...


"Peter T" wrote:

Is the sheet protected, preventing insertion of any objects.

Regards,
Peter T

"Geoff" wrote in message
...
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?


Peter:
The worksheets are unprotected.


(Only just seen your reply)

Can you insert any other objects on the same sheet, eg a rectangle.

Regards,
Peter T

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
How to specify location for chart in VBA Fred Smith[_4_] Excel Discussion (Misc queries) 1 February 27th 08 01:50 PM
Chart location hederman Excel Discussion (Misc queries) 1 December 21st 07 12:13 AM
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


All times are GMT +1. The time now is 06:31 PM.

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

About Us

"It's about Microsoft Excel"