Expand Minimize

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.

For 3-D charts, only xlPrimary is valid.

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

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

Community Additions

ADD
Show:
© 2014 Microsoft