Axes![]() ![]() ![]() ![]() ![]() |
A collection of all the Axis objects in the specified chart.
Use the Axes method to return the Axes collection. The following example displays the number of axes in the chart.
With myChart
MsgBox .Axes.Count
End With
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.
XlAxisType can be one of these XlAxisType constants. |
xlCategory |
xlSeries
xlValue |
Group can be either of the following XlAxisGroup constants: xlPrimary or xlSecondary. For more information, see the Axes method.
The following example sets the title text for the category axis.
With myChart.Axes(xlCategory)
.HasTitle = True
.AxisTitle.Caption = "1994"
End With