Vanishing text boxes

  • Thread starter Thread starter John Humble
  • Start date Start date
J

John Humble

I'm trying to copy, as pictures, a considerable number of charts from
different sheets onto a consolidated sheet that I can then distribute
without the large quantity of underlying data and calculations. All the
charts were generated by the same VBA routine and each includes three text
boxes. These are unavoidable.

When I copy the charts as pictures one at a time by hand I've not met any
problems. However, doing the copying within a VBA loop results in some of
the copied charts appearing without their text boxes. Whenever this happens
all three text boxes are missing, even though they are not grouped. Is this
another of Excel's annoying tricks or have I missed something? The charts
are resized during the process. I'm using Excel 2000 under Win 98SE.

TIA John
 
John -

Are the text boxes actually part of the chart, or can they be dragged
off the chart? If you copy the chart, it only includes text boxes which
are integral to the chart.

To put a text box into a chart, cut it, select the chart, and paste; or
select the chart before you add the text box.

There are circumstances in which text boxes do not behave, even when
incorporated correctly into a chart. For this reason, I use data labels
on an invisible dummy series whenever possible. This assures proper
placement of the labels, but provides less control over stuff like line
wrapping. Nothing's perfect, eh?

- Jon
 
Thank you John. The text boxes were part of their charts - they could be
dragged around their chart but not beyond it. I've taken your hint and
replaced them by a Chart Title and dummy axis labels (the real ones aren't
needed). These changes have worked. I'll try to steer clear of text boxes
in future.

John
 
Back
Top