Text box in chart disappears but reappears when in spreadsheet

G

Guest

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!
 
A

Andy Pope

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data disappears when I edit the chart. 1
Totals in the data table but not in the graph / chart 1
Outlier data point for Chart in Excel 1
Excel crashes dragging a chart 7
Chart Area visible but cannot access rows and columns on worksheet 2
Disappearing Text Boxes 1
Dynamic text box labeling 7
Decimal point in bar chart and similar 1

Top