DataLabelCollection.SetReference(String) Method

Specifies the cell range used as a source for the data labels.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void SetReference(
    string expression
)

VB.NET

Sub SetReference(
    expression As String
)

Parameters

Name	Type	Description
expression	String	A string that is the cell reference.

Exceptions

Type	Description
InvalidOperationException	Thrown if the passed range is a 2D range (contains more than one row and/or column).
ArgumentException	Thrown if the passed range is a union (complex) range.

Remarks

Set the Series.UseCustomDataLabels property to true to specify cell values as data labels.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetReference(String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/CodeExamples/DataLabelsActions.cs#L140

var customDataLabels = chart.Series[0].CustomDataLabels;
customDataLabels.SetReference("D3:D8");
#endregion #DataLabelsFromCells

winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/DataLabelsActions.cs#L139

var customDataLabels = chart.Series[0].CustomDataLabels;
customDataLabels.SetReference("D3:D8");
#endregion #DataLabelsFromCells

VB.NET

wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/DataLabelsActions.vb#L143

Dim customDataLabels = chart.Series(0).CustomDataLabels
customDataLabels.SetReference("D3:D8")
'            #End Region ' #DataLabelsFromCells

winforms-spreadsheet-chart-api/VB/SpreadsheetChartAPISamples/CodeExamples/DataLabelsActions.vb#L140

            Dim customDataLabels = chart.Series(0).CustomDataLabels
            customDataLabels.SetReference("D3:D8")
#End Region