Text boxes disappear on Excel Chart

G

Guest

With Excel 2003 I'm trying to print a Chart with text boxes on it (some are
text comments and others are data values).
I'm getting an unusual result. If I select the chart, the text boxes
with data values in them disappear and will not print, but the text boxes
with text stay visible and do print.
If I click in a worksheet cell off the chart, the data values in the
chart reappear...if I select cells behind and around the chart, I can print
the chart and the data values also print (but the resolution is lower). It's
only when I select the chart that the data values disappear.
I can't understand why when I select the chart, text boxes with text
remain visible but text boxes with data values disappear.
Does anyone have any ideas what I can do?
 
D

Debra Dalgleish

It sounds as though the chart wasn't selected when you created some of
the textboxes. To correct the problem:

Select one of disappearing textboxes
Choose Edit>Cut
Select the chart
Choose Edit>Paste
Drag the textbox to its correct position in the chart.

If you want to add more text to the chart, instead of inserting a text
box, select the chart, and start typing.
You'll see the text in the formula bar as you type.
Press the Enter key, and the text will appear in the centre of the chart
Drag the text box to the location you want it, and format the text
 

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