Series.Arguments Property

Gets or sets the data used as arguments for series points.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ChartData Arguments { get; set; }

VB.NET

Property Arguments As ChartData

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 Arguments 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.

The code snippet illustrates how to specify a cell range and an array of strings as data sources for series arguments.

View Example

SeriesActions.cs

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();

SeriesActions.vb

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

' 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 }

workbook.EndUpdate()

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Arguments 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.

C#

spreadsheet-document-api-chart-examples/CS/SpreadsheetDocServerChartAPISamples/CodeExamples/SeriesActions.cs#L93

// Specify arguments.
chart.Series[0].Arguments = new CellValue[] {1,2,3};
// Specify values.

wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/CodeExamples/SeriesActions.cs#L93

// Specify arguments.
chart.Series[0].Arguments = new CellValue[] {1,2,3};
// Specify values.

winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/SeriesActions.cs#L93

// Specify arguments.
chart.Series[0].Arguments = new CellValue[] {1,2,3};
// Specify values.

VB.NET

spreadsheet-document-api-chart-examples/VB/SpreadsheetDocServerChartAPISamples/CodeExamples/SeriesActions.vb#L96

' Specify arguments.
chart.Series(0).Arguments = New CellValue() {1, 2, 3}
' Specify values.

wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/SeriesActions.vb#L96

' Specify arguments.
chart.Series(0).Arguments = New CellValue() {1,2,3}
' Specify values.

winforms-spreadsheet-chart-api/VB/SpreadsheetChartAPISamples/CodeExamples/SeriesActions.vb#L95

' Specify arguments.
chart.Series(0).Arguments = New CellValue() {1,2,3}
' Specify values.