Winnovative Excel Library

ExcelChartValueAxis Properties

Winnovative Excel Library Documentation

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
See Also

Reference