ClassChartCollection
Collection of chart shapes in a worksheet, providing methods to add and manage data-driven charts.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class ChartCollection : FilteredShapeCollection<FloatingChartShape>, IEnumerableInheritance: objectFilteredShapeCollection<FloatingChartShape>ChartCollection
Implements:
Inherited Members
Constructors
ChartCollection(Worksheet)
Initializes a new ChartCollection for the specified worksheet.
Declaration
public ChartCollection(Worksheet worksheet)Parameters
worksheet
The worksheet.
Properties
ShapeType
Gets the shape type filtered by this collection, always returning Chart.
Declaration
public override FloatingShapeType ShapeType { get; }Property Value
Overrides
Methods
Add(CellIndex, CellRange, SeriesRangesOrientation, params 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
The cell index where the top left corner of the shape is positioned.
chartDataRange
The range containing the data that the chart will be based on.
seriesRangesOrientation
A value indicating whether the series of the chart will refer to vertical or horizontal ranges or the direction will be determined automatically.
chartTypes
ChartType[]
The types of chart that will be created. Passing more than one type will create a combo chart.
Returns
The result chart shape.
Add(CellIndex, CellRange, params 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
The cell index where the top left corner of the shape is positioned.
chartDataRange
The range containing the data that the chart will be based on.
chartTypes
ChartType[]
The types of chart that will be created. Passing more than one type will create a combo chart.
Returns
The result chart shape.