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