ChartText.SetReference(String) Method
Specifies the cell that is the source for the text used in a chart element.
Namespace: DevExpress.Spreadsheet.Charts
Assembly: DevExpress.Spreadsheet.v18.2.Core.dll
Declaration
Parameters
Name | Type | Description |
---|---|---|
expression | String | A string that is the cell reference. |
Remarks
The example below demonstrates how to add data series to a chart and change the cell range containing data for a specific series.
The code uses the SeriesCollection.Add method to create a series and add it to the ChartObject.Series collection. To specify series values contained in the worksheet range, create a ChartData object using the ChartData.FromRange method and assign it to the Series.Values property.
The ChartText.SetReference method is used to link the Series.SeriesName to the content of the worksheet cell.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheet-chart-api-e5222
Dim worksheet As Worksheet = workbook.Worksheets("chartTask3")
workbook.Worksheets.ActiveWorksheet = worksheet
' Create a chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered)
chart.TopLeftCell = worksheet.Cells("H2")
chart.BottomRightCell = worksheet.Cells("N14")
' Add series using a worksheet range as the data source.
chart.Series.Add(worksheet("D2"), worksheet("B3:B6"), worksheet("D3:D6"))
chart.Series.Add(worksheet("F2"), worksheet("B3:B6"), worksheet("F3:F6"))
' Change the data range for the series values.
chart.Series(1).Values = ChartData.FromRange(worksheet("E3:E6"))
' Specify the cell that is the source for the series name.
chart.Series(1).SeriesName.SetReference(worksheet("E2"))