Axis object (Excel Graph)

Represents a single axis in a chart. The Axis object is a member of the Axes collection.

Remarks

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 either of the following XlAxisGroup constants: xlPrimary or xlSecondary.

Example

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

See also

• Excel Graph Visual Basic Reference
• Excel Object Model Reference

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.