Axis Object

Description

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, 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.