AxisGroup Property

AxisGroup property as it applies to the ChartGroup and Series objects.

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

.

XlAxisGroup can be one of these XlAxisGroup constants.
xlPrimary
xlSecondary

expression.AxisGroup

AxisGroup property as it applies to the Axis object.

Returns the group for the specified axis. Read-only

.

XlAxisGroup can be one of these XlAxisGroup constants.
xlPrimary
xlSecondary

expression.AxisGroup

Remarks

For 3-D charts, only xlPrimary is valid.

Example

This example deletes the value axis if it's in the secondary group.

  With myChart.Axes(xlValue)
    If .AxisGroup = xlSecondary Then .Delete
End With