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
base unit is auto Base Unit Is Auto Property baseunit baseunitis BaseUnitIsAuto baseunitisauto property excel set base unit property find out scale category axis automatic turn off automatic setting base unit property

See also: