Chart.CategoryLabelLevel (Excel)

Returns an XlCategoryLabelLevel constant referring to the level of where the category labels are being sourced from. Possible return values are xlCategoryLabelLevelAll, xlCategoryLabelLevelCustom - Indicates literal data in the category labels, xlCategoryLabelLevelNone - Set no category labels in the chart. Defaults to automatic indexed labels.

If there is a hierarchy, 0 refers to the most parent level, 1 refers to its children, and so on. So, 0 equals the first level, 1 equals the second level, 2 equals the third level, and so on.

ActiveChart.CategoryLabelLevel = xlCategoryLabelLevelAll