Share via

Series.PictureUnit2 Property

  • Article
Excel Developer Reference

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.

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

See Also