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

Series.CustomDataPoints Property

Provides access to data points with a customized visual appearance.

Namespace: DevExpress.Spreadsheet.Charts

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


DataPointCollection CustomDataPoints { get; }
ReadOnly Property CustomDataPoints As DataPointCollection

Property Value

Type Description

A DataPointCollection object that is the collection of customized data points.


To change the visual appearance for a specific data point in a series, add an item to the DataPointCollection collection with the index equal to an index of the selected data point and use the DataPoint properties to specify its appearance.

For a chart of the ChartType.Pie3D type, you can use the DataPoint.Explosion property to set the point explosion, as illustrated in the following code sample.

The example below demonstrates how to create the 3-D pie chart and rotate it around the Y-axis by 225° using the View3DOptions.YRotation property.

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

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

' Add the data series
chart.Series.Add(worksheet("E2"), worksheet("B3:B6"), worksheet("E3:E6"))

' Set the explosion value for the slice
chart.Series(0).CustomDataPoints.Add(2).Explosion = 25

' Set the rotation of the  3-D chart view
chart.View3D.YRotation = 255

' Set the chart style
chart.Style = ChartStyle.ColorGradient
See Also