XlsChart module

class XlsChart.XlsChart

Bases: XlsWorksheetBase, ICloneParent, IChart

property AutoScaling: bool

property CanChartBubbleLabel: bool

<summary>

Returns True if chart can have bubble data labels. Read-only.

</summary>

property CanChartHaveSeriesLines: bool

<summary>

Returns True if chart can have series lines. Read-only.

</summary>

property CanChartPercentageLabel: bool

<summary>

Returns True if chart can have percentage data labels. Read-only.

</summary>

property CategoryAxisTitle: str

<summary>

Title of the category axis.

</summary>

property ChartArea: IChartFrameFormat

property ChartStartType: str

<summary>

Returns start type of chart type. Read-only.

</summary>

property ChartTitle: str

<summary>

Title of the chart.

</summary>

property ChartTitleFont: IFont

property ChartType: ExcelChartType

static CheckDataTablePossibility(startType: str, bThrowException: bool) → bool

CheckForSupportGridLine() → bool

Clone

<summary>

Clones current instance.

</summary> <param name=”parent”>Parent object.</param> <returns>Returns clone of current object.</returns>

static DEF_SUPPORT_ERROR_BARS() → List[str]

static DEF_SUPPORT_SERIES_AXIS() → List[ExcelChartType]

static DEF_SUPPORT_TREND_LINES() → List[ExcelChartType]

property DataRange: IXLSRange

property DataTable: IChartDataTable

property DefaultLinePattern: ChartLinePatternType

<summary>

Returns default line pattern for the chart. Read-only.

</summary>

property DefaultTextIndex: int

property DepthPercent: int

property DestinationType: ExcelChartType

<summary>

Gets chart type after type change.

</summary>

property DisplayAxisFieldButtons: bool

property DisplayBlanksAs: ChartPlotEmptyType

property DisplayEntireFieldButtons: bool

property DisplayLegendFieldButtons: bool

property DisplayValueFieldButtons: bool

property Elevation: int

property Floor: IChartWallOrFloor

property Font: FontWrapper

<summary>

Gets font which used for displaying axis text .

</summary>

property GapDepth: int

property HasChartArea: bool

<summary>

Indicates whether chart has chart area.

</summary>

property HasChartTitle: bool

<summary>

Indicates wheather the chart has title

</summary>

property HasDataTable: bool

property HasFloor: bool

<summary>

Gets value indicating whether floor object was created.

</summary>

property HasLegend: bool

property HasPivotTable: bool

<summary>

Indicates whether contains pivot table.

</summary>

property HasPlotArea: bool

property HasWalls: bool

<summary>

Gets value indicating whether floor object was created.

</summary>

property Height: float

property HeightPercent: int

property IsCategoryAxisAvail: bool

<summary>

Indicates whether chart has a category axis. Read-only.

</summary>

property IsChart3D: bool

<summary>

Returns True if chart is 3D. Read-only.

</summary>

property IsChartBar: bool

<summary>

Returns True if chart is a bar chart. Read-only.

</summary>

property IsChartBubble: bool

<summary>

Returns True if chart is a bubble chart. Read-only.

</summary>

property IsChartCone: bool

<summary>

Returns True if chart is a conical shape. Read-only.

</summary>

property IsChartCylinder: bool

<summary>

Returns True if chart is a cylinder shape. Read-only.

</summary>

property IsChartDoughnut: bool

<summary>

Returns True if chart is a doughnut chart. Read-only.

</summary>

property IsChartExploded: bool

<summary>

Returns True if chart is exploded. Read-only.

</summary>

property IsChartFloor: bool

<summary>

Returns True if chart has floor. Read-only.

</summary>

property IsChartLine: bool

<summary>

Returns True if chart is line. Read-only.

</summary>

property IsChartPie: bool

<summary>

Returns True if chart is a pie chart. Read-only.

</summary>

property IsChartPyramid: bool

<summary>

Returns True if chart is a pyramid shape. Read-only.

</summary>

property IsChartRadar: bool

<summary>

Returns True if chart is a radar chart. Read-only.

</summary>

property IsChartScatter: bool

<summary>

Returns True if chart is a scatter chart. Read-only.

</summary>

property IsChartSmoothedLine: bool

<summary>

Returns True if chart has smoothed lines. Read-only.

</summary>

property IsChartStock: bool

<summary>

Returns True if this is a stock chart. Read-only.

</summary>

property IsChartVeryColor: bool

<summary>

Returns True if chart should have a different color for each series value. Read-only.

</summary>

property IsChartVolume: bool

<summary>

Returns True if chart is a stock chart with volume. Read-only.

</summary>

property IsChartWalls: bool

<summary>

Returns True if chart has walls. Read-only.

</summary>

property IsChart_100: bool

<summary>

Returns True if chart is 100%. Read-only.

</summary>

property IsClustered: bool

<summary>

Returns True if chart is a clustered chart. Read-only.

</summary>

property IsEmbeded: bool

<summary>

Gets value indicating whether chart is embeded into worksheet.

</summary>

property IsPerspective: bool

<summary>

Returns True if chart has perspective. Read-only.

</summary>

property IsPivot3DChart: bool

<summary>

Gets a value indicating whether this instance is pivot 3D chart .

</summary>

property IsSecondaryAxes: bool

property IsSecondaryCategoryAxisAvail: bool

property IsSecondaryValueAxisAvail: bool

property IsSeriesAxisAvail: bool

property IsSeriesLines: bool

<summary>

Returns True if chart has series lines. Read-only.

</summary>

property IsSpecialDataLabels: bool

<summary>

Returns True if chart needs special data labels serialization.

Read-only.

</summary>

property IsStacked: bool

<summary>

Returns True if chart is stacked. Read-only.

</summary>

property IsValueAxisAvail: bool

<summary>

Indicates whehter chart has a value axis. Read-only.

</summary>

property Legend: IChartLegend

property NeedDataFormat: bool

<summary>

Returns True if chart needs data format to be saved. Read-only.

</summary>

property NeedDropBar: bool

<summary>

Returns True if chart needs drop bars to be saved. Read-only.

</summary>

property NeedMarkerFormat: bool

<summary>

Returns True if chart needs marker format to be saved. Read-only.

</summary>

property NoPlotArea: bool

<summary>

Returns True if chart has no plot area. Read-only.

</summary>

property PageSetup: IChartPageSetup

property Perspective: int

property PivotChartType: ExcelChartType

property PivotTable: PivotTable

property PlotArea: IChartFrameFormat

property PlotVisibleOnly: bool

property PrimaryCategoryAxis: IChartCategoryAxis

property PrimarySerieAxis: IChartSeriesAxis

property PrimaryValueAxis: IChartValueAxis

property RightAngleAxes: bool

property Rotation: int

property SecondaryCategoryAxis: IChartCategoryAxis

property SecondaryCategoryAxisTitle: str

<summary>

Title of the secondary category axis.

</summary>

property SecondaryValueAxis: IChartValueAxis

property SecondaryValueAxisTitle: str

<summary>

Title of the secondary value axis.

</summary>

property SeriesAxisTitle: str

<summary>

Title of the series axis.

</summary>

property SeriesDataFromRange: bool

<summary>

True if series are in rows in DataRange;

False otherwise.

</summary>

SetToDefaultGridlines(type: ExcelChartType)

property ShowReportFilterFieldButtons: bool

property SizeWithWindow: bool

property Style: int

<summary>

Style index for Excel 2007 chart.

</summary>

property SupportWallsAndFloor: bool

<summary>

Indicates whether this chart supports walls and floor. Read-only.

</summary>

property ValueAxisTitle: str

<summary>

Title of the value axis.

</summary>

property Walls: IChartWallOrFloor

property WallsAndGridlines2D: bool

property Width: float

property XPos: float

property YPos: float

property ZoomToFit: bool

<summary>

Gets or sets zoomToFit value.

</summary>