Axes Method [Excel 2003 VBA Language Reference]
Returns an object that represents either a single axis or a collection of the axes on the chart.
expression**.Axes**(Type, AxisGroup)
expression Required. An expression that returns a Chart object.
Type Optional Variant. Specifies the axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3-D charts).
XlAxisGroup
XlAxisGroup can be one of these XlAxisGroup constants. |
xlPrimarydefault |
xlSecondary |
Example
This example adds an axis label to the category axis in Chart1.
With Charts("Chart1").Axes(xlCategory)
.HasTitle = True
.AxisTitle.Text = "July Sales"
End With
This example turns off major gridlines for the category axis in Chart1.
Charts("Chart1").Axes(xlCategory).HasMajorGridlines = False
This example turns off all gridlines for all axes in Chart1.
For Each a In Charts("Chart1").Axes
a.HasMajorGridlines = False
a.HasMinorGridlines = False
Next a
Applies to | Chart Object