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.
ChAxis
Aa198380.parchild(en-us,office.10).gifChCategoryLabels
Aa198380.space(en-us,office.10).gifAa198380.parchild(en-us,office.10).gif

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

 

Show: