UserPicture Method

Microsoft Graph Visual Basic

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