The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Series.PictureUnit2 Property

Office 2007
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



expression   A variable that represents a Series object.


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.

Visual Basic for Applications
With Charts("Chart1").SeriesCollection(1)
    .PictureType = xlScale
    .PictureUnit2 = 5
End With

Community Additions