Text boxes disappear on Excel Chart
 

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?
--
Dave Gowan

Text boxes disappear on Excel Chart
 

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 EditCut
Select the chart
Choose EditPaste
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


Wakulla wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html