AxisGroup Property

Microsoft Graph Visual Basic

Show All

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.

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.

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

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