DataLabel Property

  • Article

Returns a ChDataLabel object that represents the data label associated with the specified trendline. Read-only.

expression.DataLabel

*expression   * Required. An expression that returns a ChTrendline object.

Example

This example adds a trendline to the specified series in the chart workspace, sets the font for the data label to bold, and causes the trendline to display only its equation (the R-squared value is not displayed).

Sub AddTrendLine() Dim trndline ' Add a trendline to the first series in the first chart in ChartSpace1. Set trndline = ChartSpace1.Charts(0).SeriesCollection(0).Trendlines.Add ' Set the font of the trendline to bold. trndline.DataLabel.Font.Bold = True ' Do not display the R-Squared value with the trendline. trndline.IsDisplayingRSquared = False ' Display the equation for the trendline. trndline.IsDisplayingEquation = TrueEnd Sub

Applies to | ChTrendline Object

See Also | ChDataLabel Object