Share via

Axis.MajorUnitScale Property

  • Article
Excel Developer Reference

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

Syntax

expression.MajorUnitScale

expression   A variable that represents an Axis object.

Remarks

XlTimeUnit can be one of these XlTimeUnit constants.
xlMonths
xlDays
xlYears

Example

This example sets the category axis to use a time scale and sets the major and minor units.

Visual Basic for Applications 
  With Charts(1).Axes(xlCategory)
    .CategoryType = xlTimeScale
    .MajorUnit = 5
    .MajorUnitScale = xlDays
    .MinorUnit = 1
    .MinorUnitScale = xlDays
End With

See Also