Axis Object [Excel 2003 VBA Language Reference]

Axes Axis 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

Properties | Application Property | AxisBetweenCategories Property | AxisGroup Property | AxisTitle Property | BaseUnit Property | BaseUnitIsAuto Property | Border Property | CategoryNames Property | CategoryType Property | Creator Property | Crosses Property | CrossesAt Property | DisplayUnit Property | DisplayUnitCustom Property | DisplayUnitLabel Property | HasDisplayUnitLabel Property | HasMajorGridlines Property | HasMinorGridlines Property | HasTitle Property | Height Property | Left Property | MajorGridlines Property | MajorTickMark Property | MajorUnit Property | MajorUnitIsAuto Property | MajorUnitScale Property | MaximumScale Property | MaximumScaleIsAuto Property | MinimumScale Property | MinimumScaleIsAuto Property | MinorGridlines Property | MinorTickMark Property | MinorUnit Property | MinorUnitIsAuto Property | MinorUnitScale Property | Parent Property | ReversePlotOrder Property | ScaleType Property | TickLabelPosition Property | TickLabels Property | TickLabelSpacing Property | TickMarkSpacing Property | Top Property | Type Property | Width Property

Methods | Delete Method | Select Method

Parent Objects

Child Objects | AxisTitle Object | Border Object | DisplayUnitLabel Object | Gridlines Object | TickLabels Object