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
A Series object represents a single =
data series in a chart. To return a Series
object, use one of =
the SeriesCollection=
.CreateSeries methods.
[DefaultMember("Item")] public sealed class Series=20
<DefaultMember("Item")> _ =09Public NotInheritable Class Series=20
Name | =20
Description | =20
---|---|
=20 | If the chart contains two X or Y axes, AxisType sets or returns whether the series = is associated with the primary or secondary axis. | =20
=20 | 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. | =20
=20 | Sets or returns the ChartType the series is displayed as. | =20
=20 | Returns a SeriesDataLabel object for formatting series data labels. | =20
=20 | Returns a DataPointMarker object representing the data markers of a line, rada= r, or scatter series. | =20
=20 | Returns an Err= orBar object representing the horizontal error bars for the series. | =20
=20 | Returns an Err= orBar object representing the vertical error bars for the series. | = =20
=20 | Sets or returns whether the series will be displ= ayed with a shadow effect. | =20
=20 | 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. | =20
=20 | Returns a ChartInterior object, representing the area of the data series. | = =20
=20 | Sets or returns the Font object for the series legend entry. | =20
Line= | =20
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. | =20
Name= | =20
Sets or returns the name of the series. See also= Series.NameFormula. | = =20
=20 | Sets or returns the formula containing the name = of the series. See also Series.Name. | =20
=20 | Sets or returns the range of cells containing th= e x-values of a scatter or bubble chart data series. | =20
=20 | Returns a SettingsBarColumn object representing the series properties unique= to bar and column charts. | =20
=20 | Returns a SettingsLineAreaScatter object representing the series prope= rties unique to line, area, and scatter charts. | =20
=20 | Returns a SettingsPieDoughnut object representing the series properties un= ique to pie and doughnut charts. | =20
=20 | Sets or returns whether the legend entry for thi= s series will be shown. | =20
=20 | 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. | = =20
=20 | Sets or returns the range of cells containing th= e values of a chart data series. | =20
=20 | Sets or returns whether colors will be different= for each data point in the series. | =20
Name | =20
Description | =20
---|---|
=20 | Returns the D= ataPoint object at the specified 0-based index. | =20
Name | =20
Description | =20
---|---|
=20 | Changes the C= hartType and AxisType of t= he series at the same time. | =20