Chart.Axes (Excel)

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

Axes (Type, AxisGroup)

Dim axs As Axes
Set axs = ActiveChart.Axes()

Arguments

Optional arguments

The following arguments are optional

Type (XlAxisType) - Specifies the axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3D charts).

Possible return values are xlCategory - Axis displays categories, xlSeriesAxis - Axis displays data series, xlValue - Axis displays values.

AxisGroup (XlAxisGroup) - Specifies the axis group. If this argument is omitted, the primary group is used. 3D charts have only one axis group.

Possible return values are xlPrimary - Primary axis group, xlSecondary - Secondary axis group.