Microsoft Office Tutorials and References
In Depth Information
Figure 21-27. Illustrating the data point legend
End If
Note that if there are no data labels for a given series, then the DataLabels method will generate an
error; we should check this first before calling the method, using the HasDataLabels property of
the Series object.
The visibility of a data label (not its existence) is governed by the HasDataLabel property of the
corresponding Point object (discussed later). Thus, the code:
ActiveChart.SeriesCollection(1).Points(1).HasDataLabel = False
suppresses the display of a data label for the first data point in the series.
We can use the ApplyDataLabels method to display or hide data labels and to change the type of
labels. The syntax for this method is:
expression .ApplyDataLabels( Type , LegendKey )
where expression can return either a Chart, Point, or Series object. When the method is applied
to a Chart object, it affects the data labels for all series in the chart at the same time.
The Type parameter is the data-label type and can be one of the following XlDataLabelsType
Enum XlDataLabelsType
xlDataLabelsShowNone = -4142
xlDataLabelsShowValue = 2
xlDataLabelsShowPercent = 3
xlDataLabelsShowLabel = 4
xlDataLabelsShowLabelAndPercent = 5
xlDataLabelsShowBubbleSizes = 6
End Enum
The optional LegendKey parameter can be set to True to show the legend key next to each data
point. The default value is False . Figure 21-27 s hows data point legends in action.
Figure 21-27. Illustrating the data point legend
The properties and methods of the DataLabel object are shown in Table 21-5 .
Search JabSto ::

Custom Search