Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Description

A Series object represents a single data series in a chart. To return a Series object, use one of the SeriesCollection.CreateSeries methods.

C#
vb.net

Properties

Name

Description

AxisType

If the chart contains two X or Y axes, AxisType sets or returns whether the series is associated with the primary or secondary axis.

BubbleSizes

Sets or returns a range formula that determines the size of the bubbles in a bubble chart.

Bubble size is a way to illustrate a z-dimension on a chart. Every element in the series should have its own bubble that will be plotted on the graph. To give the bubble a numeric size, this method requires you to select a range of numeric values.

The output size of the bubbles will be a ratio between the smallest and largest bubble size values. For example, if the bubble sizes are 20, 20, and 20, all the bubbles will be the same size. However, if the values are 100, 2, and 1, the first bubble will be very large, the third extremely small, and the second two times as large as the third.

ChartType

Sets or returns the ChartType the series is displayed as.

DataLabels

Returns a SeriesDataLabel object for formatting series data labels.

DataPointMarker

Returns a DataPointMarker object representing the data markers of a line, radar, or scatter series.

ErrorBarX

Returns an ErrorBar object representing the horizontal error bars for the series.

ErrorBarY

Returns an ErrorBar object representing the vertical error bars for the series.

HasShadow

Sets or returns whether the series will be displayed with a shadow effect.

HasSmoothedLine

Sets or returns returns whether data points in a line, scatter, or radar chart are connected by smoothed lines, or whether the data points are connected by straight lines.

Interior

Returns a ChartInterior object, representing the area of the data series.

LegendEntryFont

Sets or returns the Font object for the series legend entry.

Line

Returns a ChartLine object representing either the border around the series - for most chart types - or the series line itself, for line charts.

Name

Sets or returns the name of the series. See also Series.NameFormula.

NameFormula

Sets or returns the formula containing the name of the series. See also Series.Name.

ScatterValues

Sets or returns the range of cells containing the x-values of a scatter or bubble chart data series.

SettingsBarColumn

Returns a SettingsBarColumn object representing the series properties unique to bar and column charts.

SettingsLineAreaScatter

Returns a SettingsLineAreaScatter object representing the series properties unique to line, area, and scatter charts.

SettingsPieDoughnut

Returns a SettingsPieDoughnut object representing the series properties unique to pie and doughnut charts.

ShowLegendEntry

Sets or returns whether the legend entry for this series will be shown.

Trendlines

Returns the Trendlines collection for the series. A trendline graphically shows trends in a data series, such as increased sales over a period of months.

Values

Sets or returns the range of cells containing the values of a chart data series.

VaryColorsByPoint

Sets or returns whether colors will be different for each data point in the series.

Indexers

Name

Description

Item(Int32)

Returns the DataPoint object at the specified 0-based index.

Methods

Name

Description

ChangeConfiguration(ChartType, AxisType)

Changes the ChartType and AxisType of the series at the same time.
  • No labels