Returns an object that represents either a single axis or a collection of the axes on the chart.

expression.Axes(Type, AxisGroup)expressionRequired. An expression that returns one of the objects in the Applies To list.Type Optional . 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 . 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