Message-ID: <1643958552.9745.1711701310338.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9744_1494916115.1711701310338" ------=_Part_9744_1494916115.1711701310338 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 SeriesCollecti=
on.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, rad= ar, or scatter series. | =20
=20 | Returns an Er= rorBar object representing the horizontal error bars for the series.=20 |
=20 | Returns an Er= rorBar 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
=20 | 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. | =20
=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= a>. | =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 uniqu= e to bar and column charts. | =20
=20 | Returns a SettingsLineAreaScatter object representing the series prop= erties unique to line, area, and scatter charts. | =20
=20 | Returns a SettingsPieDoughnut object representing the series properties u= nique 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 tr= ends 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 = DataPoint object at the specified 0-based index. | =20
Name | =20
Description | =20
---|---|
=20 | Changes the = ChartType and AxisType of= the series at the same time. | =20