XlsChartSerieDataFormat module

class XlsChartSerieDataFormat.XlsChartSerieDataFormat

Bases: XlsObject, IChartSerieDataFormat, IChartFillBorder

property AreaProperties: IChartInterior

property BackGroundColor: Color

<summary>: Represents background color.

</summary>

property BackGroundColorObject: OColor

<summary>: Represents background color.

</summary>

property BackGroundKnownColor: ExcelColors

<summary>: Represents background excel color.

</summary>

property BarTopType: TopFormatType

property BarType: BaseFormatType

property Fill: IShapeFill

property ForeGroundColor: Color

<summary>: Represents foreground color.

</summary>

property ForeGroundColorObject: OColor

<summary>: Represents foreground color object.

</summary>

property ForeGroundKnownColor: ExcelColors

<summary>: Represents foreground color.

</summary>

property Format3D: Format3D

property HasBorder: bool

<summary>: Indicates whether chart has border.

</summary>

property HasBorderLine: bool

<summary>: Indicates whethers chart has border line.

</summary>

property HasFormat3D: bool

property HasInterior: bool

property HasLineProperties: bool

property HasShadow: bool

property Has_dPtPieExplosion: bool

<summary>: Indicates whether dataformat has PieExplosion.

</summary>

property Interior: IChartInterior

property Is3DBubbles: bool

property IsAutoMarker: bool

property IsAutomaticFormat: bool

<summary>: Indicates, if automatic format is used.

</summary>

property IsBorderSupported: bool

<summary>: Indicates whether border object is supported. Read-only.

</summary>

property IsFormatted: bool

<summary>: Indicate if data format is formatted.

</summary>

property IsInteriorSupported: bool

<summary>: Indicates whether interior object is supported. Read-only.

</summary>

property IsMarker: bool

<summary>: If true - format has marker; otherwise false. Read-only.

</summary>

property IsMarkerSupported: bool

property IsShadow: bool

property IsShowBackground: bool

<summary>: True = “background = none”.

</summary>

property IsShowForeground: bool

<summary>: True = “foreground = none”.

</summary>

property IsSmoothed: bool

<summary>: If true - format has smothed line; otherwise false. Read-only.

</summary>

property IsSmoothedLine: bool

property IsSupportFill: bool

<summary>: Indicats whether chart supports transparency.

</summary>

property LineProperties: ChartBorder

property MarkerBackColorObject: OColor

<summary>: Gets object that holds marker background color.

</summary>

property MarkerBackgroundColor: Color

property MarkerBackgroundKnownColor: ExcelColors

property MarkerBorderWidth: float

<summary>: Marker border weight(unit pt).

</summary>

property MarkerFill: IShapeFill

<summary>

Get fill object of the marker.: <example><para>The following code illustrates how to fill a marker . </para><code>

var markerFill = chart.Series[0].Format.MarkerFill; //fill by defined Texture markerFill.Texture = GradientTextureType.GreenMarble;

//fill by defined Pattern markerFill.Pattern = GradientPatternType.PatLargeCheckerBoard; //Pattern need set fore/background color markerFill.ForeColor = Color.Blue; markerFill.BackColor = Color.Red; //fill by a picture markerFill.CustomPicture(“type1.png”) //set transparency: value from 0.0 (Clear) through 1.0(Opaque) markerFill.Transparency = 0.5; </code> </example>

</summary>

property MarkerForeColorObject: OColor

<summary>: Gets object that holds marker foreground color.

</summary>

property MarkerForegroundColor: Color

property MarkerForegroundKnownColor: ExcelColors

property MarkerSize: int

property MarkerStyle: ChartMarkerType

property MarkerTransparencyValue: float

<summary>: Gets or sets the transparency of the line marker.

</summary>

<value>The transparency.</value>

property Options: IChartFormat

property ParentSerie: XlsChartSerie

property Pattern: ExcelPatternType

<summary>: Represents pattern.

</summary>

property Percent: int

property QuartileCalculationType: ExcelQuartileCalculation

<summary>: Gets / Sets whether the Quartile calculation is Exclusive or Inclusive

</summary>

<remarks>Applies only to Box and Whisker Charts</remarks>

property SeriesNumber: int

property Shadow: ChartShadow

property ShowActiveValue: bool

property ShowBubble: bool

property ShowCategoryLabel: bool

property ShowConnectorLines: bool

<summary>

Gets or sets a boolean value indicating whether to display
Connector Lines between data points

</summary>

<remarks>Applies only to Waterfall Charts</remarks>

property ShowInnerPoints: bool

<summary>

Gets or sets a boolean value indicating whether to display: Inner Points in Box and Whisker chart

</summary>

property ShowMeanLine: bool

<summary>

Gets or sets a boolean value indicating whether to display: Mean Line in Box and Whisker chart

</summary>

property ShowMeanMarkers: bool

<summary>

Gets or sets a boolean value indicating whether to display: Mean Marker in Box and Whisker chart

</summary>

property ShowOutlierPoints: bool

<summary>

Gets or sets a boolean value indicating whether to display: Outlier Points in Box and Whisker chart

</summary>

property ShowPieCategoryLabel: bool

property ShowPieInPercents: bool

property SmoothLine: bool

property TreeMapLabelOption: ExcelTreeMapLabelOption

<summary>: Gets / Sets the Display label position in Tree map chart

</summary>

<remarks>By Default the Label is overlapped</remarks>

property Visible: bool

<summary>: Represents visiblity.

</summary>