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

SeriesCollection

Description

=20

The SeriesCollection class contains the set of data series in a given ch= art.

=20
C#
=20
[DefaultMember("Item")]
 public sealed class SeriesCollection : System.Collections.Generic.IEnumera=
ble<Series>
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class SeriesCollection
=09=09Implements System.Collections.Generic.IEnumerable(Of Series)
=20
=20

Remarks

=20

To return a SeriesCollection object, use Chart.SeriesCollection.=

=20

A SeriesCollection is made up all of the series in a chart. These series= may be of the same type or a different type from the chart itself; a chart= may contain series of multiple ChartTypes on different axes. However, not all series configu= rations are valid.

=20

Surface, bubble, and 3D series may not be combined on a chart with serie= s of a different ChartCategory. For example, a Bubble chart may contain both 2D= and 3D Bubble series, but may not contain any Line series. Similarly, a 3D= Area chart may contain 3D area series, but may not contain any other serie= s types. Additionally, these chart types may not have any series on the Sec= ondary axis.

=20

Pie, Doughnut, Bar, and Radar charts can be combined with series of othe= r chart categories, but only if the other series is on a different axis. Fo= r example, a bar series on the primary axis can be in the same chart as a c= olumn series on the secondary axis, but it cannot be in the same chart as a= column series on the primary axis.

=20

If you attempt to create a series that would violate these constraints, = or change a series configuration such that these constraints would no longe= r be followed, then an ArgumentException will be thrown.

=20

A last consideration is that for all series types except for Bubble and = Pie series, series within the same ChartCategory cannot coexist on the same axi= s. If you add a series to an axis that already has series of the same ChartCategory= but different Cha= rtType, the existing series will be converted to the new ChartType. For= example, if you have a StandardLine series on the primary axis, and you cr= eate a new StackedLine series on the primary axis, both series will now be = StackedLine series. If you had added it to the secondary axis, however, the= n you would have one StandardLine series on the primary axis, and one Stack= edLine series on the secondary axis.

=20

Properties

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

Name

Description

CategoryData

Sets or Returns a formula referencing a range o= f cells (e.g. "A1:A5"). The values in these cells are used for th= e labels on the primary category (x) axis of the chart. For scatter and bub= ble charts, this property will return an empty string. To get the values us= ed on the horizontal axis for a scatter or bubble series, use Series.ScatterValues instead.

Count

Returns the number of data series in the collec= tion.

SecondaryCategoryData

Sets or Returns a formula referencing a range o= f cells (e.g. "A1:A5"). The values in these cells are used for th= e labels on the secondary category (x) axis of the chart.
=20

Indexers

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

Name

Description

Item(Int32)

Returns the Se= ries at the specified index.
=20

Methods

=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

CreateSeries(Area)

=20
Creates a new = Series that is automatically added to the SeriesCollection. The series will be plotted on the prima= ry axis, and its type will be the chart's ChartType.

CreateSeries(Area, ChartType, AxisType)

Creates a new = Series that is automatically added to the SeriesCollection.

CreateSeries(Range)

=20
Creates a new = Series that is automatically added to the SeriesCollection. The series will be plotted on the prima= ry axis, and its type will be the chart's ChartType.

CreateSeries(Range, ChartType, AxisType)

Creates a new = Series that is automatically added to the SeriesCollection.

CreateSeries(String)

=20
Creates a new = Series that is automatically added to the SeriesCollection. The series will be plotted on the prima= ry axis, and its type will be the chart's ChartType.

CreateSeries(String, ChartType, AxisType)

Creates a new = Series that is automatically added to the SeriesCollection.

GetEnumerator()

Returns an IEnumerator for the SeriesCollect= ion of a Chart

Remove(Int32)

Removes the specified Series from the collection.

Remove(Series)

Removes the specified Series from the collection.
------=_Part_9714_1897879673.1711699838369--