Text box disappears on chart


G

Guest

I added a text box to a chart and when I click off of it, the text box disappears (goes behind the chart). I have tried Bring to Front and Bring Forward, and it may or may not stay visible and print. I have clicked on the frame of the text box (it changes pattern) and tried Bring to Front - same problem.

Any ideas?

Carole O
 
Ad

Advertisements

D

Debra Dalgleish

The text box is on the worksheet, not the chart. To fix the problem,

Select the text box, and choose Edit>Cut
Select the chart (you'll see handles on its corners and sides)
Choose Edit>Paste, to paste the text box onto the chart.

Click away from the chart, and the text box should remain visible.
 
Ad

Advertisements

J

Jon Peltier

Next time, the easy way to add a textbox the the chart is to select the
chart, and just type whatever you want in the textbox. Excel packs your
text into a textbox in the middle of the chart. Format, resize, and move
this textbox, and you're done.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top