add picture in the background of plot area in ms excel using vb macro

[atiullah]

I want to insert a picture in the background of the plot area in ms excel using visual basic macro...How can it be done..Please help

[Guido Geurs]

@atiullah
dear,

This insert a picture but it's not in the background !!!

Sub Macro1()
'§ insert picture
    ActiveSheet.Pictures.Insert( _
        "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg" _
        ).Select
'§ scale width and height
    Selection.ShapeRange.ScaleWidth 1.91, msoFalse, msoScaleFromTopLeft
    Selection.ShapeRange.ScaleHeight 1.91, msoFalse, msoScaleFromTopLeft
End Sub

This sets a background:

    ActiveSheet.SetBackgroundPicture Filename:= _
        "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Water lilies.jpg"

br,

[atiullah]

'get the backgrund image in plot area
BildName = ActiveWorkbook. Name
BildName = Left(BildName, 9) & Datenblatt.Name & ".jpg"
#If Mac Then
BildName = ActiveWorkbook. Path & ":JPG:" & BildName
#Else
BildName = ActiveWorkbook. Path & "\JPG\" & BildName

#End If
diagramm.PlotAr ea.Fill.UserPic ture PictureFile:=Bi ldName

the last line in the code works on excel 2001 but doesnt work on excel 2003 or 2007. please tell me the replacement of the last line so that it works in excel 2007.< diagramm> is a chart object and <BildName> is the path of picture which has to be inserted..I m really stuck plz help

[QVeen72]

Hi,

I think it is "ChartArea" :

diagramm.ChartA rea.Fill.UserPi cture PictureFile:=Bi ldName

Regards
Veena