Microsoft Office Tutorials and References
In Depth Information
Table 21-5. Members of the DataLabel Object
ble 21-5. Members of the DataLab el Object
Application
Font
ReadingOrder
AutoScaleFont
HorizontalAlignment
Select
AutoText
Interior
Shadow
Border
Left
ShowLegendKey
Caption
Name
Text
Characters
NumberFormatLinked
Top
Creator
Orientation
Type
Delete
Parent
VerticalAlignment
Fill
Position
Note that on a trendline (discussed later in this chapter), the DataLabel property returns the text
shown with the trendline. This text can be the equation, the R-squared value, or both (if both are
showing).
21.15.3 The Point Object
A Point object represents a single data point in a series. The Point object for the points in a given
series are contained in the Points collection for the Series object. This collection is returned by the
Points property of the Series object.
The Point object has the following children: Border, ChartFillFormat, DataLabel, and Interior. The
members of the Point object are shown in Table 21-6 . Most of these members are self-explanatory.
Let us look briefly at some of the others.
able 21-6. Members of the Point Object
Application
Delete
MarkerSize
ApplyDataLabels
Explosion
MarkerStyle
ApplyPictToEnd
Fill
Parent
ApplyPictToFront
HasDataLabel
Paste
ApplyPictToSides
Interior
PictureType
Border
InvertIfNegative
PictureUnit
ClearFormats
MarkerBackgroundColor
SecondaryPlot
Copy
MarkerBackgroundColorIndex
Select
Creator
MarkerForegroundColor
Shadow
DataLabel
MarkerForegroundColorIndex
21.15.3.1 Explosion property
This property returns or sets the explosion value for a pie-chart or doughnut-chart slice. Figure 21-
shows an explosion value of 20, the result of the following code: 28
ActiveChart.SeriesCollection(1).Points(2).Explosion = 20
Note that the Explosion property can be applied to a data series, in which case it "explodes" all of
the segments. An explosion value of 0 corresponds to no explosion.
Figure 21-28. Explosion = 20
 
 
 
 
Search JabSto ::




Custom Search