DataLabel.VerticalAlignment (Excel)

Returns or sets a value that represents the vertical alignment of the specified object. Possible return values are xlVAlignBottom - Bottom, xlVAlignCenter - Center, xlVAlignDistributed - Distributed, xlVAlignJustify - Justify, xlVAlignTop - Top.

The value of this property can be set to one of the XlVAlign constants.

ActiveCell.Width(1).DataLabel.VerticalAlignment = xlVAlignBottom