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,
xlSeries, or
xlValue.
Group | can be one of the following
XlAxisGroup constants:
xlPrimary or
xlSecondary. For more information, see the
Axes method.
Example
The following example sets the category axis title text on the chart sheet named "Chart1."
| Visual Basic for Applications |
|---|
With Charts("chart1").Axes(xlCategory)
.HasTitle = True
.AxisTitle.Caption = "1994"
End With
|
