ExcelChartValueAxis Class |
Represents the value axis (vertical axis) of a chart
Inheritance HierarchySystemObject
ExpertXls.ExcelLibExcelChartValueAxis
ExpertXls.ExcelLibExcelChartValueAxis
Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 7.0.0
SyntaxThe ExcelChartValueAxis type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | 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| Name | Description | |
|---|---|---|
 | ShowVerticalTitleText |
Call this method to display the axis title text on vertical direction, from bottom to top.
|
See Also