Axis Object Members
Represents a single axis in a chart.
Methods
| Name | Description | |
|---|---|---|
.gif "Ee409195.methods(en-us,office.12).gif") |
Delete | Deletes the object. |
|
Select | Selects the object. |
Properties
| Name | Description | |
|---|---|---|
.gif "Ee409195.properties(en-us,office.12).gif") |
Application | When used without an object qualifier, returns an Application object that represents the Microsoft Word application. When used with an object qualifier, returns an Application object that represents the creator of the specified object (you can use this property with an Automation object to return the application of that object). Read-only. |
|
AxisBetweenCategories | True if the value axis crosses the category axis between categories. Read/write Boolean. |
|
AxisGroup | Returns the type of axis group. Read-only XlAxisGroup. |
|
AxisTitle | Returns the title of the specified axis. Read-only AxisTitle. |
|
BaseUnit | Returns or sets the base unit for the specified category axis. Read/write XlTimeUnit. |
|
BaseUnitIsAuto | True if Microsoft Word chooses appropriate base units for the specified category axis. The default is True. Read/write Boolean. |
|
Border | Returns the border of the object. Read-only ChartBorder. |
|
CategoryNames | Returns or sets all the category names as a text array for the specified axis. Read/write Variant. |
|
CategoryType | Returns or sets the category axis type. Read/write XlCategoryType. |
|
Creator | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
|
Crosses | Returns or sets the point on the specified axis where the other axis crosses. Read/write Long. |
|
CrossesAt | Returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis. Read/write Double. |
|
DisplayUnit | Returns or sets the unit label for the value axis. Read/write XlDisplayUnit, xlCustom, or xlNone. |
|
DisplayUnitCustom | If the value of the DisplayUnit property is xlCustom, returns or sets the value of the displayed units. Read/write Double. |
|
DisplayUnitLabel | Returns the DisplayUnitLabel object for the specified axis. Returns null if the HasDisplayUnitLabel property is set to False. Read-only. |
|
Format | Returns the line, fill, and effect formatting for the object. Read-only ChartFormat. |
|
HasDisplayUnitLabel | True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. The default is True. Read/write Boolean. |
|
HasMajorGridlines | True if the axis has major gridlines. Read/write Boolean. |
|
HasMinorGridlines | True if the axis has minor gridlines. Read/write Boolean. |
|
HasTitle | True if the axis or chart has a visible title. Read/write Boolean. |
|
Height | Returns the height, in points, of the object. Read-only Double. |
|
Left | Returns the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only Double. |
|
LogBase | Returns or sets the base of the logarithm when you are using log scales. Read/write Double. |
|
MajorGridlines | Returns the major gridlines for the specified axis. Read-only Gridlines. |
|
MajorTickMark | Returns or sets the type of major tick mark for the specified axis. Read/write XlTickMark. |
|
MajorUnit | Returns or sets the major units for the value axis. Read/write Double. |
|
MajorUnitIsAuto | True if Microsoft Word calculates the major units for the value axis. Read/write Boolean. |
|
MajorUnitScale | Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit. |
|
MaximumScale | Returns or sets the maximum value on the value axis. Read/write Double. |
|
MaximumScaleIsAuto | True if Microsoft Word calculates the maximum value for the value axis. Read/write Boolean. |
|
MinimumScale | Returns or sets the minimum value on the value axis. Read/write Double. |
|
MinimumScaleIsAuto | True if Microsoft Word calculates the minimum value for the value axis. Read/write Boolean. |
|
MinorGridlines | Returns the minor gridlines for the specified axis. Read-only Gridlines. |
|
MinorTickMark | Returns or sets the type of minor tick mark for the specified axis. Read/write XlTickMark. |
|
MinorUnit | Returns or sets the minor units on the value axis. Read/write Double. |
|
MinorUnitIsAuto | True if Microsoft Word calculates minor units for the value axis. Read/write Boolean. |
|
MinorUnitScale | Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit. |
|
Parent | Returns the parent for the specified object. Read-only Object. |
|
ReversePlotOrder | True if Microsoft Word plots data points from last to first. Read/write Boolean. |
|
ScaleType | Returns or sets the value axis scale type. Read/write XlScaleType. |
|
TickLabelPosition | Describes the position of tick-mark labels on the specified axis. Read/write XlTickLabelPosition. |
|
TickLabels | Returns the tick-mark labels for the specified axis. Read-only TickLabels. |
|
TickLabelSpacing | Returns or sets the number of categories or series between tick-mark labels. Read/write Long. |
|
TickLabelSpacingIsAuto | Returns or sets a value that indicates whether the tick label spacing is automatic. Read/write Boolean. |
|
TickMarkSpacing | Returns or sets the number of categories or series between tick marks. Read/write Long. |
|
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). Read-only Double. |
|
Type | Returns the axis type. Read-only XlAxisType. |
|
Width | Returns the width, in points, of the object. Read-only Double. |