Rediger

Del via

Series.PictureUnit2 property (Excel)

  • Artikkel

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.

Syntax

expression.PictureUnit2

expression A variable that represents a Series object.

Example

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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.