Message-ID: <540982772.9805.1711703590229.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9804_445321681.1711703590229" ------=_Part_9804_445321681.1711703590229 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Series

Series

Description

=20

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

=20
C#
=20
[DefaultMember("Item")]
 public sealed class Series
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class Series
=20
=20

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Axis= Type

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

B= ubbleSizes

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

Bubble size is a way to illust= rate 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.

T= he output size of the bubbles will be a ratio between the smallest and larg= est 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.

Cha= rtType

Sets or returns the ChartType the series is displayed as.

Da= taLabels

Returns a SeriesDataLabel object for formatting series data labels.

DataPointMarker

Returns a DataPointMarker object representing the data markers of a line, rada= r, or scatter series.

Err= orBarX

Returns an Err= orBar object representing the horizontal error bars for the series.=20

Err= orBarY

Returns an Err= orBar object representing the vertical error bars for the series.

Has= Shadow

Sets or returns whether the series will be displ= ayed 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.

Inte= rior

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 Cha= rtLine object representing either the border around the series - for mo= st chart types - or the series line itself, for line charts.

Name=

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

N= ameFormula

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

ScatterValues

Sets or returns the range of cells containing th= e 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 prope= rties unique to line, area, and scatter charts.

SettingsPieDoughnut

Returns a SettingsPieDoughnut object representing the series properties un= ique to pie and doughnut charts.

ShowLegendEntry

Sets or returns whether the legend entry for thi= s series will be shown.

Tr= endlines

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

Values=

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

VaryColorsByPoint

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

Indexers

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Item(Int32)

Returns the D= ataPoint object at the specified 0-based index.
=20

Methods

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

ChangeConfiguration(ChartType, AxisType)

Changes the C= hartType and AxisType of t= he series at the same time.
------=_Part_9804_445321681.1711703590229--