Chart.Axes Method

  • Article
Excel Developer Reference

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

Syntax

expression.Axes(Type, AxisGroup)

expression   A variable that represents a Chart object.

Parameters

Name Required/Optional Data Type Description
Type Optional Variant Specifies the axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3-D charts).
AxisGroup Optional XlAxisGroup Specifies the axis group. If this argument is omitted, the primary group is used. 3-D charts have only one axis group.

Return Value
Object

Example

This example adds an axis label to the category axis in Chart1.

Visual Basic for Applications 
  With Charts("Chart1").Axes(xlCategory)
    .HasTitle = True
    .AxisTitle.Text = "July Sales"
End With

This example turns off major gridlines for the category axis in Chart1.

Visual Basic for Applications 
  Charts("Chart1").Axes(xlCategory).HasMajorGridlines = False

This example turns off all gridlines for all axes in Chart1.

Visual Basic for Applications 
  For Each a In Charts("Chart1").Axes
    a.HasMajorGridlines = False
    a.HasMinorGridlines = False
Next a

See Also