Click or drag to resize

ExcelChartCategoryAxis Class

Represents the category axis (horizontal axis) of a chart
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelChartCategoryAxis

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
public class ExcelChartCategoryAxis

The ExcelChartCategoryAxis type exposes the following members.

Properties
  NameDescription
Public propertyAutoBaseTimeUnitScale
Gets or sets a flag indicating if the base unit is automatically selected for the category axis. It is used when the CategoryAxisType is TimeScale.
Public propertyBaseTimeUnitScale
Gets or sets the base unit scale for the category axis. It is used only when the CategoryAxisType is TimeScale. The default value is Days.
Public propertyCategoriesInReverseOrder
Gets or sets a flag indicating if the cateories are plotted in reverse order on the category axis.
Public propertyCategoryAxisType
Gets or sets the category axis type. The default type is AutomaticScale.
Public propertyCategoryLabelsInterval
Gets or sets the number of categories between labels on category axis. Set this property with 1 to display a label for every category, 2 to display a label for every other category, 3 to display a label for every third category, and so on
Public propertyCategoryLabelsPosition
Gets or sets the category axis labels position. Default value is NextToAxis.
Public propertyCategoryLabelsRotation
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 propertyCategoryNamesRange
Gets or sets the range from where the category names are taken.
Public propertyFont
Gets the category axis font. The returned object can be used to set the properties of the Font used for the cateory axis labels.
Public propertyLineStyle
Gets the category axis line style.
Public propertyMajorGridLinesStyle
Gets the category axis major grid lines. The returned object can be used to set the category axis major grid lines color, dash type and weight.
Public propertyMajorTickMarkType
Gets or sets the minor tick marks type
Public propertyMajorTimeUnitScale
Gets or sets the major unit scale for the category axis. It is used when the CategoryAxisType is TimeScale. The default value is Days.
Public propertyMinorGridLinesStyle
Gets the category axis minor grid lines. The returned object can be used to set the category axis minor grid lines color, dash type and weight.
Public propertyMinorTickMarkType
Gets or sets the minor tick marks type
Public propertyMinorTimeUnitScale
Gets or sets the minor unit scale for the category axis. It is used when the CategoryAxisType is TimeScale.
Public propertyShowMajorGridLines
Gets or sets a flag indicating if the minor grid lines are displayed in chart. The default value is false.
Public propertyShowMinorGridLines
Gets or sets a flag indicating if the minor grid lines are displayed in chart. The default value is false.
Public propertyTickMarksInterval
Gets or sets the number of categories between tick marks on category axis.
Public propertyTitle
Gets the category axis title box. The returned object can be used to set the title text, font, color, background and pattern.
Top
See Also