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 PpAxisType constants: ppValue, ppCategory, or ppSeriesAxis (ppSeriesAxis is valid only for 3-D charts).
AxisGroup Optional PpAxisGroup 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(ppCategory) .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(ppCategory).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: