Class ChartCategory (PowerPoint VBA)

The class ChartCategory represents all chart categories in the document, whether visible (unfiltered) or not. To use a ChartCategory class variable it first needs to be instantiated, for example


Dim chrc as ChartCategory
Set chrc = ActiveWindow.RangeFromPoint.Chart.ChartGroups(1).CategoryCollection(Index:=1)

IsFiltered

Returns or sets a Boolean that determines whether the specified chart category is filtered out from the chart.


ActiveWindow.RangeFromPoint.Chart.ChartGroups(1).CategoryCollection(1).IsFiltered = True

Name

Returns or sets a String that represents the name of a chart category.


Dim strName As String
strName = ActiveWindow.RangeFromPoint.Chart.ChartGroups(1).CategoryCollection(1).Name