Series.PictureUnit2 Property (Excel)

Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored). Read/write Double.

Version Information

Version Added: Excel 2007

Syntax

expression .PictureUnit2

expression A variable that represents a Series object.

Example

This example sets series one in Chart1 to stack pictures and uses each picture to represent five units. The example should be run on a 2-D column chart with picture data markers.

With Charts("Chart1").SeriesCollection(1) 
 .PictureType = xlScale 
 .PictureUnit2 = 5 
End With

See Also

Concepts

Series Object Members

Series Object