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+
Row

ChartSheet Interface

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

Namespace: DevExpress.Spreadsheet

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

Declaration

public interface ChartSheet :
    Sheet
Public Interface ChartSheet
    Inherits Sheet
public interface ChartSheet :
    Sheet
Public Interface ChartSheet
    Inherits Sheet
public interface ChartSheet :
    Sheet
Public Interface ChartSheet
    Inherits 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.

See Also