Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Eggcel
 
Posts: n/a
Default Text box in chart disappears but reappears when in spreadsheet

Has anyone any idea how to prevent a text box that's in a graph from
disappearing when the graph is selected, but reappearing when cursor is back
in the spreadsheet? This never used to happen before, but only recently has
begun occuring with our graphs. Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Text box in chart disappears but reappears when in spreadsheet

Hi,

That behavior would suggest the textbox is not embedded in the chart but
just placed over it. Can you move the textbox away from the chart?
If yes then delete the textbox and then select the chart and paste.

Cheers
Andy

Eggcel wrote:
Has anyone any idea how to prevent a text box that's in a graph from
disappearing when the graph is selected, but reappearing when cursor is back
in the spreadsheet? This never used to happen before, but only recently has
begun occuring with our graphs. Thanks!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Text box in chart disappears but reappears when in spreadsheet

The text box and the chart need to be grouped. If you had selected (clicked)
the cart before making the box this would have been automatic. Can be fixed:
1) Right click chart: Send to back
2) Hold CTRL and click box so that both are selected
3) Right click and use Group
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eggcel" wrote in message
...
Has anyone any idea how to prevent a text box that's in a graph from
disappearing when the graph is selected, but reappearing when cursor is
back
in the spreadsheet? This never used to happen before, but only recently
has
begun occuring with our graphs. Thanks!



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
formatting text on chart for specific values satraver Charts and Charting in Excel 1 January 17th 06 10:06 PM
Chart Property Confusion Arturo Charts and Charting in Excel 4 December 16th 05 05:13 AM
replace axis text with graphics on excel chart (excel 2003) Mad_Hatter_29 Charts and Charting in Excel 3 December 6th 05 01:42 PM
Chart title text linked from a cell? Possible? cwinters Excel Discussion (Misc queries) 2 October 10th 05 09:28 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 05:54 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"