Process chart by looping through Chart CategoryCollection

Hi everyone.
I need to process charts by looping through the CategoryCollection and reading the associated labels.
I know how to do this for a series, but I can't work out how to get the label from the category.

Every example I've found online works from the series object, but this doesn't help me to filter the categories.

Please Login or Register  to view this content.

EDIT
I've now posted this on another forum at
http://www.vbaexpress.com/forum/show...-x-axis-labels

Here are a couple of ways

Please Login or Register  to view this content.

Hi Andy,

Those are both nice ways to be able to loop through the category names.
But the first one is accessing the text via the Chart.Axes method.
The second one is accessing the text via the Series.XValues property.

Neither has a reference to the category or CategoryCollection objects, so how could I do anything with it? I need to get to this line:

Please Login or Register  to view this content.

You mentioned Labels not IsFiltered

Please Login or Register  to view this content.

Originally Posted by Andy Pope

You mentioned Labels not IsFiltered

I did mention several times that my aim was to work with a reference to the category object. I only mentioned .IsFiltered as an example of using the category object, as was shown in my original code.

Originally Posted by Andy Pope

Please Login or Register  to view this content.

.Name is not a property of the Category object, and is thus not a method available to the FullCategoryCollection

https://docs.microsoft.com/en-us/off....chartcategory
https://docs.microsoft.com/en-us/off...gorycollection

So I figure that there has to be a way to step back through the parent objects from the label to the category or vice versa. But I can't work it out.