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 either of the following XlAxisGroup constants: xlPrimary or xlSecondary. For more information, see the Axes method.
The following example sets the text of the category axis title in the chart.
With myChart.Axes(xlCategory) .HasTitle = True .AxisTitle.Caption = "1994" End With