Chart.SeriesNameLevel procedure builder

Chart.SeriesNameLevel (Excel)

Returns an XlSeriesNameLevel constant referring to the level of where the series names are being sourced from.

Possible Values are xlSeriesNameLevelAll, xlSeriesNameLevelCustom - Indicates literal data in the series names, xlSeriesNameLevelNone - Set no category labels in the chart. Defaults to automatic indexed labels.

If there is a hierarchy, 0 refers to the 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.SeriesNameLevel = xlSeriesNameLevelAll