AxesAxis
Multiple objects
Represents a single axis in a chart. The Axis object is a member of the Axes collection.
Using the Axis Object
Use Axes(type, group) where type is the axis type and group is the axis group to return a single Axis object. Type can be one of the following XlAxisType constants: xlCategory, xlSeries, or xlValue. Group can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. For more information, see the Axes method.
The following example sets the category axis title text on the chart sheet named "Chart1."
With Charts("chart1").Axes(xlCategory)
.HasTitle = True
.AxisTitle.Caption = "1994"
End With