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