ExcelChartValueAxis Class

Represents the value axis (vertical axis) of a chart

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 12.0.0
C#
public class ExcelChartValueAxis
Inheritance
Object    ExcelChartValueAxis

Properties

AutoCategoryAxisCross Gets or sets a flag indicating if the value where the category axis crosses the value axis is automatically selected. Default value is true. A change of the CategoryAxisCrossesAt property will put this flag on false.
AutoMajorUnit Gets or sets a flag indicating if the MajorUnit is automatically selected. Default value is true. A change of the MajorUnit property will put this flag on false.
AutoMaxValue Gets or sets a flag indicating if the MaxValue is automatically selected. Default value is true. A change of the MaxValue property will put this flag on false.
AutoMinorUnit Gets or sets a flag indicating if the MinorUnit is automatically selected. Default value is true. A change of the MinorUnit property will put this flag on false.
AutoMinValue Gets or sets a flag indicating if the MinValue is automatically selected. Default value is true. A change of the MinValue property will put this flag on false.
CategoryAxisCrossesAtMaximum Gets or sets or a flag indicating that the horizontal (category) axis crosses the vertical (value) axis at the maximum value of the value axis.
CategoryAxisCrossesAtValue Gets or sets the value representing where the horizontal (category) axis crosses the vertical (value) axis.
CustomDisplayUnit Gets or sets a value representing a custom display unit as an alternative to the predefined display units (100, 1000, 10000, etc).
DisplayUnit Gets or sets the unit for the values on the value axis. The default value is None which means no scaling is used on the value axis. There are a few possible predefined display units like hundreds, thousands, millions, billions, etc for the value axis scaling. It is also possible to define a custom display unit. To set a custom value for the display unit the property should be set to CustomUnit and in this case the CustomDisplayUnit should be set to the desired unit value.
Font Gets the value axis font. The returned object can be used to set the properties of the Font used for the value axis labels.
LabelsPosition Gets or sets the labels position on value axis. Default value is NextToAxis.
LabelsRotation Gets or sets the rotation angle of the axis labels as a value between -90 and 90. A positive value will rotate the labels clockwise and the negative values will rotate the text counter-clockwise.
LineStyle Gets the value axis line style.
LogarithmicScale Gets or sets a flag indicating if the value axis uses a logarithmic scale.
MajorGridLinesStyle Gets the value axis major grid lines. The returned object can be used to set the value axis major grid lines color, dash type and weight.
MajorTickMarkType Gets or sets the minor tick marks type
MajorUnit Determines the interval of tick marks and chart gridlines for the major unit.
MaxValue Minimum value on value axis.
MinorGridLinesStyle Gets the value axis minor grid lines. The returned object can be used to set the value axis minor grid lines color, dash type and weight.
MinorTickMarkType Gets or sets the minor tick marks type
MinorUnit Determines the interval of tick marks and chart gridlines for the minor unit.
MinValue Minimum value on value axis.
ShowMajorGridLines Gets or sets a flag indicating if the minor grid lines are displayed in chart. The default value is true.
ShowMinorGridLines Gets or sets a flag indicating if the minor grid lines are displayed in chart. The default value is false.
Title Gets the value axis title box. The returned object can be used to set the title text, font, color, background and pattern.
ValuesInReverseOrder Gets or sets a flag indicating if the values are plotted in reverse order on the value axis.

Methods

Equals
(Inherited from Object)
Finalize
(Inherited from Object)
GetHashCode
(Inherited from Object)
GetType
(Inherited from Object)
MemberwiseClone
(Inherited from Object)
ShowVerticalTitleText Call this method to display the axis title text on vertical direction, from bottom to top.
ToString
(Inherited from Object)

See Also