The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

ChartCollection Interface

A collection of Chart objects in a worksheet.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

public interface ChartCollection :
    ISimpleCollection<Chart>,
    IEnumerable<Chart>,
    IEnumerable,
    ICollection
Public Interface ChartCollection
    Inherits ISimpleCollection(Of Chart),
             IEnumerable(Of Chart),
             IEnumerable,
             ICollection
public interface ChartCollection :
    ISimpleCollection<Chart>,
    IEnumerable<Chart>,
    IEnumerable,
    ICollection
Public Interface ChartCollection
    Inherits ISimpleCollection(Of Chart),
             IEnumerable(Of Chart),
             IEnumerable,
             ICollection
public interface ChartCollection :
    ISimpleCollection<Chart>,
    IEnumerable<Chart>,
    IEnumerable,
    ICollection
Public Interface ChartCollection
    Inherits ISimpleCollection(Of Chart),
             IEnumerable(Of Chart),
             IEnumerable,
             ICollection

Remarks

Use the Worksheet.Charts property to return the ChartCollection collection.

Use the ChartCollection.Add method to create a new chart and add it to the workbook. The following example adds a new embedded chart to the active worksheet and places the new chart above the cells in the range E2:K15.

The example below demonstrates how to create a 3-D pie chart using the ChartCollection.Add method overload that enables you to specify a CellRange containing chart data.

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

' Create a pie chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.Pie3D, worksheet("B2:C7"))
chart.TopLeftCell = worksheet.Cells("E2")
chart.BottomRightCell = worksheet.Cells("K15")

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