Class ChartCategory (Excel VBA)
Specifies a chart type's category. To use a ChartCategory class variable it first needs to be instantiated, for example
Dim chrc as ChartCategory
Set chrc = ActiveChart.ChartGroups(1).CategoryCollection(Index:=1)
For Each
Here is an example of processing the ChartCategory items in a collection.
Dim chrcCategoryCollection As ChartCategory
For Each chrcCategoryCollection In ActiveChart.ChartGroups(1).CategoryCollection()
Next chrcCategoryCollection
IsFiltered
Returns True when the user filters out a series.
When a series is transferred out of its parent SeriesCollection, that series still remains in its parent FullSeriesCollection. When a user filters the series back in, it is inserted back in its original place in the SeriesCollection.
ActiveChart.ChartGroups(1).CategoryCollection(1).IsFiltered = True
Name
Returns a String value that represents the name of the object.
Dim strName As String
strName = ActiveChart.ChartGroups(1).CategoryCollection(1).Name