Axis.MinorUnitScale (Excel)

Returns or sets the minor 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).MinorUnitScale = xlDays