Export (0) Print
Expand All

Axis Object

Office 2007
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



Community Additions

ADD
Show:
© 2014 Microsoft