Click or drag to resize

ChartCategoryAxis Class

Represents the category axis of a chart, which is used to display categorical data.
Inheritance Hierarchy

Namespace: Spire.Xls.Charts
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class ChartCategoryAxis : XlsChartCategoryAxis

The ChartCategoryAxis type exposes the following members.

Properties
Name Description
Public property Alignment
Represents alignment for the tick label.
(Inherited from XlsChartAxis .)
Public property AutoTickLabelSpacing
Gets or sets a value indicating whether the spacing between tick labels on the axis should be automatically adjusted.
(Inherited from XlsChartAxis .)
Public property AutoTickMarkSpacing
Gets or sets a value indicating whether the spacing between tick marks on the axis should be automatically determined.
(Inherited from XlsChartAxis .)
Public property AxisBetweenCategories
True if the value axis crosses the category axis between categories
(Inherited from XlsChartCategoryAxis .)
Public property AxisId
Gets axis id.
(Inherited from XlsChartAxis .)
Public property AxisType
Type of the axis.
(Inherited from XlsChartAxis .)
Public property BaseUnit
Represents base unit for the specified category axis.
(Inherited from XlsChartCategoryAxis .)
Public property BaseUnitIsAuto
True if use automatic base units for the specified category axis.
(Inherited from XlsChartCategoryAxis .)
Public property BinWidth
Get or Set the number of data points in each range.
(Inherited from XlsChartCategoryAxis .)
Public property Border
Represents chart border. Read only.
(Inherited from XlsChartAxis .)
Public property CategoryLabels
Category labels for the chart.
Public property CategoryType
Represents axis category type.
(Inherited from XlsChartCategoryAxis .)
Public property Chart3DOptions
Gets the chart3 D options.
(Inherited from XlsChartAxis .)
Public property Chart3DProperties
Gets the chart3 D properties.
(Inherited from XlsChartAxis .)
Public property CrossesAt
Represents the point on the axis another axis crosses it.
(Inherited from XlsChartCategoryAxis .)
Public property CrossingPoint
Represents the point on the axis another axis crosses it.
(Inherited from XlsChartCategoryAxis .)
Public property CrossValue
Value of category axis crosses.
(Inherited from XlsChartCategoryAxis .)
Public property Deleted
Gets or sets value indicating whether axis was deleted.
(Inherited from XlsChartAxis .)
Public property EnteredDirectlyCategoryLabels
Entered directly category labels for the chart.
(Inherited from XlsChartCategoryAxis .)
Public property Font
Gets font used for axis text displaying.
Public property FrameFormat
Return frame format of Axis. Read-only.
(Inherited from XlsChartAxis .)
Public property Has3dProperties
This property Indicates whether the Shadow object has been created(which includes the 3D properties)
(Inherited from XlsChartAxis .)
Public property HasAutomaticBins
True if bins generated are automatic. otherwise False
(Inherited from XlsChartCategoryAxis .)
Public property HasAxisTitle
Indicates wheather the axis has title
(Inherited from XlsChartAxis .)
Public property HasMajorGridLines
True if the axis has major gridlines. Only axes in the primary axis group can have gridlines.
(Inherited from XlsChartAxis .)
Public property HasMinorGridLines
True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines.
(Inherited from XlsChartAxis .)
Public property IsAutoCross
Automatic category crossing point selected.
(Inherited from XlsChartCategoryAxis .)
Public property IsAutoMajor
Automatic major selected.
(Inherited from XlsChartCategoryAxis .)
Public property IsAutoMax
Automatic maximum selected.
(Inherited from XlsChartCategoryAxis .)
Public property IsAutoMin
Automatic minimum selected.
(Inherited from XlsChartCategoryAxis .)
Public property IsAutoMinor
Automatic minor selected.
(Inherited from XlsChartCategoryAxis .)
Public property IsAutoTextRotation
Returns text area for the axis title. Read-only.
(Inherited from XlsChartAxis .)
Public property IsBinningByCategory
True if bins generated by category values. otherwise False
(Inherited from XlsChartCategoryAxis .)
Public property IsLogScale
Represents logarithmic scale.
(Inherited from XlsChartCategoryAxis .)
Public property IsMaxCross
Value axis crosses at the far right category.
(Inherited from XlsChartCategoryAxis .)
Public property IsPrimary
True if this is primary axis.
(Inherited from XlsChartAxis .)
Public property IsReversed
True if plots data points from last to first.
(Inherited from XlsChartAxis .)
Public property IsReverseOrder
Categories in reverse order.
(Inherited from XlsChartCategoryAxis .)
Public property IsSourceLinked
Determines whether the source is linked.
(Inherited from XlsChartAxis .)
Public property LabelFrequency
Frequency of labels.
(Inherited from XlsChartCategoryAxis .)
Public property LogBase
Represents the logarithmic base. Default value is 10.Only applies for Excel2007.
(Inherited from XlsChartCategoryAxis .)
Public property MajorGridLines
Returns a ChartGridLine object that represents the major gridlines for the specified axis. Only axes in the primary axis group can have gridlines
Public property MajorTickMark
Represents major tick marks.
(Inherited from XlsChartAxis .)
Public property MajorUnit
Value of major increment.
(Inherited from XlsChartCategoryAxis .)
Public property MajorUnitScale
Represens the major unit scale value for the category axis when the CategoryType property is set to TimeScale.
(Inherited from XlsChartCategoryAxis .)
Public property MaxValue
Represents maximum value.
(Inherited from XlsChartCategoryAxis .)
Public property MinorGridLines
Returns a ChartGridLine object that represents the minor gridlines for the specified axis. Only axes in the primary axis group can have gridlines.
Public property MinorTickMark
Represents minor tick marks.
(Inherited from XlsChartAxis .)
Public property MinorUnit
Value of minor increment.
(Inherited from XlsChartCategoryAxis .)
Public property MinorUnitScale
Represens the minor unit scale value for the category axis when the CategoryType property is set to TimeScale.
(Inherited from XlsChartCategoryAxis .)
Public property MinValue
Represents minimum value.
(Inherited from XlsChartCategoryAxis .)
Public property MultiLevelLable
Axis is show Multi-level category lables.
(Inherited from XlsChartAxis .)
Public property NumberFormat
Gets or sets number format string.
(Inherited from XlsChartAxis .)
Public property NumberFormatIndex
Gets or sets format index.
(Inherited from XlsChartAxis .)
Public property NumberOfBins
Get or set the Number of Bins in the axis
(Inherited from XlsChartCategoryAxis .)
Public property Offset
Represents distance between the labels and axis line. The value can be from 0 through 1000.
(Inherited from XlsChartCategoryAxis .)
Public property OverflowBinValue
Get or Set the OverFlow Bin value
(Inherited from XlsChartCategoryAxis .)
Public property ParagraphType
Represents the TextArea Paragraph
(Inherited from XlsChartAxis .)
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property Shadow
Represents the Shadow.Read-only
(Inherited from XlsChartAxis .)
Public property ShadowProperties
Represents Shadow Propertes.Read-Only
(Inherited from XlsChartAxis .)
Public property TextDirection
axis's text direction
(Inherited from XlsChartAxis .)
Public property TextRotationAngle
Gets or sets the angle of rotation for the text.
(Inherited from XlsChartAxis .)
Public property TickLabelPosition
Represents tick label position.
(Inherited from XlsChartAxis .)
Public property TickLabelSpacing
Represents the number of categories or series between tick-mark labels.
(Inherited from XlsChartCategoryAxis .)
Public property TickMarksFrequency
Frequency of tick marks.
(Inherited from XlsChartCategoryAxis .)
Public property TickMarkSpacing
Represents the number of categories or series between tick marks.
(Inherited from XlsChartCategoryAxis .)
Public property Title
Title of the axis.
(Inherited from XlsChartAxis .)
Public property TitleArea
Returns text area for the axis title. Read-only.
Public property UnderflowBinValue
Get or Set the UnderFlow Bin value
(Inherited from XlsChartCategoryAxis .)
Public property Visible
Indicates is axis is visible.
(Inherited from XlsChartAxis .)
Top
Methods
Name Description
Protected method AddReference
Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.
(Inherited from XlsObject .)
Protected method CheckDisposed
Checks whether object was disposed and throws exception if it was.
(Inherited from XlsObject .)
Public method Clone Obsolete.
Clones current object.
(Inherited from XlsChartCategoryAxis .)
Public method Dispose
Dispose object and free resources.
(Inherited from XlsObject .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Destructor. Call dispose method of current object.
(Inherited from XlsObject .)
Protected method FindParent(Type)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParent( Type )
Find parent of object.
(Inherited from XlsObject .)
Protected method FindParent(Type, Boolean)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParents
Finds parent objects.
(Inherited from XlsObject .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Protected method OnDispose
Method which can be overriden by users to take any specific actions when object is disposed.
(Inherited from XlsObject .)
Protected method ReleaseReference
Decrease quantity of Reference. User must call this method when freeing resources.
(Inherited from XlsObject .)
Protected method SetParent
Sets parent of the object.
(Inherited from XlsObject .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Fields
Name Description
Protected field m_bIsDisposed
Flag which indicates if the object was disposed or not.
(Inherited from XlsObject .)
Top
See Also