All docs
V21.1
21.2 (EAP/Beta)
21.1
20.2
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

ChartObject.SelectData(CellRange, ChartDataDirection) Method

Specifies the source data for the chart.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

void SelectData(
    CellRange range,
    ChartDataDirection direction
)

Parameters

Name Type Description
range CellRange

A continuous cell range that contains chart data.

direction ChartDataDirection

A ChartDataDirection enumeration member that specifies how to retrieve series values: from rows or columns.

Remarks

The SelectData method retrieves data series from the specified range and automatically determines the Series.SeriesName, Series.Arguments and Series.Values for each series. The direction parameter specifies in which direction the series are retrieved.

This example demonstrates how to create a chart and specify its data using the ChartObject.SelectData method.

The data range looks as follows.

SelectDataExample_Range

The direction in which the data are extracted is specified by the parameter passed to the method. If the direction equals the ChartDataDirection.Row value, the following chart is displayed.

SelectDataExample_ChartByRow

If the direction equals the ChartDataDirection.Column value, the chart looks as follows.

SelectDataExample_ChartByColumn

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

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

' Select chart data by rows.
chartRowData.SelectData(worksheet("B2:F6"), ChartDataDirection.Row)

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

' Select chart data by columns.
chartColumnData.SelectData(worksheet("B2:F6"), ChartDataDirection.Column)

Instead of specifying the ChartDataDirection parameter in the SelectData method, you can use the ChartObject.SwitchRowColumn method to change the way that data rows and columns are plotted.

See Also