I have some code (in Excel 2003) that takes a chart and converts it to a picture so that the user can copy it to another application (e.g. Power Point, Word, etc). The copy and paste works fine. However, when you print out the document the Axis Titles on the left and right sides of the chart turn into black rectangles. Anyone have this experience or know what to do about this? Please note that I have tried pasting as bitmap, gif, and jpeg but all give the same result.
Code:
ActiveSheet.ChartObjects("Chart 8").Activate
ActiveChart.ChartArea.Select
ActiveChart.CopyPicture Appearance:=xlScreen, _
Size:=xlScreen, Format:= xlPicture
ActiveWindow.Visible = False
Worksheets("ChartImage").Visible = True
Worksheets("ChartImage").Activate
Sheets("ChartImage").Select
Range("F18").Select
ActiveSheet.PasteSpecial Format:="Picture (Enhanced
Metafile)", Link:=False, DisplayAsIcon:=False