AxisGroup Property

  • Article

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

XlAxisGroup

XlAxisGroup can be one of these XlAxisGroup constants.
xlPrimary
xlSecondary

expression.AxisGroup

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

AxisGroup property as it applies to the Axis object.

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 if it's in the secondary group.

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

Applies to | Axis Object | ChartGroup Object | Series Object