DataLabelCollection.SetReference(CellRange) Method

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

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v26.1.Core.dll

Declaration

C#

void SetReference(
    CellRange range
)

VB.NET

Sub SetReference(
    range As CellRange
)

Parameters

Name	Type	Description
range	CellRange	A cell range used as a reference to data labels.

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.

Example

The following code snippet uses cell values as data labels:

C#

using DevExpress.Spreadsheet;
using DevExpress.Spreadsheet.Charts;

Worksheet worksheet = workbook.Worksheets["chartTask5"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a chart and specify its location
Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B2:C8"]);
chart.TopLeftCell = worksheet.Cells["F2"];
chart.BottomRightCell = worksheet.Cells["L15"];
// Specify the chart style
chart.Style = ChartStyle.ColorGradient;

chart.Series[0].UseCustomDataLabels = true;
var customDataLabels = chart.Series[0].CustomDataLabels;
customDataLabels.SetReference(worksheet["D3:D8"]);

VB.NET

Imports DevExpress.Spreadsheet
Imports DevExpress.Spreadsheet.Charts

Dim worksheet As Worksheet = workbook.Worksheets("chartTask5")
workbook.Worksheets.ActiveWorksheet = worksheet

' Create a chart and specify its location
Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet("B2:C8"))
chart.TopLeftCell = worksheet.Cells("F2")
chart.BottomRightCell = worksheet.Cells("L15")
' Specify the chart style
chart.Style = ChartStyle.ColorGradient

chart.Series(0).UseCustomDataLabels = True
Dim customDataLabels = chart.Series(0).CustomDataLabels
customDataLabels.SetReference(worksheet("D3:D8"))