PictureType Property

Microsoft Excel Visual Basic

PictureType Property

       

PictureType property as it applies to the Point and Series objects.

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.

 

PictureType 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.

 

PictureType 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