Axes Method

expression.Axes(Type, AxisGroup)

expression Required. An expression that returns one of the objects in the Applies To list.

Type Optional XlAxisType. Specifies the axis to return. The reference style of the formula.

XlAxisType can be one of these XlAxisType constants.

xlValue

xlCategory

xlSeriesAxis (valid only for 3-D charts)

AxisGroup Optional XlAxisGroup. The reference style of the formula.

XlAxisGroup can be one of these XlAxisGroup constants.

xlPrimary

xlSecondary

If this argument is omitted, the primary group is used. 3-D charts have only one axis group.

Example

This example adds an axis label to the category axis.

With myChart.Axes(xlCategory)
    .HasTitle = True
    .AxisTitle.Text = "July Sales"
End With

This example turns off major gridlines for the category axis.

myChart.Axes(xlCategory).HasMajorGridlines = False

This example turns off all gridlines for all axes.

For Each a In myChart.Axes
    a.HasMajorGridlines = False
    a.HasMinorGridlines = False
Next a