AxisGroup Property
From Microsoft Excel Visual Basic
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 in Chart1 if the axis is in the secondary group.
With Charts("Chart1").Axes(xlValue)
If .AxisGroup = xlSecondary Then .Delete
End With