Skip to main content
.NET Framework 4.5.2+
Row

ChartSheet Interface

A separate sheet in a workbook that contains only a chart.

Namespace: DevExpress.Spreadsheet

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

Declaration

public interface ChartSheet :
    Sheet

Remarks

All chart sheets in a workbook are stored in the ChartSheetCollection collection, returned by the Workbook.ChartSheets property. An individual ChartSheet object can be accessed by its name or index in the collection using the ChartSheetCollection.Item property.

The ChartSheet object is also a member of the SheetCollection collection, which contains all sheets in a workbook (both chart sheets and worksheets). You can access an individual sheet by its name or index in the collection.

Use the ChartSheetCollection.Add or ChartSheetCollection.Insert method to create a new chart sheet. To move an existing chart to a chart sheet, use the chart’s ChartObject.MoveToNewChartSheet method.

The ChartSheet.Chart property allows you to get access to a chart located on a chart sheet and specify its settings (select chart data, change the chart type and adjust its appearance).

The ChartSheet.ActiveView property returns the ChartSheetView object that specifies display and print settings for a chart sheet. Additional printing options are accessible from the ChartSheet.PrintOptions property.

For details on how to manage chart sheets in a workbook, refer to the Charts example section.

The following code snippets (auto-collected from DevExpress Examples) contain references to the ChartSheet 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.

See Also