PictureType Property

Applies To

Point Object, Series Object.

Description

Returns or sets how pictures are displayed on a column or bar picture chart, as shown in the following table. Applies only to column and bar picture charts. Read-write.

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.


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