PictureType Property

Applies To

Floor object, LegendKey object, Point object, Series object, Walls object.

Description

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

Can be one of the following XlPictureType constants.

Value

Description

xlStretch

Stretches the picture to reach the necessary value.

xlStack

Stacks the pictures to reach the necessary value.

xlScale

Stacks the pictures; use the PictureUnit property to determine what unit each picture represents.

xlTile

Tiles the pictures.


See Also

PictureUnit property.

Example

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

myChart.SeriesCollection(1).PictureType = xlStretch