This documentation is archived and is not being maintained.

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.

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) _

End Sub