Click or drag to resize

ExcelChartValueAxis Class

Represents the value axis (vertical axis) of a chart
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelChartValueAxis

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 9.0.0
Syntax
Copy
public class ExcelChartValueAxis

The ExcelChartValueAxis type exposes the following members.

Properties
 NameDescription
Public propertyAutoCategoryAxisCross 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.
Public propertyAutoMajorUnit 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.
Public propertyAutoMaxValue 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.
Public propertyAutoMinorUnit 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.
Public propertyAutoMinValue 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.
Public propertyCategoryAxisCrossesAtMaximum 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.
Public propertyCategoryAxisCrossesAtValue Gets or sets the value representing where the horizontal (category) axis crosses the vertical (value) axis.
Public propertyCustomDisplayUnit Gets or sets a value representing a custom display unit as an alternative to the predefined display units (100, 1000, 10000, etc).
Public propertyDisplayUnit 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.
Public propertyFont Gets the value axis font. The returned object can be used to set the properties of the Font used for the value axis labels.
Public propertyLabelsPosition Gets or sets the labels position on value axis. Default value is NextToAxis.
Public propertyLabelsRotation 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.
Public propertyLineStyle Gets the value axis line style.
Public propertyLogarithmicScale Gets or sets a flag indicating if the value axis uses a logarithmic scale.
Public propertyMajorGridLinesStyle 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.
Public propertyMajorTickMarkType Gets or sets the minor tick marks type
Public propertyMajorUnit Determines the interval of tick marks and chart gridlines for the major unit.
Public propertyMaxValue Minimum value on value axis.
Public propertyMinorGridLinesStyle 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.
Public propertyMinorTickMarkType Gets or sets the minor tick marks type
Public propertyMinorUnit Determines the interval of tick marks and chart gridlines for the minor unit.
Public propertyMinValue Minimum value on value axis.
Public propertyShowMajorGridLines Gets or sets a flag indicating if the minor grid lines are displayed in chart. The default value is true.
Public propertyShowMinorGridLines Gets or sets a flag indicating if the minor grid lines are displayed in chart. The default value is false.
Public propertyTitle Gets the value axis title box. The returned object can be used to set the title text, font, color, background and pattern.
Public propertyValuesInReverseOrder Gets or sets a flag indicating if the values are plotted in reverse order on the value axis.
Top
Methods
 NameDescription
Public methodShowVerticalTitleText Call this method to display the axis title text on vertical direction, from bottom to top.
Top
See Also