Winnovative Excel Library

ExcelChartValueAxis Class

Winnovative Excel Library Documentation
Represents the value axis (vertical axis) of a chart
Inheritance Hierarchy

SystemObject
  Winnovative.ExcelLibExcelChartValueAxis

Namespace:  Winnovative.ExcelLib
Assembly:  wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax

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 methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodShowVerticalTitleText
Call this method to display the axis title text on vertical direction, from bottom to top.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also

Reference