.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Series.Values Property

Gets or sets the data used as series point values.

Namespace: DevExpress.Spreadsheet.Charts

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


ChartData Values { get; set; }
Property Values As ChartData

Property Value

Type Description

A ChartData object specifying data for chart data points.


You can use the ChartData.FromRange method to create chart data object from a worksheet cell range and assign it to the Values property. Use the ChartData.FromArray method or implicit type conversion to specify an array of values.

The code snippet illustrates how to specify an array of values as the data source for series arguments and values.

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

' Create a chart.
Dim chart As Chart = worksheet.Charts.Add(ChartType.LineMarker, worksheet(0,0))
' Specify arguments.
chart.Series(0).Arguments = New CellValue() {1,2,3}
' Specify values.
chart.Series(0).Values = New CellValue() { 30, 20, 10 }

See Also