Share via


ChCategoryLabels Collection Object

ChAxis
ChCategoryLabels
Multiple objects

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

Properties | Item Property | ItemCount Property | LevelCount Property | Parent Property | PivotAxis Property

Parent Objects | ChAxis Object

Child Objects | ChAxis Object | ChCategoryLabel Object | PivotResultGroupAxis Object