ChartData.IsArray Property

Gets whether the chart data is an array of values.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

C#

public bool IsArray { get; }

VB.NET

Public ReadOnly Property IsArray As Boolean

Property Value

Type	Description
Boolean	true, if the chart data is an array of values; otherwise, false.

Remarks

The chart data is an array if the ChartData object is created from an array of CellValue objects using one of the methods listed below:

• by using implicit type conversion
• by using the ChartData.FromArray method

The following example illustrates how the ChartData objects required for Series.Arguments and Series.Values properties are implicitly created from arrays of CellValue objects. Note that the CellValue type uses implicit conversion from string and integer types.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheet-chart-api-e5222

CreationAndDataActions.vb

Dim worksheet As Worksheet = workbook.Worksheets(0)
workbook.Worksheets.ActiveWorksheet = worksheet
worksheet.Columns(0).WidthInCharacters = 2.0

' Create a chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered)
chart.TopLeftCell = worksheet.Cells("B2")
chart.BottomRightCell = worksheet.Cells("H15")

' Add a series bound to a set of literal data.
Dim series_of_literal As Series = chart.Series.Add(New CellValue() { "Jan", "Feb", "Mar", "Apr", "May", "Jun" }, New CellValue() { 50, 100, 30, 104, 87, 150 })

CreationAndDataActions.cs

Worksheet worksheet = workbook.Worksheets[0];
workbook.Worksheets.ActiveWorksheet = worksheet;
worksheet.Columns[0].WidthInCharacters = 2.0;

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered);
chart.TopLeftCell = worksheet.Cells["B2"];
chart.BottomRightCell = worksheet.Cells["H15"];

// Add a series bound to a set of literal data.
Series series_of_literal = chart.Series.Add(
    new CellValue[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun" },
    new CellValue[] { 50, 100, 30, 104, 87, 150 });