Share via

Axis.BaseUnitIsAuto Property

  • Article
Excel Developer Reference

True if Microsoft Excel chooses appropriate base units for the specified category axis. The default value is True. Read/write Boolean.

Syntax

expression.BaseUnitIsAuto

expression   A variable that represents an Axis object.

Remarks

You cannot set this property for a value axis.

Example

This example sets the category axis in embedded chart one on worksheet one to use a time scale with automatic base units.

Visual Basic for Applications 
  With Worksheets(1).ChartObjects(1).Chart
    With .Axes(xlCategory)
        .CategoryType = xlTimeScale
        .BaseUnitIsAuto = True
    End With
End With

See Also