Figure The Series object and its children

?Q Siries

?□ Border + To ChartFi HFoi-mat + "?□ DalaLabel - TU DniaLflh-ls ?0 Border fO ChartfiNFormnl t - ?Q DatflLfibai Border i To Cheraciers ?o ChertFillFarmai* 7-j Foni ?D IriteriCr

?c Font

äntsnor

Er'cr3s.is

?c Border

Interior

To

LeoderiJnes

?C Border

7Q

Point

TU

Po ni<_

_

ChartR Format* io DaiaLebQl-

iritieriTii

+ Triiliil.

The Series object has Border, ChartFillFormat, and Interior child object, which we have discussed before. Let us look at some of its other children.

The Series objects for a chart are contained in a collection object named SeriesCollection. This collection is returned by the SeriesCollection method of the Chart object. (We will see examples later in this section.)

The members of the Series object are shown in Table 21-4.

Table 21-4. Members of the Series Object

Application

ErrorBars

MarkerForegroundColorIndex

ApplyCustomType

Explosion

MarkerSize

ApplyDataLabels

Fill

MarkerStyle

ApplyPictToEnd

Formula

Name

ApplyPictToFront

FormulaLocal

Parent

ApplyPictToSides

FormulaR1C1

Paste

AxisGroup

FormulaR1 C1 Local

PictureType

BarShape

Has3DEffect

PictureUnit

Border

HasDataLabels

PlotOrder

BubbleSizes

HasErrorBars

Points

ChartType

HasLeaderLines

Select

ClearFormats

Interior

Shadow

Copy

InvertIfNegative

Smooth

Creator

LeaderLines

Trendlines

DataLabels

MarkerB ackgroundColor

Type

Delete

MarkerB ackgroundColorIndex

Values

ErrorBar

MarkerForegroundColor

XValues

0 0

Post a comment