UserPicture Method

Microsoft Graph Visual Basic

UserPicture Method

       

Fills the specified shape with an image.

expression.UserPicture(PictureFile, PictureFormat, PictureStackUnit, PicturePlacement)

expression   Required. An expression that returns one of the objects in the Applies To list.

PictureFile   Required Variant. The name of the specified picture file.

PictureFormat   Optional XlChartPictureType.  The format of the specified picture.

XlChartPictureType can be one of these XlChartPictureType constants.
xlScale
xlStackScale

xlStack

xlStretch

PictureStackUnit   Optional Variant. The stack or scale unit for the specified picture (depends on the PictureFormat argument).

PicturePlacement   Optional XlChartPicturePlacement.  The placement of the specified picture.

XlChartPicturePlacement can be one of these XlChartPicturePlacement constants.
xlSides
xlEnd

xlEndSides

xlFront

xlFrontSides

xlFrontEnd

xlAllFaces

Example

This example sets the chart's fill format so that it's based on a user-supplied picture.

With myChart.ChartArea.Fill
    .UserPicture PictureFile:="C:\My Documents\brick.bmp"
    .Visible = True
End With