Disappearing Textbox at the bottom area of a chart
 

Hi, Guys:

I attached a textbox at the bottom of a bar chart (click the chart first,
then copy the text box to the chart, then move the text box to the bottom.
The text box serves as footnotes as the chart). When I copy and paste to
word, it is regularly ok, most times the textbox show with the chart.
However, sometimes, the text box does not show even in excel. it is visible
only when you click the area of that text box, when you click outside of the
chart and then scroll the windows, the textbox disappear again.

Very funny, when I move the text box to the upper area of the chart, the
problem disappears.

I searched posts, sb say it is a excel bug, when the chart is to big (around
59 bars, it does not show the text box even you attach it to the chart. I
also tried to group those objects, when I copy and paste, they work well. But
when I use VBA automation, the program can not find chart object, becasue it
is now part of a group.

Can any bd help?

Tks in advance.

Pascal