XlCategoryType can be one of these XlCategoryType constants. |
xlCategoryScale |
xlAutomaticScale |
xlTimeScale |
expression.CategoryType
expression Required. An expression that returns one of the objects in the Applies To list.
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