GrapeCity.Documents.Excel.Drawing.ISeries

Interface ISeries

Namespace

GrapeCity.Documents.Excel.Drawing

Assembly

GcDocs.Excel.dll

Represents a series in a chart. The Series object is a member of the ISeriesCollection collection.

public interface ISeries

Properties

AxisGroup

Returns the group for the specified chart group or series.

AxisGroup AxisGroup { get; set; }

Property Value

AxisGroup

BarShape

Returns or sets the shape used with the 3-D bar or column chart.

BarShape BarShape { get; set; }

Property Value

BarShape

BubbleSizes

Gets or sets an array that contains the size data for the bubble chart. Applies only to bubble charts.

double?[] BubbleSizes { get; set; }

Property Value

double?[]

ChartType

Gets or sets the chart type.

ChartType ChartType { get; set; }

Property Value

ChartType

DataLabels

Returns an object that represents a collection of all the data labels for the series.

IDataLabels DataLabels { get; }

Property Value

IDataLabels

Explosion

Gets or sets the explosion value for a pie-chart or doughnut-chart slice.
Returns 0 (zero) if there is no explosion (the tip of the slice is in the
center of the pie).

int Explosion { get; set; }

Property Value

int

Format

Returns the IChartFormat object.

IChartFormat Format { get; }

Property Value

IChartFormat

Formula

Gets or sets the object's formula in A1-style notation.

string Formula { get; set; }

Property Value

string

FormulaR1C1

Gets or sets the formula for the object using R1C1-style notation.

string FormulaR1C1 { get; set; }

Property Value

string

Has3DEffect

Gets or sets whether the series has a three-dimensional appearance. Applies only to bubble charts.

bool Has3DEffect { get; set; }

Property Value

bool

HasDataLabels

Gets or sets whether the series has data labels.

bool HasDataLabels { get; set; }

Property Value

bool

HasErrorBars

Gets or sets whether the series has error bars. This property isn’t available for 3-D charts.

bool HasErrorBars { get; set; }

Property Value

bool

InvertColor

Gets or sets the fill color for negative data points in a series.

IColorFormat InvertColor { get; }

Property Value

IColorFormat

InvertIfNegative

Gets or sets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.

bool InvertIfNegative { get; set; }

Property Value

bool

MarkerFormat

Returns the IChartFormat for the markers of this series.

IChartFormat MarkerFormat { get; }

Property Value

IChartFormat

MarkerSize

Gets or sets the data-marker size in points.

int MarkerSize { get; set; }

Property Value

int

MarkerStyle

Gets or sets the marker style for a point or series in a line chart, scatter chart, or radar chart.

MarkerStyle MarkerStyle { get; set; }

Property Value

MarkerStyle

Name

Gets or sets the name of the object.

string Name { get; set; }

Property Value

string

Parent

Returns the parent object for the specified object.

IChartGroup Parent { get; }

Property Value

IChartGroup

ParentDataLabelOption

Gets or sets the parent data label option for the specified series within the chart group.

ParentDataLabelOptions ParentDataLabelOption { get; set; }

Property Value

ParentDataLabelOptions

PictureType

Gets or sets the way pictures are displayed on a column or bar picture chart.

DrawingPictureType PictureType { get; set; }

Property Value

DrawingPictureType

PictureUnit

Gets or sets the unit for each picture on the chart if the PictureType property is set to Scale (if not, this property is ignored).

double PictureUnit { get; set; }

Property Value

double

PlotOrder

Gets or sets the plot order for the selected series within the chart group.

int PlotOrder { get; set; }

Property Value

int

Points

Returns an object that represents a collection of all the points in the series.

IPoints Points { get; }

Property Value

IPoints

QuartileCalculationInclusiveMedian

Gets or sets whether the median is included in the calculation if N (the number of values in the data) is odd. Valid only for boxwhisker charts.

bool QuartileCalculationInclusiveMedian { get; set; }

Property Value

bool

ShowConnectorLines

Gets or sets whether to show the connector lines which connect the end of each column to the beginning of the next column. The default value is true. Valid only for waterfall charts.

bool ShowConnectorLines { get; set; }

Property Value

bool

ShowInnerPoints

Gets or sets whether to show the data points that lie between the lower whisker line and the upper whisker line. Valid only for boxwhisker charts.

bool ShowInnerPoints { get; set; }

Property Value

bool

ShowMeanLine

Gets or sets whether to show the line connecting the means of the boxes in the selected series. Valid only for boxwhisker charts.

bool ShowMeanLine { get; set; }

Property Value

bool

ShowMeanMarkers

Gets or sets whether to show the mean marker of the selected series. The default value is true. Valid only for boxwhisker charts.

bool ShowMeanMarkers { get; set; }

Property Value

bool

ShowOutlierPoints

Gets or sets whether to show the outlier points that lie either below the lower whisker line or above the upper whisker line. The default value is true. Valid only for boxwhisker charts.

bool ShowOutlierPoints { get; set; }

Property Value

bool

Smooth

Gets or sets the curve smoothing setting (True if curve smoothing is turned on for the line chart or scatter chart). Applies only to line and scatter charts.

bool Smooth { get; set; }

Property Value

bool

Trendlines

Returns an object that represents a collection of all the trendlines for the series.

ITrendlines Trendlines { get; }

Property Value

ITrendlines

Values

Gets or sets a collection of all the values in the series. This can come from a range on a worksheet or an array of constant values, but not a combination of both.

double?[] Values { get; set; }

Property Value

double?[]

XErrorBar

Returns an ErrorBar object that represents the X direction error bar for the series.

IErrorBar XErrorBar { get; }

Property Value

IErrorBar

XValues

Gets or sets an array of x values for a chart series. The XValues property can come from a range on a worksheet or an array of values, but it cannot be a combination of both.

object[] XValues { get; set; }

Property Value

object[]

YErrorBar

Returns an ErrorBar object that represents the Y direction error bar for the series.

IErrorBar YErrorBar { get; }

Property Value

IErrorBar

Methods

ClearFormats()

Clears the formatting of the object.

void ClearFormats()

Delete()

Deletes the object.

void Delete()