Click or drag to resize

XlsChartCategoryAxis Class

Represents the category axis of a chart in an Excel worksheet.
Inheritance Hierarchy

Namespace: Spire.Xls.Core.Spreadsheet.Charts
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class XlsChartCategoryAxis : XlsChartAxis, 
	IChartCategoryAxis, IChartValueAxis, IChartAxis

The XlsChartCategoryAxis 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
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.
Public property BaseUnitIsAuto
True if use automatic base units for the specified category axis.
Public property BinWidth
Get or Set the number of data points in each range.
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.
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.
Public property CrossingPoint
Represents the point on the axis another axis crosses it.
Public property CrossValue
Value of category axis crosses.
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.
Public property Font
Returns font used for axis text displaying. Read-only.
(Inherited from XlsChartAxis .)
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
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.
Public property IsAutoMajor
Automatic major selected.
Public property IsAutoMax
Automatic maximum selected.
Public property IsAutoMin
Automatic minimum selected.
Public property IsAutoMinor
Automatic minor selected.
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
Public property IsLogScale
Represents logarithmic scale.
Public property IsMaxCross
Value axis crosses at the far right category.
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.
Public property IsSourceLinked
Determines whether the source is linked.
(Inherited from XlsChartAxis .)
Public property LabelFrequency
Frequency of labels.
Public property LogBase
Represents the logarithmic base. Default value is 10.Only applies for Excel2007.
Public property MajorGridLines
Returns major gridLines. Read-only.
(Inherited from XlsChartAxis .)
Public property MajorTickMark
Represents major tick marks.
(Inherited from XlsChartAxis .)
Public property MajorUnit
Value of major increment.
Public property MajorUnitScale
Represens the major unit scale value for the category axis when the CategoryType property is set to TimeScale.
Public property MaxValue
Represents maximum value.
Public property MinorGridLines
Returns minor gridLines. Read-only.
(Inherited from XlsChartAxis .)
Public property MinorTickMark
Represents minor tick marks.
(Inherited from XlsChartAxis .)
Public property MinorUnit
Value of minor increment.
Public property MinorUnitScale
Represens the minor unit scale value for the category axis when the CategoryType property is set to TimeScale.
Public property MinValue
Represents minimum value.
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
Public property Offset
Represents distance between the labels and axis line. The value can be from 0 through 1000.
Public property OverflowBinValue
Get or Set the OverFlow Bin value
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.
Public property TickMarksFrequency
Frequency of tick marks.
Public property TickMarkSpacing
Represents the number of categories or series between tick marks.
Public property Title
Title of the axis.
(Inherited from XlsChartAxis .)
Public property TitleArea
Returns text area for the axis title. Read-only.
(Inherited from XlsChartAxis .)
Public property UnderflowBinValue
Get or Set the UnderFlow Bin value
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.
(Overrides XlsChartAxis Clone(Object, Dictionary Int32, Int32 , Dictionary String, String ) .)
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
Public field Static member DefaultCategoryAxisId
Some category axis id.
Public field Static member DefaultSecondaryCategoryAxisId
Some secondary category axis id.
Protected field m_bIsDisposed
Flag which indicates if the object was disposed or not.
(Inherited from XlsObject .)
Top
See Also