AxisGroup Property

Applies To

Axis Object, ChartGroup Object, Series Object.

Description

Returns the group (either xlPrimary or xlSecondary) for the specified axis, chart group, or series. Read-write for Series; read-only for Axis and ChartGroup.

Remarks

For 3-D charts, only xlPrimary is valid.

Example

This example deletes the value axis in Chart1 if it is in the secondary group.

With Charts("Chart1").Axes(xlValue)
    If .AxisGroup = xlSecondary Then .Delete
End With