PictureType Property

Microsoft Excel Visual Basic

Returns or sets the way pictures are displayed on a column or bar picture chart. Read/write XlChartPictureType.

XlChartPictureType can be one of these XlChartPictureType constants.
xlStack
xlStackScale
xlStretch

expression.PictureType

expression    Required. An expression that returns one of the above objects.

ShowPictureType property as it applies to the LegendKey object.

Returns or sets the way pictures are displayed on a legend key. Read/write Long.

expression.PictureType

expression    Required. An expression that returns one of the above objects.

ShowPictureType property as it applies to the Floor and Walls objects.

Returns or sets the way pictures are displayed on the walls and faces of a 3-D chart. Read/write Variant.

expression.PictureType

expression    Required. An expression that returns one of the above objects.

Example

This example sets series one in Chart1 to stretch pictures. The example should be run on a 2-D column chart with picture data markers.

Charts("Chart1").SeriesCollection(1).PictureType = xlStretch