[]
Represents a single axis in a chart.
public interface IAxis
Returns the actual category axis type.
CategoryType ActualCategoryType { get; }
Gets or sets whether the value axis crosses the category axis (True if the value axis crosses the category axis between categories).
bool AxisBetweenCategories { get; set; }
Returns the group for the specified axis.
AxisGroup AxisGroup { get; }
Returns an IAxisTitle object that represents the title of the specified axis.
IAxisTitle AxisTitle { get; }
Gets or sets the base unit for the specified category axis.
TimeUnit BaseUnit { get; set; }
Gets or sets whether the units are automatically selected (True if Microsoft Excel chooses appropriate base units for the specified category axis). The default value is True.
bool BaseUnitIsAuto { get; set; }
Gets or sets all the category names for the specified axis as a text array.
string[] CategoryNames { get; set; }
Gets or sets the category axis type.
CategoryType CategoryType { get; set; }
Gets or sets the point on the specified axis where the other axis crosses.
AxisCrosses Crosses { get; set; }
Gets or sets the point on the value axis where the category axis crosses it. Applies only to the value axis.
double CrossesAt { get; set; }
Gets or sets the unit label for the value axis.
DisplayUnit DisplayUnit { get; set; }
Gets or sets whether the displayed units use custom settings (If the value of the DisplayUnit property is custom, then the DisplayUnitCustom property returns or sets the value of the displayed units. The value must be from 0 through 10E307.
double DisplayUnitCustom { get; set; }
Returns the IDisplayUnitLabel object for the specified axis. Returns Null if the HasDisplayUnitLabel property is set to False.
IDisplayUnitLabel DisplayUnitLabel { get; }
Returns the IChartFormat object.
IChartFormat Format { get; }
Gets or sets whether the label is displayed on the specified axis (True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis). The default value is True.
bool HasDisplayUnitLabel { get; set; }
Gets or sets whether the axis has major gridlines (True if the axis has major gridlines). This only applies to axes in the primary axis group can have gridlines.
bool HasMajorGridlines { get; set; }
Gets or sets whether the axis has minor gridlines (True if the axis has minor gridlines). This only applies to axes in the primary axis group can have gridlines.
bool HasMinorGridlines { get; set; }
Gets or sets whether the axis or chart has a visible title (True if the axis or chart has a visible title).
bool HasTitle { get; set; }
Gets or sets the base of the logarithm when you are using log scales.
double LogBase { get; set; }
Returns a IGridlines object that represents the major gridlines for the specified axis. Only axes in the primary axis group can have gridlines.
IGridlines MajorGridlines { get; }
Gets or sets the type of major tick mark for the specified axis.
TickMark MajorTickMark { get; set; }
Gets or sets the major units for the value axis.
double MajorUnit { get; set; }
Gets or sets whether Excel calculates the major units (True if Microsoft Excel calculates the major units for the value axis).
bool MajorUnitIsAuto { get; set; }
Gets or sets the major unit scale value for the category axis when the CategoryType property is set to TimeScale.
TimeUnit MajorUnitScale { get; set; }
Gets or sets the maximum value on the value axis.
double MaximumScale { get; set; }
Gets or sets whether Excel calculates the maximum value (True if Microsoft Excel calculates the maximum value for the value axis).
bool MaximumScaleIsAuto { get; set; }
Gets or sets the minimum value on the value axis.
double MinimumScale { get; set; }
Gets or sets whether Excel calculates the miniumum value for the value axis (True if Microsoft Excel calculates the minimum value).
bool MinimumScaleIsAuto { get; set; }
Returns the IGridlines object that represents the minor gridlines for the specified axis. Only axes in the primary axis group can have gridlines.
IGridlines MinorGridlines { get; }
Gets or sets the type of minor tick mark for the specified axis.
TickMark MinorTickMark { get; set; }
Gets or sets the minor units on the value axis.
double MinorUnit { get; set; }
Gets or sets whether Microsoft Excel calculates minor units for the value axis (True if Excel calculates minor units).
bool MinorUnitIsAuto { get; set; }
Gets or sets the minor unit scale value for the category axis when the CategoryType property is set to TimeScale.
TimeUnit MinorUnitScale { get; set; }
Returns the parent object for the specified object.
IAxes Parent { get; }
Gets or sets whether Excel plots data from last to first (True if Microsoft Excel plots data points from last to first).
bool ReversePlotOrder { get; set; }
Gets or sets the value axis scale type.
ScaleType ScaleType { get; set; }
Gets or sets the position of tick-mark labels on the specified axis.
TickLabelPosition TickLabelPosition { get; set; }
Returns the ITickLabels object that represents the tick-mark labels for the specified axis.
ITickLabels TickLabels { get; }
Gets or sets the number of categories or series between tick-mark labels. This only applies to category and series axes.
int TickLabelSpacing { get; set; }
Gets or sets whether the tick label spacing is automatic.
bool TickLabelSpacingIsAuto { get; set; }
Gets or sets the number of categories or series between tick marks. Applies only to category and series axes.
int TickMarkSpacing { get; set; }
Returns the Axis type.
AxisType Type { get; }
Gets or sets whether the axis is visible.
bool Visible { get; set; }