Tandaan
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o baguhin ang mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
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")
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.