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: 9.0.0
Syntax
Copy
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