AxisGroup Property

Microsoft Excel Visual Basic

Returns the group for the specified chart group or series. Read/write XlAxisGroup.

XlAxisGroup can be one of these XlAxisGroup constants.
xlPrimary
xlSecondary

expression.AxisGroup

expression    Required. An expression that returns one of the above objects.

ShowAxisGroup property as it applies to the Axis object.

Returns the group for the specified axis. Read-only XlAxisGroup.

XlAxisGroup can be one of these XlAxisGroup constants.
xlPrimary
xlSecondary

expression.AxisGroup

expression    Required. An expression that returns one of the above objects.

Remarks

For 3-D charts, only xlPrimary is valid.

Example

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

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