Skip to main content

Series.Values Property

Gets or sets the data used as series point values.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

ChartData Values { get; set; }

Property Value

Type Description
ChartData

A ChartData object specifying data for chart data points.

Remarks

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.

View Example

Worksheet worksheet = workbook.Worksheets["Sheet1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
workbook.BeginUpdate();

// Create a chart.
Chart 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 };

workbook.EndUpdate();

The following code snippets (auto-collected from DevExpress Examples) contain references to the Values property.

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.

See Also