Click or drag to resize

ChartSerieDataFormat Properties

The ChartSerieDataFormat type exposes the following members.

Properties
Name Description
Public property AreaProperties
Returns object, that represents aera properties. Read only.
Public property BackGroundColor
Represents background color.
(Inherited from XlsChartSerieDataFormat .)
Public property BackGroundColorObject
Represents background color.
(Inherited from XlsChartSerieDataFormat .)
Public property BackGroundKnownColor
Represents background excel color.
(Inherited from XlsChartSerieDataFormat .)
Public property BarTopType
Represents the top data format.
(Inherited from XlsChartSerieDataFormat .)
Public property BarType
Represents the base data format.
(Inherited from XlsChartSerieDataFormat .)
Public property Fill
Represents XlsFill options. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property ForeGroundColor
Represents foreground color.
(Inherited from XlsChartSerieDataFormat .)
Public property ForeGroundColorObject
Represents foreground color object.
(Inherited from XlsChartSerieDataFormat .)
Public property ForeGroundKnownColor
Represents foreground color.
(Inherited from XlsChartSerieDataFormat .)
Public property Format3D
Gets the chart3 D properties.
(Inherited from XlsChartSerieDataFormat .)
Public property Has_dPtPieExplosion
Indicates whether dataformat has PieExplosion.
(Inherited from XlsChartSerieDataFormat .)
Public property HasBorder
Indicates whether chart has border.
(Inherited from XlsChartSerieDataFormat .)
Public property HasBorderLine
Indicates whethers chart has border line.
(Inherited from XlsChartSerieDataFormat .)
Public property HasFormat3D
Gets a value indicating whether [has3d properties].
(Inherited from XlsChartSerieDataFormat .)
Public property HasInterior
This property indicates whether interior object was created. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property HasLineProperties
This property indicates whether line formatting object was created. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property HasShadow
Gets a value indicating whether this instance has shadow properties.
(Inherited from XlsChartSerieDataFormat .)
Public property Interior
Returns object, that represents area properties. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property Is3DBubbles
True to draw bubbles with 3D effects.
(Inherited from XlsChartSerieDataFormat .)
Public property IsAutoMarker
Automatic color.
(Inherited from XlsChartSerieDataFormat .)
Public property IsAutomaticFormat
Indicates, if automatic format is used.
(Inherited from XlsChartSerieDataFormat .)
Public property IsBorderSupported
Indicates whether border object is supported. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property IsFormatted
Indicate if data format is formatted.
(Inherited from XlsChartSerieDataFormat .)
Public property IsInteriorSupported
Indicates whether interior object is supported. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property IsMarker
If true - format has marker; otherwise false. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property IsMarkerSupported
Indicates whether marker is supported by this chart/series.
(Inherited from XlsChartSerieDataFormat .)
Public property IsShadow Obsolete.
True if this series has a shadow.
(Inherited from XlsChartSerieDataFormat .)
Public property IsShowBackground
True = "background = none".
(Inherited from XlsChartSerieDataFormat .)
Public property IsShowForeground
True = "foreground = none".
(Inherited from XlsChartSerieDataFormat .)
Public property IsSmoothed
If true - format has smothed line; otherwise false. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property IsSmoothedLine
True if the line series has a smoothed line.
(Inherited from XlsChartSerieDataFormat .)
Public property IsSupportFill
Indicats whether chart supports transparency.
(Inherited from XlsChartSerieDataFormat .)
Public property LineProperties
Returns object, that represents line properties. Read only.
Public property MarkerBackColorObject
Gets object that holds marker background color.
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerBackgroundColor
Foreground color: RGB value (high byte = 0).
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerBackgroundKnownColor
Index to color of marker XlsFill.
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerBorderWidth
Marker border weight(unit pt).
(Inherited from XlsChartSerieDataFormat .)
Public property Code example MarkerFill
Get fill object of the marker.
Examples

The following code illustrates how to fill a marker .

Copy 
<para>var markerFill = chart.Series[0].Format.MarkerFill;</para><para>//fill by defined Texture</para><para>markerFill.Texture = GradientTextureType.GreenMarble;</para><para></para><para>//fill by defined Pattern</para><para>markerFill.Pattern = GradientPatternType.PatLargeCheckerBoard;</para><para>//Pattern need set fore/background color</para><para>markerFill.ForeColor = Color.Blue;</para><para>markerFill.BackColor = Color.Red;</para><para>//fill by a picture</para><para>markerFill.CustomPicture("type1.png")</para><para>//set transparency: value from 0.0 (Clear) through 1.0(Opaque)</para><para>markerFill.Transparency = 0.5;</para>
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerForeColorObject
Gets object that holds marker foreground color.
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerForegroundColor
Background color: RGB value (high byte = 0).
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerForegroundKnownColor
Index to color of marker border.
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerSize
Size of line markers.
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerStyle
Type of marker.
(Inherited from XlsChartSerieDataFormat .)
Public property MarkerTransparencyValue
Gets or sets the transparency of the line marker.
(Inherited from XlsChartSerieDataFormat .)
Public property Options
Gets common serie options. Read-only.
(Inherited from XlsChartSerieDataFormat .)
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property ParentSerie
Returns parent serie. Read-only.
Public property Pattern
Represents pattern.
(Inherited from XlsChartSerieDataFormat .)
Public property Percent
Distance of pie slice from center of pie.
(Inherited from XlsChartSerieDataFormat .)
Public property QuartileCalculationType
Gets / Sets whether the Quartile calculation is Exclusive or Inclusive
(Inherited from XlsChartSerieDataFormat .)
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property SeriesNumber Obsolete.
Gets or sets serie number.
(Inherited from XlsChartSerieDataFormat .)
Public property Shadow
Gets the shadow properties.
(Inherited from XlsChartSerieDataFormat .)
Public property ShowActiveValue Obsolete.
Indicates whether chart show active value.
(Inherited from XlsChartSerieDataFormat .)
Public property ShowBubble Obsolete.
Show bubble sizes.
(Inherited from XlsChartSerieDataFormat .)
Public property ShowCategoryLabel Obsolete.
Show category label.
(Inherited from XlsChartSerieDataFormat .)
Public property ShowConnectorLines
Gets or sets a boolean value indicating whether to display Connector Lines between data points
(Inherited from XlsChartSerieDataFormat .)
Public property ShowInnerPoints
Gets or sets a boolean value indicating whether to display Inner Points in Box and Whisker chart
(Inherited from XlsChartSerieDataFormat .)
Public property ShowMeanLine
Gets or sets a boolean value indicating whether to display Mean Line in Box and Whisker chart
(Inherited from XlsChartSerieDataFormat .)
Public property ShowMeanMarkers
Gets or sets a boolean value indicating whether to display Mean Marker in Box and Whisker chart
(Inherited from XlsChartSerieDataFormat .)
Public property ShowOutlierPoints
Gets or sets a boolean value indicating whether to display Outlier Points in Box and Whisker chart
(Inherited from XlsChartSerieDataFormat .)
Public property ShowPieCategoryLabel Obsolete.
Show category label and value as a percentage (pie charts only).
(Inherited from XlsChartSerieDataFormat .)
Public property ShowPieInPercents Obsolete.
Show value as a percent of the total.(pie charts only).
(Inherited from XlsChartSerieDataFormat .)
Public property SmoothLine Obsolete.
Show smoothed line.
(Inherited from XlsChartSerieDataFormat .)
Public property TreeMapLabelOption
Gets / Sets the Display label position in Tree map chart
(Inherited from XlsChartSerieDataFormat .)
Public property Visible
Represents visiblity.
(Inherited from XlsChartSerieDataFormat .)
Top
See Also