Axis.MajorUnitScale procedure builder

Axis.MajorUnitScale (Excel)

Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale.

xlDays - Days, xlMonths - Months, xlYears - Years.

XlTimeUnit can be one of the XlTimeUnit constants.

ActiveChart.Axes(1).MajorUnitScale = xlDays