Axis.CategoryNames Property (Excel)
Returns or sets all the category names for the specified axis, as a text array. When you set this property, you can set it to either an array or a Range object that contains the category names. Read/write Variant.
Syntax
expression .CategoryNames
expression A variable that represents an Axis object.
Remarks
This property applies only to category axes.
Example
This example sets the category names for Chart1 to the values in cells B1:B5 on Sheet1.
Set Charts("Chart1").Axes(xlCategory).CategoryNames = _
Worksheets("Sheet1").Range("B1:B5")
This example uses an array to set individual category names for Chart1.
Charts("Chart1").Axes(xlCategory).CategoryNames = _
Array ("1985", "1986", "1987", "1988", "1989")