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

Meaning

xlStretch

Stretch the picture to reach the necessary value.

xlStack

Stack the pictures to reach the necessary value.

xlScale

Stack the pictures, but use the PictureUnit property to determine what unit each picture represents.

xlTile

Tile the pictures.


See Also

PictureUnit property.

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