ChartSeries

ChartSeries class

Represents a chart series.

The ChartSeries type exposes the following members:

Properties

NameDescription
chartReturns the parent chart.
Read-only IChart.
explosionThe distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.
Read/write
smoothRepresents curve smoothing. True if curve smoothing is turned on for the line chart or scatter chart.
Applies only to line and scatter connected by lines charts.
Read/write bool.
nameReturn series name.
Read-only IStringChartValue.
data_pointsReturns collection of data points of this series.
Read-only IChartDataPointCollection.
typeReturns a type of this series.
Read/write ChartType.
plot_on_second_axisIndicates if this series is plotted on secondary axis.
Read/write bool.
parent_series_groupParentSeriesGroup.
Read-only IChartSeriesGroup.
formatReturns the format of a series.
Read-only IFormat.
orderReturns the order of a series.
Read/write
labelsReturns the Labels of a series.
Read-only IDataLabelCollection.
trend_linesCollection of series trend lines.
Read-only ITrendlineCollection.
error_bars_x_formatRepresents ErrorBars of series with derection X.
error_bars_y_formatRepresents ErrorBars of series with derection Y.
related_legend_entryRepresents legend entry related with this series
Read-only ILegendEntryProperties.
number_format_of_valuesNumberFormatOfValues.
Read/write string.
number_format_of_x_valuesNumberFormatOfXValues.
Read/write string.
number_format_of_y_valuesNumberFormatOfYValues.
Read/write string.
number_format_of_bubble_sizesNumberFormatOfBubbleSizes.
Read/write string.
markerMarker.
Read-only IMarker.
bar_3d_shapeSpecifies the shape of a series of a 3-D bar chart.
Changing of value of this property can cause to automatically changing Type of series.
Read/write ChartShapeType.
invert_if_negativeSpecifies the bar, column or bubble series shall invert its colors if the value is negative.
Read/write bool.
inverted_solid_fill_colorSpecifies invert solid color for series. To apply color setting set series format FillType to FillType.Solid.
Read/write ColorFormat.
show_inner_pointsRepresents inner points. True if inner points are shown on the BoxAndWhisker chart. Applies only to BoxAndWhisker charts.
Read/write bool.
show_outlier_pointsRepresents outlier points. True if outlier points are shown on the BoxAndWhisker chart. Applies only to BoxAndWhisker charts.
Read/write bool.
show_mean_markersRepresents mean markers. True if mean markers are shown on the BoxAndWhisker chart. Applies only to BoxAndWhisker charts.
Read/write bool.
show_mean_lineRepresents mean line. True if mean line are shown on the BoxAndWhisker chart. Applies only to BoxAndWhisker charts.
Read/write bool.
quartile_methodRepresents quartile method. Applies only to BoxAndWhisker charts.
show_connector_linesRepresents connector lines. Applies only to Waterfall charts.
parent_label_layoutRepresents layout of parent category labels. Applies only to Treemap charts.
has_up_down_barsDetermines whether Line- or Stock-chart has a up/down bars.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.UpDownBars.HasUpDownBars read/write property for change value.
Use ParentSeriesGroup.UpDownBars property for format up/down bars.
Read-only bool.
gap_widthSpecifies the space between bar or column clusters, as a percentage of the bar or column width.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.GapWidth read/write property for change value.
Read-only
gap_depthReturns or sets the distance, as a percentage of the marker width, between the data series in a 3D chart.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.GapDepth read/write property for change value.
Read-only
first_slice_angleSpecifies the angle of the first pie or doughnut chart slice,
in degrees (clockwise from up, from 0 to 360 degrees).
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.FirstSliceAngle read/write property for change value.
Read-only int.
doughnut_hole_sizeSpecifies the size of the hole in a doughnut chart (can be between 10 and 90 percents
of the size of the plot area.).
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.DoughnutHoleSize read/write property for change value.
Read-only int.
overlapSpecifies how much bars and columns shall overlap on 2-D charts (from -100 to 100).
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.Overlap read/write property for change value.
Read-only int.
second_pie_sizeSpecifies the size of the second pie or bar of a pie-of-pie chart or
a bar-of-pie chart, as a percentage of the size of the first pie (can
be between 5 and 200 percents).
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.SecondPieSize read/write property for change value.
Read-only int.
has_series_linesDetermines whether there are series lines for this series and kindred series.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.HasSeriesLines read/write property for change value.
Use ParentSeriesGroup.SeriesLinesFormat property for format series lines.
Read-only bool.
bubble_size_representationSpecifies how the bubble size values are represented on the bubble chart.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.BubbleSizeRepresentation read/write property for change value.
pie_split_positionSpecifies a value that shall be used to determine which data points
are in the second pie or bar on a pie-of-pie or bar-of-pie chart.
Is used together with PieSplitBy property.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.PieSplitPosition read/write property for change value.
Read-only float.
pie_split_bySpecifies how to determine which data points are in the second pie or bar
on a pie-of-pie or bar-of-pie chart.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.PieSplitBy read/write property for change value.
Read-only PieSplitType.
pie_split_custom_pointsThe custom split information for a pie-of-pie or bar-of-pie chart with a custom split.
Contains data points that shall be drawn in the second pie or bar in a pie-of-pie or
bar-of-pie chart.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property
Read-only PieSplitCustomPointCollection.
is_color_variedSpecifies that each data marker in the series has a different color.
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.IsColorVaried read/write property for change value.
Read-only bool.
bubble_size_scaleSpecifies the scale factor for the bubble chart (can be
between 0 and 300 percents of the default size).
This is the property not only of this series but of all series of parent series
group - this is projection of appropriate group property. And so this property
is read-only.
Use ParentSeriesGroup property for access to parent series group.
Use ParentSeriesGroup.BubbleSizeScale read/write property for change value.
as_i_chart_componentAllows to get base IChartComponent interface.
Read-only IChartComponent.
as_i_slide_componentAllows to get base ISlideComponent interface.
Read-only ISlideComponent.
slideReturns the base slide.
Read-only IBaseSlide.
as_i_presentation_componentAllows to get base IPresentationComponent interface.
Read-only IPresentationComponent.
presentationReturns the presentation.
Read-only IPresentation.

Methods

NameDescription
get_automatic_series_color()Returns an automatic color of series based on series index and chart style. This color is used by default if FillType equals NotDefined.

See Also