Axis.CategoryType Property

Syntax

expression.CategoryType

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 months as the base unit.

With Worksheets(1).ChartObjects(1).Chart With .Axes(xlCategory) .CategoryType = xlTimeScale .BaseUnit = xlMonths End With End With

See also:

• Axis Object
• Axis Object Members
• BaseUnit Property
• BaseUnitIsAuto Property
• MajorUnitScale Property
• MinorUnitScale Property