XlsChartCategoryAxis module

class XlsChartCategoryAxis.XlsChartCategoryAxis

Bases: XlsChartAxis, IChartCategoryAxis, IChartValueAxis

property AxisBetweenCategories: bool

<summary>

True if the value axis crosses the category axis between categories

</summary>

property BaseUnit: ChartBaseUnitType

<summary>

Represents base unit for the specified category axis.

</summary>

property BaseUnitIsAuto: bool

<summary>

True if use automatic base units for the specified category axis.

</summary>

property BinWidth: float

<summary>

Get or Set the number of data points in each range.

</summary>

<remarks>Applies only to Histogram and Pareto charts.</remarks>

property CategoryLabels: IXLSRange

property CategoryType: CategoryType

<summary>

Represents axis category type.

</summary>

property CrossValue: float

<summary>

Value of category axis crosses.

</summary>

property CrossesAt: float

<summary>

Represents the point on the axis another axis crosses it.

</summary>

property CrossingPoint: float

<summary>

Represents the point on the axis another axis crosses it.

</summary>

static DefaultCategoryAxisId() → int

static DefaultSecondaryCategoryAxisId() → int

property EnteredDirectlyCategoryLabels: List[SpireObject]

<summary>

Entered directly category labels for the chart.

</summary>

property HasAutomaticBins: bool

<summary>

True if bins generated are automatic. otherwise False

</summary>

<remarks>Applies only to Histogram and Pareto charts.</remarks>

property IsAutoCross: bool

<summary>

Automatic category crossing point selected.

</summary>

property IsAutoMajor: bool

<summary>

Automatic major selected.

</summary>

property IsAutoMax: bool

<summary>

Automatic maximum selected.

</summary>

property IsAutoMin: bool

<summary>

Automatic minimum selected.

</summary>

property IsAutoMinor: bool

<summary>

Automatic minor selected.

</summary>

property IsBinningByCategory: bool

<summary>

True if bins generated by category values. otherwise False

</summary>

<remarks>Applies only to Histogram and Pareto charts.</remarks>

property IsLogScale: bool

property IsMaxCross: bool

<summary>

Value axis crosses at the far right category.

</summary>

property IsReverseOrder: bool

<summary>

Categories in reverse order.

</summary>

property LabelFrequency: int

<summary>

Frequency of labels.

</summary>

property LogBase: float

property MajorUnit: float

<summary>

Value of major increment.

</summary>

property MajorUnitScale: ChartBaseUnitType

<summary>

Represens the major unit scale value for the category axis

when the CategoryType property is set to TimeScale.

</summary>

property MaxValue: float

property MinValue: float

property MinorUnit: float

<summary>

Value of minor increment.

</summary>

property MinorUnitScale: ChartBaseUnitType

<summary>

Represens the minor unit scale value for the category axis

when the CategoryType property is set to TimeScale.

</summary>

property NumberOfBins: int

<summary>

Get or set the Number of Bins in the axis

</summary>

<remarks>Applies only to Histogram and Pareto charts.Can be a value from 1 through 31999.</remarks>

property Offset: int

<summary>

Represents distance between the labels and axis line.

The value can be from 0 through 1000.

</summary>

property OverflowBinValue: float

<summary>

Get or Set the OverFlow Bin value

</summary>

<remarks>Applies only to Histogram and Pareto charts.</remarks>

property TickLabelSpacing: int

<summary>

Represents the number of categories or series between tick-mark labels.

</summary>

property TickMarkSpacing: int

<summary>

Represents the number of categories or series between tick marks.

</summary>

property TickMarksFrequency: int

<summary>

Frequency of tick marks.

</summary>

property UnderflowBinValue: float

<summary>

Get or Set the UnderFlow Bin value

</summary>

<remarks>Applies only to Histogram and Pareto charts.</remarks>