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! |
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 |
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! |
All times are GMT +1. The time now is 11:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com