XlsChartCategoryAxis Properties | 
The XlsChartCategoryAxis type exposes the following members.
| Name | Description | |
|---|---|---|
| 
 | 
Alignment | 
 
Represents alignment for the tick label.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
AutoTickLabelSpacing | 
 
Gets or sets a value indicating whether the spacing between tick labels on the axis should be automatically adjusted.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
AutoTickMarkSpacing | 
 
Gets or sets a value indicating whether the spacing between tick marks on the axis should be automatically determined.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
AxisBetweenCategories | 
 
True if the value axis crosses the category axis between categories
 
 | 
| 
 | 
AxisId | 
 
Gets axis id.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
AxisType | 
 
Type of the axis.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
BaseUnit | 
 
Represents base unit for the specified category axis.
 
 | 
| 
 | 
BaseUnitIsAuto | 
 
True if use automatic base units for the specified category axis.
 
 | 
| 
 | 
BinWidth | 
 
Get or Set the number of data points in each range.
 
 | 
| 
 | 
Border | 
 
Represents chart border. Read only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
CategoryLabels | 
 
Category labels for the chart.
 
 | 
| 
 | 
CategoryType | 
 
Represents axis category type.
 
 | 
| 
 | 
Chart3DOptions | 
 
Gets the chart3 D options.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
Chart3DProperties | 
 
Gets the chart3 D properties.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
CrossesAt | 
 
Represents the point on the axis another axis crosses it.
 
 | 
| 
 | 
CrossingPoint | 
 
Represents the point on the axis another axis crosses it.
 
 | 
| 
 | 
CrossValue | 
 
Value of category axis crosses.
 
 | 
| 
 | 
Deleted | 
 
Gets or sets value indicating whether axis was deleted.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
EnteredDirectlyCategoryLabels | 
 
Entered directly category labels for the chart.
 
 | 
| 
 | 
Font | 
 
Returns font used for axis text displaying. Read-only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
FrameFormat | 
 
Return frame format of Axis. Read-only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
Has3dProperties | 
 
This property Indicates whether the Shadow object has been created(which includes the 3D properties)
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
HasAutomaticBins | 
 
True if bins generated are automatic. otherwise False
 
 | 
| 
 | 
HasAxisTitle | 
 
Indicates wheather the axis has title
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
HasMajorGridLines | 
 
True if the axis has major gridlines. Only axes in the primary axis group can have gridlines.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
HasMinorGridLines | 
 
True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
IsAutoCross | 
 
Automatic category crossing point selected.
 
 | 
| 
 | 
IsAutoMajor | 
 
Automatic major selected.
 
 | 
| 
 | 
IsAutoMax | 
 
Automatic maximum selected.
 
 | 
| 
 | 
IsAutoMin | 
 
Automatic minimum selected.
 
 | 
| 
 | 
IsAutoMinor | 
 
Automatic minor selected.
 
 | 
| 
 | 
IsAutoTextRotation | 
 
Returns text area for the axis title. Read-only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
IsBinningByCategory | 
 
True if bins generated by category values. otherwise False
 
 | 
| 
 | 
IsLogScale | 
 
Represents logarithmic scale.
 
 | 
| 
 | 
IsMaxCross | 
 
Value axis crosses at the far right category.
 
 | 
| 
 | 
IsPrimary | 
 
True if this is primary axis.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
IsReversed | 
 
True if plots data points from last to first.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
IsReverseOrder | 
 
Categories in reverse order.
 
 | 
| 
 | 
IsSourceLinked | 
 
Determines whether the source is linked.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
LabelFrequency | 
 
Frequency of labels.
 
 | 
| 
 | 
LogBase | 
 
Represents the logarithmic base. Default value is 10.Only applies for Excel2007.
 
 | 
| 
 | 
MajorGridLines | 
 
Returns major gridLines. Read-only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
MajorTickMark | 
 
Represents major tick marks.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
MajorUnit | 
 
Value of major increment.
 
 | 
| 
 | 
MajorUnitScale | 
 
Represens the major unit scale value for the category axis
when the CategoryType property is set to TimeScale.
 
 | 
| 
 | 
MaxValue | 
 
Represents maximum value.
 
 | 
| 
 | 
MinorGridLines | 
 
Returns minor gridLines. Read-only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
MinorTickMark | 
 
Represents minor tick marks.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
MinorUnit | 
 
Value of minor increment.
 
 | 
| 
 | 
MinorUnitScale | 
 
Represens the minor unit scale value for the category axis
when the CategoryType property is set to TimeScale.
 
 | 
| 
 | 
MinValue | 
 
Represents minimum value.
 
 | 
| 
 | 
MultiLevelLable | 
 
Axis is show Multi-level category lables.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
NumberFormat | 
 
Gets or sets number format string.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
NumberFormatIndex | 
 
Gets or sets format index.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
NumberOfBins | 
 
Get or set the Number of Bins in the axis
 
 | 
| 
 | 
Offset | 
 
Represents distance between the labels and axis line.
The value can be from 0 through 1000.
 
 | 
| 
 | 
OverflowBinValue | 
 
Get or Set the OverFlow Bin value
 
 | 
| 
 | 
ParagraphType | 
 
Represents the TextArea Paragraph
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
Parent | 
 
Reference to Parent object. Read-only.
 
(Inherited from
XlsObject
.)
 | 
| 
 | 
ReferenceCount | 
 
Get quantity of instance references.
 
(Inherited from
XlsObject
.)
 | 
| 
 | 
Shadow | 
 
Represents the Shadow.Read-only
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
ShadowProperties | 
 
Represents Shadow Propertes.Read-Only
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
TextDirection | 
 
axis's text direction
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
TextRotationAngle | 
 
Gets or sets the angle of rotation for the text.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
TickLabelPosition | 
 
Represents tick label position.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
TickLabelSpacing | 
 
Represents the number of categories or series between tick-mark labels.
 
 | 
| 
 | 
TickMarksFrequency | 
 
Frequency of tick marks.
 
 | 
| 
 | 
TickMarkSpacing | 
 
Represents the number of categories or series between tick marks.
 
 | 
| 
 | 
Title | 
 
Title of the axis.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
TitleArea | 
 
Returns text area for the axis title. Read-only.
 
(Inherited from
XlsChartAxis
.)
 | 
| 
 | 
UnderflowBinValue | 
 
Get or Set the UnderFlow Bin value
 
 | 
| 
 | 
Visible | 
 
Indicates is axis is visible.
 
(Inherited from
XlsChartAxis
.)
 |