GrapeCity.Documents.Excel.Drawing.ISeries

ISeries Interface

Represents a series in a chart.

An ISeries object stores the data and formatting for a single chart series and is a member of the ISeriesCollection collection. Use this interface to access series-level settings such as the chart type, axis group, markers, data labels, error bars, and trendlines.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISeries

Public Interface ISeries

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", 14},
    {"Mar", 18}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
ISeries series = shape.Chart.SeriesCollection[0];

Properties

Name	Description
AxisGroup	Gets or sets the axis group of the series. The axis group indicates whether the series is plotted on the primary or secondary axis.
BarShape	Gets or sets the shape used with the 3-D bar or column chart for this series. Use this property to control how the current series is rendered in a 3-D bar or 3-D column chart. If a bar shape has not been set on the series, this property returns the bar shape of the parent chart.
BubbleSizes	Gets or sets an array that contains the size data for the bubble chart. Applies only to bubble charts.
ChartType	Gets or sets the chart type of the series.
DataLabels	Gets the collection of data labels for the series.
Explosion	Gets or sets the explosion value for the slices in a pie or doughnut series. Returns `0` if the slices are not exploded and the tip of each slice remains at the center of the pie.
Format	Gets the format of the series.
Formula	Gets or sets the series formula in A1-style notation. The returned formula describes the series definition by using A1-style references.
FormulaR1C1	Gets or sets the formula for the object using R1C1-style notation. Use this property to retrieve the series formula when you need row-and-column relative references instead of A1-style references. To work with the formula in A1-style notation, use Formula.
Has3DEffect	Gets or sets whether the series has a three-dimensional appearance. This property applies only to bubble charts.
HasDataLabels	Gets or sets whether the series has data labels. This property indicates whether data labels are displayed for the series in the chart.
HasErrorBars	Gets or sets whether the series has error bars. This property is not available for 3-D charts.
InvertColor	Gets the fill color for negative data points in a series. Use this property together with InvertIfNegative to control how negative values are displayed in the series.
InvertIfNegative	Gets or sets whether Microsoft Excel inverts the pattern in the series when a data point corresponds to a negative number. When this property is `true`, negative data points in the series use the inverted pattern. This setting can be used together with InvertColor to control the appearance of negative values.
MarkerFormat	Gets the marker format for this series. Use the returned IChartFormat object to configure the fill and line formatting of markers in the series.
MarkerSize	Gets or sets the data-marker size in points. Use this property to retrieve the marker size applied to the series.
MarkerStyle	Gets or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Use this property to retrieve the current marker appearance applied to the series.
Name	Gets or sets the name of the series.
Parent	Gets the parent IChartGroup that contains this series. Use this property to access chart group settings shared by the series, such as group-level formatting and axis group options.
ParentDataLabelOption	Gets or sets the parent data label option for the specified series within the chart group. This property indicates how parent data labels are displayed for a series that supports parent labels.
PictureType	Gets or sets the way pictures are displayed on a column or bar picture chart. Use this property to determine whether pictures in the series are stretched, stacked, or stacked according to a specified unit.
PictureUnit	Gets or sets the unit for each picture in the series when the picture type is set to StackScale. This property is used only when the series picture type is StackScale.
PlotOrder	Gets or sets the plot order for the selected series within the chart group. The plot order determines the position of the series relative to other series in the same chart group.
Points	Gets the collection of data points in the series.
QuartileCalculationInclusiveMedian	Gets or sets whether the median is included in the quartile calculation when the quartiles are computed by using the inclusive median method. This property is valid only for boxwhisker charts.
ShowConnectorLines	Gets or sets whether to show the connector lines that connect the end of each column to the beginning of the next column. The default value is `true`. This property is valid only for waterfall charts.
ShowInnerPoints	Gets or sets whether to show the data points that lie between the lower whisker line and the upper whisker line. This property is valid only for boxwhisker charts.
ShowMeanLine	Gets or sets whether to show the line connecting the means of the boxes in the selected series. This property is valid only for boxwhisker charts.
ShowMeanMarkers	Gets or sets whether to show the mean marker of the selected series. The default value is `true`. This property is valid only for boxwhisker charts.
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`. This property is valid only for boxwhisker charts.
Smooth	Gets or sets whether curve smoothing is enabled for the series. Returns `true` if curve smoothing is turned on for a line chart or scatter chart series. Applies only to line and scatter charts.
Trendlines	Gets the collection of trendlines for the series. Use this property to access, add, or enumerate the ITrendline objects associated with the series.
Values	Gets or sets all values in the series. The values can come from a worksheet range or from an array of constant values, but not from a combination of both.
XErrorBar	Gets the X direction error bar for the series. Use the returned IErrorBar object to read or modify the error bar settings for X values in the series. X direction error bars are supported for scatter series.
XValues	Gets or sets the array of x values for the chart series.
YErrorBar	Gets the Y direction error bar for the series. Use the returned IErrorBar object to read or modify the error bar settings for Y values in the series.

Methods

Name	Description
ClearFormats()	Clears the formatting of this series. Use this method to remove custom formatting that has been applied to the series.
Delete()	Deletes this series from its chart. After this method is called, the current series is removed from the chart's series collection.

Name

Description

ClearFormats()

Clears the formatting of this series.

Use this method to remove custom formatting that has been applied to the series.

Delete()

Deletes this series from its chart.

After this method is called, the current series is removed from the chart's series collection.