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.



expression A variable that represents an Axis object.


This property applies only to category axes.


This example sets the category names for Chart1 to the values in cells B1:B5 on Sheet1.

Set Charts("Chart1").Axes(xlCategory).CategoryNames = _ 

This example uses an array to set individual category names for Chart1.

Charts("Chart1").Axes(xlCategory).CategoryNames = _ 
 Array ("1985", "1986", "1987", "1988", "1989")

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.