Axis.MajorUnitScale (Excel)

Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Possible return values are xlDays - Days, xlMonths - Months, xlYears - Years.

XlTimeUnit can be one of the XlTimeUnit constants.

ActiveChart.Axes(1).MajorUnitScale = xlDays