PDA

View Full Version : Textbox does not copy from a chart



krishnak
10-14-2010, 09:58 AM
Hi All,

I have a problem in copying charts from Excel.

In the chart, I created two text boxes - one at the bottom (larger size) and one on top (small, 0.4x0.2in). I entered values manually in both the text boxes.

When I copy and paste it as a 'picture' (whatever format jpg, Excel picture file etc) in another worksheet, the smaller text box fails to copy. The larger one does. I checked to see whether the textbox is being obstructed by another shape and through the menu brought this shape to the "Front". But it does not have any effect.

I want to save the chart as a picture in another worksheet and then save the chart (picture) as a .pdf file.

However when I save the Excel chart directly as a .pdf file through VBA code, the smaller text box gets saved as well.

Has anyone experienced this problem? How can we make the smaller text box show up while the chart is being saved as a picture?

Thanks for any suggestions.