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