TickLabels.Orientation (Excel)
Returns or sets a Long value that represents the text orientation. Possible return values are xlTickLabelOrientationAutomatic - Text orientation set by Excel, xlTickLabelOrientationDownward - Text runs down, xlTickLabelOrientationHorizontal - Characters run horizontally, xlTickLabelOrientationUpward - Text runs up, xlTickLabelOrientationVertical - Characters run vertically.
The value of this property can be set to an integer value from -90 to 90 degrees or to one of the XlTickLabelOrientation constants.
ActiveChart.Axes(1).TickLabels.Orientation = xlTickLabelOrientationAutomatic