Chart Interface

An embedded chart on a worksheet.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

C#

public interface Chart :
    Shape,
    FloatingObject,
    ChartObject,
    ShapeFormat

VB.NET

Public Interface Chart
    Inherits Shape,
             FloatingObject,
             ChartObject,
             ShapeFormat

Related API Members

The following members accept/return Chart objects:

• ChartCollection.Add(ChartType)
• ChartCollection.Add(ChartType, Range)
• ChartCollection.GetChartById(Int32)
• ChartObject.CopyTo(Worksheet)
• ChartObject.MoveToWorksheet(Worksheet)
• Worksheet.SelectedChart

Remarks

The Chart object is a member of the ChartCollection collection, containing all the embedded charts on a worksheet. Use ChartCollection.GetCharts method to get charts by their names, use the ChartCollection.GetChartById method to obtain a chart by its ID or use indexed access to the elements of the ChartCollection.

To create a chart and add it to the collection of charts on a worksheet, use the ChartCollection.Add method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Chart interface.

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-chart-api-examples-t132724/CS/SpreadsheetDocServerChartAPISamples/CodeExamples/AxesActions.cs#L17

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B3:C5"]);
chart.TopLeftCell = worksheet.Cells["H2"];

winforms-spreadsheet-chart-api-e5222/CS/SpreadsheetChartAPISamples/CodeExamples/AxesActions.cs#L17

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B3:C5"]);
chart.TopLeftCell = worksheet.Cells["H2"];

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

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

spreadsheet-how-to-add-a-chart-to-a-document-t467065/CS/T449201/DiagramCreationHelper.cs#L16

// Create a chart and specify its location
Chart chart = worksheet.Charts.Add(ChartType.PieExploded, worksheet["B2:C7"]);

VB.NET

spreadsheet-chart-api-examples-t132724/VB/SpreadsheetDocServerChartAPISamples/CodeExamples/ViewOptionsActions1.vb#L19

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

winforms-spreadsheet-chart-api-e5222/VB/SpreadsheetChartAPISamples/CodeExamples/AxesActions.vb#L20

' Create a chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet("B3:C5"))
chart.TopLeftCell = worksheet.Cells("H2")

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

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

spreadsheet-how-to-add-a-chart-to-a-document-t467065/VB/T449201/DiagramCreationHelper.vb#L16

' Create a chart and specify its location
Dim chart As Chart = worksheet.Charts.Add(ChartType.PieExploded, worksheet("B2:C7"))