Export (0) Print
Expand All

Axis Properties 

  Name Description
Application Returns an Application object that represents the Microsoft Excel application.
AxisBetweenCategories True if the value axis crosses the category axis between categories.
AxisGroup Returns the group for the specified axis.
AxisTitle Returns an AxisTitle object that represents the title of the specified axis.
BaseUnit Returns or sets the base unit for the specified category axis.
BaseUnitIsAuto True if Microsoft Excel chooses appropriate base units for the specified category axis. The default value is True.
Border Returns a Border object that represents the border of the object.
CategoryNames Returns or sets all the category names for the specified axis as a text array.
CategoryType Returns or sets the category axis type.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
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, the DisplayUnitCustom property returns or sets the value of the displayed units. The value must be from 0 through 10E307.
DisplayUnitLabel Returns the DisplayUnitLabel object for the specified axis. Returns Null if the HasDisplayUnitLabel property is set to False.
HasDisplayUnitLabel True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. The default value is True.
HasMajorGridlines True if the axis has major gridlines. Only axes in the primary axis group can have gridlines.
HasMinorGridlines True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines.
HasTitle True if the axis or chart has a visible title.
Height The height, in points, of the object.
Left The distance, in points, from the left edge of the object to the left edge of the chart area.
MajorGridlines Returns a Gridlines object that represents the major gridlines for the specified axis. Only axes in the primary axis group can have gridlines.
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 Excel 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 Excel calculates the maximum value for the value axis.
MinimumScale Returns or sets the minimum value on the value axis.
MinimumScaleIsAuto True if Microsoft Excel calculates the minimum value for the value axis.
MinorGridlines Returns a Gridlines object that represents the minor gridlines for the specified axis. Only axes in the primary axis group can have gridlines.
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 Excel 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.
Parent Returns the parent object for the specified object.
ReversePlotOrder True if Microsoft Excel 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 a TickLabels object that represents the tick-mark labels for the specified axis.
TickLabelSpacing Returns or sets the number of categories or series between tick-mark labels. Applies only to category and series axes.
TickMarkSpacing Returns or sets the number of categories or series between tick marks. Applies only to category and series axes.
Top 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 The width, in points, of the object.

Community Additions

ADD
Show:
© 2014 Microsoft