DisplayUnitLabel.HorizontalAlignment (Excel)
Returns or sets a value that represents the horizontal alignment for the specified object. Possible return values are xlHAlignCenter - Center, xlHAlignCenterAcrossSelection - Center across selection, xlHAlignDistributed - Distribute, xlHAlignFill - Fill, xlHAlignGeneral - Align according to data type, xlHAlignJustify - Justify, xlHAlignLeft - Left, xlHAlignRight - Right.
The value of this property can be set to one of the XlHAlign constants. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed.
ActiveChart.Axes(1).DisplayUnitLabel.HorizontalAlignment = xlHAlignCenter