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