Represents a single axis in a chart.
Inheritance
object
Properties
Section titled "Properties"Chart
Section titled "Chart"Inherited from: ChartObject
Returns the owning chart (read-only)
public WorksheetChart Chart { get; }Owner
Section titled "Owner"Inherited from: ChartObject
returns this object's owner. (read-only)
public ChartObject Owner { get; }Sheet
Section titled "Sheet"Inherited from: ChartObject
The owning sheet (read-only)
public Sheet Sheet { get; }Workbook
Section titled "Workbook"Inherited from: ChartObject
The owning workbook (read-only)
public Workbook Workbook { get; }Worksheet
Section titled "Worksheet"Inherited from: ChartObject
The owning worksheet (read-only)
public Worksheet Worksheet { get; }AxisBetweenCategories
Section titled "AxisBetweenCategories"True if the value axis crosses the category axis between categories.
public bool AxisBetweenCategories { get; set; }AxisGroup
Section titled "AxisGroup"Returns the group for the specified axis. Read-only
public AxisGroup AxisGroup { get; }AxisTitle
Section titled "AxisTitle"Returns or sets a object that represents the title of the axis.
public ChartTitle AxisTitle { get; set; }BaseUnit
Section titled "BaseUnit"Returns or sets the base unit for the axis.
public TimeUnit BaseUnit { get; set; }BaseUnitIsAuto
Section titled "BaseUnitIsAuto"True if Excel chooses appropriate base units for the specified category axis. The default value is True.
public bool BaseUnitIsAuto { get; set; }CategoryType
Section titled "CategoryType"Returns or sets the category axis type.
public CategoryType CategoryType { get; set; }Crosses
Section titled "Crosses"Returns or sets the point on the specified axis where the other axis crosses.
public AxisCrosses Crosses { get; set; }CrossesAt
Section titled "CrossesAt"Returns or sets the point on the at which the perpendicular axis intersects it.
public double CrossesAt { get; set; }DisplayUnit
Section titled "DisplayUnit"Returns or sets the unit label for the value axis.
public DisplayUnit DisplayUnit { get; set; }DisplayUnitCustom
Section titled "DisplayUnitCustom"If the value of the DisplayUnit property 'Custom' , the DisplayUnitCustom property returns or sets the value of the displayed units. The value must be from 0 through 10E307
public double DisplayUnitCustom { get; set; }DisplayUnitLabel
Section titled "DisplayUnitLabel"Returns or sets an object.
public DisplayUnitLabel DisplayUnitLabel { get; set; }GapWidth
Section titled "GapWidth"Returns or sets a value indicating the width of the gaps between data points or series, expressed as a percentage.
public double? GapWidth { get; set; }LogBase
Section titled "LogBase"Returns or sets the base of the logarithm when you are using log scales.
public double LogBase { get; set; }MajorGridLines
Section titled "MajorGridLines"Returns a object which defines the color and weight of the major ticklines.
public ChartGridLines MajorGridLines { get; set; }MajorTickMark
Section titled "MajorTickMark"Returns or sets the type of major tick mark for the specified axis.
public TickMark MajorTickMark { get; set; }MajorUnit
Section titled "MajorUnit"Returns the major interval unit.
public double MajorUnit { get; }MajorUnitIsAuto
Section titled "MajorUnitIsAuto"True if Excel calculates the major units for the value axis.
public bool MajorUnitIsAuto { get; set; }MajorUnitScale
Section titled "MajorUnitScale"Returns or sets the major unit scale value for the category axis when the property is set to 'TimeScale'.
public TimeUnit MajorUnitScale { get; set; }MaximumScale
Section titled "MaximumScale"Returns or sets the maximum value on the value axis.
public double MaximumScale { get; set; }MaximumScaleIsAuto
Section titled "MaximumScaleIsAuto"True if Excel calculates the maximum value for the value axis.
public bool MaximumScaleIsAuto { get; set; }MinimumScale
Section titled "MinimumScale"Returns or sets the minimum value on the value axis.
public double MinimumScale { get; set; }MinimumScaleIsAuto
Section titled "MinimumScaleIsAuto"True if Excel calculates the minimum value for the value axis.
public bool MinimumScaleIsAuto { get; set; }MinorGridLines
Section titled "MinorGridLines"Returns a object which defines the color and weight of the minor ticklines.
public ChartGridLines MinorGridLines { get; set; }MinorTickMark
Section titled "MinorTickMark"Returns or sets the type of minor tick mark for the specified axis.
public TickMark MinorTickMark { get; set; }MinorUnit
Section titled "MinorUnit"Returns the minor interval unit.
public double MinorUnit { get; }MinorUnitIsAuto
Section titled "MinorUnitIsAuto"True if Excel calculates the minor units for the value axis.
public bool MinorUnitIsAuto { get; set; }MinorUnitScale
Section titled "MinorUnitScale"Returns or sets the minor unit scale value for the category axis when the property is set to 'TimeScale'.
public TimeUnit MinorUnitScale { get; set; }Position
Section titled "Position"Returns or sets an value which determines the placement of the axis as relative to the chart space.
public AxisPosition Position { get; set; }ReversePlotOrder
Section titled "ReversePlotOrder"True if Excel plots data points from last to first.
public bool ReversePlotOrder { get; set; }ScaleType
Section titled "ScaleType"Returns or sets a value indicating whether the axis scale is linear or logarithmic.
public ScaleType ScaleType { get; set; }TickLabelPosition
Section titled "TickLabelPosition"Describes the position of tick-mark labels on the specified axis.
public TickLabelPosition TickLabelPosition { get; set; }TickLabelSpacing
Section titled "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.
public int TickLabelSpacing { get; set; }TickLabelSpacingIsAuto
Section titled "TickLabelSpacingIsAuto"Returns or sets whether or not the tick label spacing is automatic.
public bool TickLabelSpacingIsAuto { get; set; }TickLabels
Section titled "TickLabels"Returns a TickLabels object that represents the tick-mark labels for the specified axis. Read-only.
public TickLabels TickLabels { get; }TickLines
Section titled "TickLines"Determines the appearance of the tick lines.
public ChartTickLines TickLines { get; set; }TickMarkSpacing
Section titled "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.
public int TickMarkSpacing { get; set; }Returns the type of the axis (read-only)
public AxisType Type { get; }Visible
Section titled "Visible"Returns or sets whether or not the axis is visible.
public bool Visible { get; set; }Methods
Section titled "Methods"SetMajorMinorUnit(double, double)
Section titled "SetMajorMinorUnit(double, double)"Sets the values of the and properties.
public void SetMajorMinorUnit(double majorUnit, double minorUnit)Parameters
- majorUnit:
double - minorUnit:
double