Axis Axis Axis Interface

Definition

Represents a single axis in a chart.

public interface class Axis
[System.Runtime.InteropServices.Guid("00020848-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Axis
Public Interface Axis
Attributes

Remarks

The Axis object is a member of the Axes collection.

Use Axes(type, group) where type is the axis type and group is the axis group to return a single Axis object. Type can be one of the following ff constants: xlCategory, xlSeries, or xlValue. Group can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. For more information, see the Axes(Object, XlAxisGroup) method.

Properties

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

AxisBetweenCategories AxisBetweenCategories AxisBetweenCategories

True if the value axis crosses the category axis between categories.

AxisGroup AxisGroup AxisGroup

Returns the group for the specified axis.

AxisTitle AxisTitle AxisTitle

Returns an AxisTitle object that represents the title of the specified axis.

BaseUnit BaseUnit BaseUnit

Returns or sets the base unit for the specified category axis.

BaseUnitIsAuto BaseUnitIsAuto BaseUnitIsAuto

True if Microsoft Excel chooses appropriate base units for the specified category axis. The default value is True.

Border Border Border

Returns a Border object that represents the border of the object.

CategoryNames CategoryNames CategoryNames

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

CategoryType CategoryType CategoryType

Returns or sets the category axis type.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Crosses Crosses Crosses

Returns or sets the point on the specified axis where the other axis crosses.

CrossesAt CrossesAt CrossesAt

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

DisplayUnit DisplayUnit DisplayUnit

Returns or sets the unit label for the value axis.

DisplayUnitCustom DisplayUnitCustom 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 DisplayUnitLabel DisplayUnitLabel

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

Format Format Format

Returns the ChartFormat object. Read-only.

HasDisplayUnitLabel HasDisplayUnitLabel HasDisplayUnitLabel

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

HasMajorGridlines HasMajorGridlines HasMajorGridlines

True if the axis has major gridlines. Only axes in the primary axis group can have gridlines.

HasMinorGridlines HasMinorGridlines HasMinorGridlines

True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines.

HasTitle HasTitle HasTitle

True if the axis or chart has a visible title.

Height Height Height

The height, in points, of the object.

Left Left Left

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

LogBase LogBase LogBase

Returns or sets the base of the logarithm when you are using log scales. Read/write Double.

MajorGridlines MajorGridlines 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 MajorTickMark MajorTickMark

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

MajorUnit MajorUnit MajorUnit

Returns or sets the major units for the value axis.

MajorUnitIsAuto MajorUnitIsAuto MajorUnitIsAuto

True if Microsoft Excel calculates the major units for the value axis.

MajorUnitScale MajorUnitScale MajorUnitScale

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

MaximumScale MaximumScale MaximumScale

Returns or sets the maximum value on the value axis.

MaximumScaleIsAuto MaximumScaleIsAuto MaximumScaleIsAuto

True if Microsoft Excel calculates the maximum value for the value axis.

MinimumScale MinimumScale MinimumScale

Returns or sets the minimum value on the value axis.

MinimumScaleIsAuto MinimumScaleIsAuto MinimumScaleIsAuto

True if Microsoft Excel calculates the minimum value for the value axis.

MinorGridlines MinorGridlines 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 MinorTickMark MinorTickMark

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

MinorUnit MinorUnit MinorUnit

Returns or sets the minor units on the value axis.

MinorUnitIsAuto MinorUnitIsAuto MinorUnitIsAuto

True if Microsoft Excel calculates minor units for the value axis.

MinorUnitScale MinorUnitScale MinorUnitScale

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

Parent Parent Parent

Returns the parent object for the specified object.

ReversePlotOrder ReversePlotOrder ReversePlotOrder

True if Microsoft Excel plots data points from last to first.

ScaleType ScaleType ScaleType

Returns or sets the value axis scale type.

TickLabelPosition TickLabelPosition TickLabelPosition

Describes the position of tick-mark labels on the specified axis.

TickLabels TickLabels TickLabels

Returns a TickLabels object that represents the tick-mark labels for the specified axis.

TickLabelSpacing TickLabelSpacing TickLabelSpacing

Returns or sets the number of categories or series between tick-mark labels. Applies only to category and series axes.

TickLabelSpacingIsAuto TickLabelSpacingIsAuto TickLabelSpacingIsAuto

Returns or sets whether or not the tick label spacing is automatic. Read/write Boolean.

TickMarkSpacing TickMarkSpacing TickMarkSpacing

Returns or sets the number of categories or series between tick marks. Applies only to category and series axes.

Top Top 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 Type Type

Returns the Axis type.

Width Width Width

The width, in points, of the object.

Methods

Delete() Delete() Delete()

Deletes the object.

Select() Select() Select()

Selects the object.

Applies to