 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / August 2003Vanishing text boxes
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 ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > I'm trying to copy, as pictures, a considerable number of charts from > different sheets onto a consolidated sheet that I can then distribute [quoted text clipped - 10 lines] > > TIA John 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 > John - > [quoted text clipped - 31 lines] > > > > TIA John |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.