Axis Properties

The Axis type exposes the following members.

  NameDescription
Public property Application When used without an object qualifier, this property returns an _Application object that represents the Microsoft Word application. When used with an object qualifier, this property returns an _Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Public property AxisBetweenCategories True if the value axis crosses the category axis between categories. Read/write.
Public property AxisGroup Returns the type of axis group. Read-only.
Public property AxisTitle Returns the title of the specified axis. Read-only.
Public property BaseUnit Returns or sets the base unit for the specified category axis. Read/write.
Public property BaseUnitIsAuto True if Microsoft Word chooses appropriate base units for the specified category axis. The default value is True. Read/write.
Public property Border Returns the border of the object. Read-only.
Public property CategoryNames Returns or sets all the category names for the specified axis, as a text array. Read/write.
Public property CategoryType Returns or sets the category axis type. Read/write.
Public property Creator Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only.
Public property Crosses Returns or sets the point on the specified axis where the other axis crosses. Read/write.
Public property CrossesAt Returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis. Read/write.
Public property DisplayUnit Returns or sets the unit label for the value axis. Read/write.
Public property DisplayUnitCustom If the value of the DisplayUnit property is XlConstants.xlCustom, the DisplayUnitCustom property returns or sets the value of the displayed units. The value must be from 0 through 10E307. Read/write.
Public property DisplayUnitLabel Returns the DisplayUnitLabel object for the specified axis. Returns Nothing if the HasDisplayUnitLabel property is set to False. Read-only.
Public property Format Returns the line, fill, and effect formatting for the object. Read-only.
Public property HasDisplayUnitLabel True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. The default value is True. Read/write.
Public property HasMajorGridlines True if the axis has major gridlines. Only axes in the primary axis group can have gridlines. Read/write.
Public property HasMinorGridlines True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines. Read/write.
Public property HasTitle True if the axis or chart has a visible title. Read/write.
Public property Height Returns the height, in points, of the object.
Public property Left Returns the distance, in points, from the left edge of the object to the left edge of the chart area.
Public property LogBase Returns or sets the base of the logarithm when you are using log scales. Read/write.
Public property MajorGridlines Returns the major gridlines for the specified axis. Only axes in the primary axis group can have gridlines. Read-only.
Public property MajorTickMark Returns or sets the type of major tick mark for the specified axis. Read/write XlTickMark.
Public property MajorUnit Returns or sets the major units for the value axis. Read/write.
Public property MajorUnitIsAuto True if Microsoft Word calculates the major units for the value axis. Read/write.
Public property MajorUnitScale Returns or sets the major unit scale value for the category axis when the CategoryType property is set to XlCategoryType.xlTimeScale. Read/write.
Public property MaximumScale Returns or sets the maximum value on the value axis. Read/write.
Public property MaximumScaleIsAuto True if Microsoft Word calculates the maximum value for the value axis. Read/write.
Public property MinimumScale Returns or sets the minimum value on the value axis. Read/write.
Public property MinimumScaleIsAuto True if Microsoft Word calculates the minimum value for the value axis. Read/write.
Public property MinorGridlines Returns the minor gridlines for the specified axis. Only axes in the primary axis group can have gridlines. Read-only.
Public property MinorTickMark Returns or sets the type of minor tick mark for the specified axis. Read/write.
Public property MinorUnit Returns or sets the minor units on the value axis. Read/write.
Public property MinorUnitIsAuto True if Microsoft Word calculates minor units for the value axis. Read/write.
Public property MinorUnitScale Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to XlCategoryType.xlTimeScale. Read/write.
Public property Parent Returns the parent for the specified object. Read-only.
Public property ReversePlotOrder True if Microsoft Word plots data points from last to first. Read/write.
Public property ScaleType Returns or sets the value axis scale type. Read/write.
Public property TickLabelPosition Describes the position of tick-mark labels on the specified axis. Read/write.
Public property TickLabels Returns the tick-mark labels for the specified axis. Read-only.
Public property TickLabelSpacing Returns or sets the number of categories or series between tick-mark labels. Applies only to category and series axes. Can be a value from 1 through 31999. Read/write.
Public property TickLabelSpacingIsAuto Returns or sets whether or not the tick label spacing is automatic. Read/write.
Public property TickMarkSpacing Returns or sets the number of categories or series between tick marks. Applies only to category and series axes. Can be a value from 1 through 31999. Read/write.
Public property 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).
Public property Type Returns the axis type.
Public property Width Returns the width, in points, of the object.
Top

Community Additions

ADD
Show:
© 2014 Microsoft