CategoryAxis Class

Namespace:

GemBox.Spreadsheet.Charts

Assembly:

GemBox.Spreadsheet.dll

Represents an axis used for categories.

• C#
• VB.NET

public sealed class CategoryAxis : ChartAxis

Public NotInheritable Class CategoryAxis
    Inherits ChartAxis

Inheritance:

System.Object

ChartAxis

CategoryAxis

Properties

AxisType

Gets the axis type for CategoryAxis which is Category.

• C#
• VB.NET

public override AxisType AxisType { get; }

Public Overrides ReadOnly Property AxisType As AxisType

Property Value

AxisType

The Category value.

Overrides

ChartAxis.AxisType

LabelsInterval

Gets or sets the interval between labels that are drawn.

• C#
• VB.NET

public int? LabelsInterval { get; set; }

Public Property LabelsInterval As Integer?

Property Value

System.Nullable<System.Int32>

The interval between labels that are drawn.

Exceptions

System.ArgumentOutOfRangeException

Value must be between 1 and 255.

MultiLevelLabels

Gets or sets the value indicating whether the labels should be shown as hierarchy.

• C#
• VB.NET

public bool MultiLevelLabels { get; set; }

Public Property MultiLevelLabels As Boolean

Property Value

System.Boolean

true, to show the labels as hierarchy; false, to show the labels as flat text.

Remarks

Default value of this property is true. This member is currently not supported when saving to PDF, XPS, or image formats.

TickMarksInterval

Gets or sets the interval between tick marks that are drawn.

• C#
• VB.NET

public int TickMarksInterval { get; set; }

Public Property TickMarksInterval As Integer

Property Value

System.Int32

The interval between tick marks that are drawn.

Remarks

Default value of this property is 1.

Exceptions

System.ArgumentOutOfRangeException

Value must be between 1 and 31999.

Inherited Properties

CrossType	Gets or sets the axis cross configuration. (Inherited from ChartAxis)
CrossesAt	Gets or sets the specific value or category on which the opposite axis should be positioned. To be used with CrossType set to Specific. (Inherited from ChartAxis)
Fill	Gets or sets the fill formatting options. (Inherited from ChartAxis)
IsVisible	Gets or sets a value indicating whether axis is visible. (Inherited from ChartAxis)
LabelsPosition	Gets or sets the axis labels position. (Inherited from ChartAxis)
MajorGridlines	Gets the major gridlines. (Inherited from ChartAxis)
MajorTickMarkType	Gets or sets the major tick marks position. (Inherited from ChartAxis)
MinorGridlines	Gets the minor gridlines. (Inherited from ChartAxis)
MinorTickMarkType	Gets or sets the minor tick marks position. (Inherited from ChartAxis)
NumberFormat	Gets or sets the number format used for formatting axis value labels. If NumberFormatLinkedToSource is true, then number format from chart's source data (cells) will be used to format axis value labels as explained in remarks. Setting this property, sets NumberFormatLinkedToSource to false. (Inherited from ChartAxis)
NumberFormatLinkedToSource	Gets or sets a value indicating whether number format from chart's source data (cells) will be used to format axis value labels. (Inherited from ChartAxis)
Outline	Gets or sets the outline formatting options. (Inherited from ChartAxis)
ReverseOrder	Gets or sets a value indicating whether values on the axis shall be reversed so they go from maximum to minimum. This value is currently not supported when exporting a chart to PDF, XPS, or image formats. This value is always exported as false. (Inherited from ChartAxis)
TextBoxFormat	Gets or sets the text box formatting. (Inherited from ChartAxis)
TextFormat	Gets or sets the text formatting options. (Inherited from ChartAxis)
Title	Gets the axis title. (Inherited from ChartAxis)

Inherited Methods

ChangeAxisType(AxisType)	Changes the type of the axis. (Inherited from ChartAxis)
ChangeAxisType<TChartAxis>()	Changes the type of the axis. (Inherited from ChartAxis)
Delete()	Deletes axis. (Inherited from ChartAxis)
ToString()	Returns a System.String that represents this ChartAxis instance. (Inherited from ChartAxis)