Excel.PictureUnit.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PictureUnit property (Excel Graph)	vbagr10.chm3077575	vbagr10.chm3077575	Excel.PictureUnit	28a7cd8b-2558-87a1-158f-ff9a1dca8f41	04/11/2019	medium

PictureUnit property (Excel Graph)

Returns or sets the unit for each picture on the chart if the PictureType property is set to xlScale (otherwise, this property is ignored). Read/write Long for all objects, except for the Walls object, which is read/write Variant.

Syntax

expression.PictureUnit

expression Required. An expression that returns one of the above objects.

Example

This example sets series one 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 myChart.SeriesCollection(1) 
 .PictureType = xlScale 
 .PictureUnit = 5 
End With

[!includeSupport and feedback]