Message-ID: <1287384905.9947.1711707210342.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9946_227896158.1711707210342" ------=_Part_9946_227896158.1711707210342 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 SeriesCollecti= on.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

Name

Description

Axi= sType

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 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.

Ch= artType

Sets or returns the ChartType the series is displayed as.

D= ataLabels

Returns a SeriesDataLabel object for formatting series data labels.

DataPointMarker

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

Er= rorBarX

Returns an Er= rorBar object representing the horizontal error bars for the series.=20

Er= rorBarY

Returns an Er= rorBar object representing the vertical error bars for the series. =20

Ha= sShadow

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.

Int= erior

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 Ch= artLine object representing either the border around the series - for m= ost 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 th= e x-values of a scatter or bubble chart data series.

SettingsBarColumn

Returns a SettingsBarColumn object representing the series properties uniqu= e to bar and column charts.

SettingsLineAreaScatter

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

SettingsPieDoughnut

Returns a SettingsPieDoughnut object representing the series properties u= nique to pie and doughnut charts.

ShowLegendEntry

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

T= rendlines

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

Value= s

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 = DataPoint 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 = ChartType and AxisType of= the series at the same time.
------=_Part_9946_227896158.1711707210342--