Axis object (Excel)
Represents a single axis in a chart.
Remarks
The Axis object is a member of the Axes collection.
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, xlSeriesAxis, or xlValue.
Group can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary.
For more information, see the Axes method of the Chart object.
Example
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
Methods
Properties
- Application
- AxisBetweenCategories
- AxisGroup
- AxisTitle
- BaseUnit
- BaseUnitIsAuto
- Border
- CategoryNames
- CategoryType
- Creator
- Crosses
- CrossesAt
- DisplayUnit
- DisplayUnitCustom
- DisplayUnitLabel
- Format
- HasDisplayUnitLabel
- HasMajorGridlines
- HasMinorGridlines
- HasTitle
- Height
- Left
- LogBase
- MajorGridlines
- MajorTickMark
- MajorUnit
- MajorUnitIsAuto
- MajorUnitScale
- MaximumScale
- MaximumScaleIsAuto
- MinimumScale
- MinimumScaleIsAuto
- MinorGridlines
- MinorTickMark
- MinorUnit
- MinorUnitIsAuto
- MinorUnitScale
- Parent
- ReversePlotOrder
- ScaleType
- TickLabelPosition
- TickLabels
- TickLabelSpacing
- TickLabelSpacingIsAuto
- TickMarkSpacing
- Top
- Type
- Width
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.