PictureUnit Property [Excel 2003 VBA Language Reference]

  • Article

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 Long.

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
    .PictureUnit = 5
End With

Applies to | LegendKey Object | Point Object | Series Object | Walls Object

See Also | PictureType Property