Class Axis (Word VBA)

The class Axis represents a single axis in a chart.

To use a Axis class variable it first needs to be instantiated, for example

Dim axi as Axis
Set axi = ActiveDocument.Background.Chart.Axes(Type:=1)

Axis class variables can be set using the Axes.Item procedure.

For Each

Here is an example of processing the Axis items in a collection.

Dim axi As Axis
For Each axi In ActiveDocument.Background.Chart.Axes()
	
Next axi

Methods

Delete - Deletes the object.

Select - Selects the object.

Properties

AxisBetweenCategories true if the value axis crosses the category axis between categories.

AxisGroup returns the type of axis group.

AxisTitle returns the title of the specified axis.

BaseUnit returns or sets the base unit for the specified category axis.

BaseUnitIsAuto true if Microsoft Word chooses appropriate base units for the specified category axis. The default is True.

Border returns the border of the object.

CategoryNames returns or sets all the category names as a text array for the specified axis.

CategorySortOrder

CategoryType returns or sets the category axis type.

Crosses returns or sets the point on the specified axis where the other axis crosses.

CrossesAt returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis.

DisplayUnit returns or sets the unit label for the value axis.

DisplayUnitCustom if the value of the DisplayUnit property is xlCustom, returns or sets the value of the displayed units.

DisplayUnitLabel returns the DisplayUnitLabel object for the specified axis. Returns null if the HasDisplayUnitLabel property is set to False.

Format returns the line, fill, and effect formatting for the object.

HasDisplayUnitLabel true if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. The default is True.

HasMajorGridlines true if the axis has major gridlines.

HasMinorGridlines true if the axis has minor gridlines.

HasTitle true if the axis or chart has a visible title.

Height returns the height, in points, of the object.

Left returns the distance, in points, from the left edge of the object to the left edge of the chart area.

LogBase returns or sets the base of the logarithm when you are using log scales.

MajorGridlines returns the major gridlines for the specified axis.

MajorTickMark returns or sets the type of major tick mark for the specified axis.

MajorUnit returns or sets the major units for the value axis.

MajorUnitIsAuto true if Microsoft Word calculates the major units for the value axis.

MajorUnitScale returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale.

MaximumScale returns or sets the maximum value on the value axis.

MaximumScaleIsAuto true if Microsoft Word calculates the maximum value for the value axis.

MinimumScale returns or sets the minimum value on the value axis.

MinimumScaleIsAuto true if Microsoft Word calculates the minimum value for the value axis.

MinorGridlines returns the minor gridlines for the specified axis.

MinorTickMark returns or sets the type of minor tick mark for the specified axis.

MinorUnit returns or sets the minor units on the value axis.

MinorUnitIsAuto true if Microsoft Word calculates minor units for the value axis.

MinorUnitScale returns or sets the minor unit scale value for the category axis when the CategoryType property is set to xlTimeScale.

ReversePlotOrder true if Microsoft Word plots data points from last to first.

ScaleType returns or sets the value axis scale type.

TickLabelPosition describes the position of tick-mark labels on the specified axis.

TickLabels returns the tick-mark labels for the specified axis.

TickLabelSpacing returns or sets the number of categories or series between tick-mark labels.

TickLabelSpacingIsAuto returns or sets a value that indicates whether the tick label spacing is automatic.

TickMarkSpacing returns or sets the number of categories or series between tick marks.

Top returns the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).

Type returns the axis type.

Width returns the width, in points, of the object.

AxisTitle - Represents a chart axis title.

ChartBorder - Represents the border of an object.

ChartFormat - Provides access to the OfficeArt formatting for chart elements.

DisplayUnitLabel - Represents a unit label on an axis in the specified chart.

Gridlines - Represents major or minor gridlines on a chart axis.

TickLabels - Represents the tick-mark labels associated with tick marks on a chart axis.