ChCategoryLabels Collection Object
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
ChAxis ChCategoryLabels |
Represents a collection of all the **ChCategoryLabel**objects for the specified category axis.
Using the ChCategoryLabels Collection Object
Use the CategoryLabels property of the ChAxis object to return a ChCategoryLabels collection. The following example displays the number of labels for the category axis on the first chart in Chartspace1.
Sub DisplayItemCount
Dim chtChart1
Dim chConstants
Set chConstants = Chartspace1.Constants
Set chtChart1 = Chartspace1.Charts(0)
MsgBox chChart1.Axes(chConstants.chAxisPositionCategory) _
.CategoryLabels.ItemCount
End Sub