Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Axis Object Members

Office 2007

Represents a single axis in a chart.

Methods

 NameDescription
Bb255843.methods(en-us,office.12).gif Delete Deletes the object.
Bb255843.methods(en-us,office.12).gif Select Selects the object.

Properties

 NameDescription
Bb255843.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel 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.
Bb255843.properties(en-us,office.12).gif AxisBetweenCategories True if the value axis crosses the category axis between categories. Read/write Boolean.
Bb255843.properties(en-us,office.12).gifAxisGroupReturns an XlAxisGroup value that represents the type of axis group.
Bb255843.properties(en-us,office.12).gif AxisTitle Returns an AxisTitle object that represents the title of the specified axis. Read-only.
Bb255843.properties(en-us,office.12).gif BaseUnit Returns or sets the base unit for the specified category axis. Read/write XlTimeUnit.
Bb255843.properties(en-us,office.12).gif BaseUnitIsAuto True if Microsoft Excel chooses appropriate base units for the specified category axis. The default value is True. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif Border Returns a Border object that represents the border of the object.
Bb255843.properties(en-us,office.12).gif CategoryNames Returns or sets all the category names for the specified axis, as a text array. When you set this property, you can set it to either an array or a Range object that contains the category names. Read/write Variant.
Bb255843.properties(en-us,office.12).gif CategoryType Returns or sets the category axis type. Read/write XlCategoryType.
Bb255843.properties(en-us,office.12).gif Crosses Returns or sets the point on the specified axis where the other axis crosses. Read/write Long.
Bb255843.properties(en-us,office.12).gif 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.
Bb255843.properties(en-us,office.12).gif DisplayUnit Returns or sets the unit label for the value axis. Read/write XlDisplayUnit, xlCustom, or xlNone.
Bb255843.properties(en-us,office.12).gif 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. Read/write Double.
Bb255843.properties(en-us,office.12).gif DisplayUnitLabel Returns the DisplayUnitLabel object for the specified axis. Returns null if the HasDisplayUnitLabel property is set to False. Read-only.
Bb255843.properties(en-us,office.12).gif Format Read-only
Bb255843.properties(en-us,office.12).gif 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 Boolean.
Bb255843.properties(en-us,office.12).gif HasMajorGridlines True if the axis has major gridlines. Only axes in the primary axis group can have gridlines. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif HasMinorGridlines True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif HasTitle True if the axis or chart has a visible title. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif Height Returns a Double value that represents the height, in points, of the object.
Bb255843.properties(en-us,office.12).gif Left Returns a Double value that represents the distance, in points, from the left edge of the object to the left edge of the chart area.
Bb255843.properties(en-us,office.12).gif LogBase Read/write
Bb255843.properties(en-us,office.12).gif MajorGridlines Returns a Gridlines object that represents the major gridlines for the specified axis. Only axes in the primary axis group can have gridlines. Read-only.
Bb255843.properties(en-us,office.12).gif MajorTickMark Returns or sets the type of major tick mark for the specified axis. Read/write XlTickMark.
Bb255843.properties(en-us,office.12).gif MajorUnit Returns or sets the major units for the value axis. Read/write Double.
Bb255843.properties(en-us,office.12).gif MajorUnitIsAuto True if Microsoft Excel calculates the major units for the value axis. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif MajorUnitScale Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.
Bb255843.properties(en-us,office.12).gif MaximumScale Returns or sets the maximum value on the value axis. Read/write Double.
Bb255843.properties(en-us,office.12).gif MaximumScaleIsAuto True if Microsoft Excel calculates the maximum value for the value axis. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif MinimumScale Returns or sets the minimum value on the value axis. Read/write Double.
Bb255843.properties(en-us,office.12).gif MinimumScaleIsAuto True if Microsoft Excel calculates the minimum value for the value axis. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif MinorGridlines Returns a Gridlines object that represents the minor gridlines for the specified axis. Only axes in the primary axis group can have gridlines. Read-only.
Bb255843.properties(en-us,office.12).gif MinorTickMark Returns or sets the type of minor tick mark for the specified axis. Read/write XlTickMark.
Bb255843.properties(en-us,office.12).gif MinorUnit Returns or sets the minor units on the value axis. Read/write Double.
Bb255843.properties(en-us,office.12).gif MinorUnitIsAuto True if Microsoft Excel calculates minor units for the value axis. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif MinorUnitScale Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.
Bb255843.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255843.properties(en-us,office.12).gif ReversePlotOrder True if Microsoft Excel plots data points from last to first. Read/write Boolean.
Bb255843.properties(en-us,office.12).gif ScaleType Returns or sets the value axis scale type. Read/write XlScaleType.
Bb255843.properties(en-us,office.12).gif TickLabelPosition Describes the position of tick-mark labels on the specified axis. Read/write XlTickLabelPosition.
Bb255843.properties(en-us,office.12).gif TickLabels Returns a TickLabels object that represents the tick-mark labels for the specified axis. Read-only.
Bb255843.properties(en-us,office.12).gif 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 Long.
Bb255843.properties(en-us,office.12).gif TickLabelSpacingIsAuto Read/write
Bb255843.properties(en-us,office.12).gif 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 Long.
Bb255843.properties(en-us,office.12).gif Top Returns a Double value that represents 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).
Bb255843.properties(en-us,office.12).gif Type Returns an XlAxisType value that represents the Axis type.
Bb255843.properties(en-us,office.12).gif Width Returns a Double value that represents the width, in points, of the object.


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.