AxisGroup Property

Applies To

Axis object, ChartGroup object, Series object.

Description

Returns the group for the specified axis, chart group, or series. Can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. Read/write Long for Series; read-only Long for Axis and ChartGroup.

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