Class ChartCollection

Collection of chart shapes in a worksheet, providing methods to add and manage data-driven charts.

Inheritance
System.Object
FilteredShapeCollection<FloatingChartShape>
ChartCollection
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class ChartCollection : FilteredShapeCollection<FloatingChartShape>, IEnumerable<FloatingChartShape>, IEnumerable

Constructors

ChartCollection(Worksheet)

Initializes a new ChartCollection for the specified worksheet.

Declaration
public ChartCollection(Worksheet worksheet)
Parameters
Worksheet worksheet

The worksheet.

Properties

ShapeType

Gets the shape type filtered by this collection, always returning Chart.

Declaration
public override FloatingShapeType ShapeType { get; }
Property Value
FloatingShapeType

Overrides
Telerik.Windows.Documents.Spreadsheet.Model.FilteredShapeCollection<Telerik.Windows.Documents.Spreadsheet.Model.Shapes.FloatingChartShape>.ShapeType

Methods

Add(CellIndex, CellRange, ChartType[])

Creates a chart at the specified cell position based on the data range, automatically determining series orientation, and returns the chart shape.

Declaration
public FloatingChartShape Add(CellIndex cellIndex, CellRange chartDataRange, params ChartType[] chartTypes)
Parameters
CellIndex cellIndex

The cell index where the top left corner of the shape is positioned.
CellRange chartDataRange

The range containing the data that the chart will be based on.
ChartType[] chartTypes

The types of chart that will be created. Passing more than one type will create a combo chart.
Returns
FloatingChartShape

The result chart shape.

Add(CellIndex, CellRange, SeriesRangesOrientation, ChartType[])

Creates a chart at the specified cell position based on the data range with explicit series orientation control and returns the chart shape.

Declaration
public FloatingChartShape Add(CellIndex cellIndex, CellRange chartDataRange, SeriesRangesOrientation seriesRangesOrientation, params ChartType[] chartTypes)
Parameters
CellIndex cellIndex

The cell index where the top left corner of the shape is positioned.
CellRange chartDataRange

The range containing the data that the chart will be based on.
SeriesRangesOrientation seriesRangesOrientation

A value indicating whether the series of the chart will refer to vertical or horizontal ranges or the direction will be determined automatically.
ChartType[] chartTypes

The types of chart that will be created. Passing more than one type will create a combo chart.
Returns
FloatingChartShape

The result chart shape.

Extension Methods