Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart axis titles turn to black rectangles when converted to picture.

Status
Not open for further replies.

bdbBear

Programmer
Apr 29, 2005
54
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top