ChartCollection
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>, IEnumerable<FloatingChartShape>, IEnumerableInheritance: objectFilteredShapeCollection<FloatingChartShape>ChartCollection
Implements:
Inherited Members
Constructors
Initializes a new ChartCollection for the specified worksheet.
Methods
Creates a chart at the specified cell position based on the data range, automatically determining series orientation, and returns the chart shape.
public FloatingChartShape Add(CellIndex cellIndex, CellRange chartDataRange, params ChartType[] chartTypes)The cell index where the top left corner of the shape is positioned.
chartDataRangeCellRangeThe range containing the data that the chart will be based on.
chartTypesChartType[]The types of chart that will be created. Passing more than one type will create a combo chart.
Returns:The result chart shape.
Creates a chart at the specified cell position based on the data range with explicit series orientation control and returns the chart shape.
public FloatingChartShape Add(CellIndex cellIndex, CellRange chartDataRange, SeriesRangesOrientation seriesRangesOrientation, params ChartType[] chartTypes)The cell index where the top left corner of the shape is positioned.
chartDataRangeCellRangeThe range containing the data that the chart will be based on.
seriesRangesOrientationSeriesRangesOrientationA value indicating whether the series of the chart will refer to vertical or horizontal ranges or the direction will be determined automatically.
chartTypesChartType[]The types of chart that will be created. Passing more than one type will create a combo chart.
Returns:The result chart shape.
Properties
Gets the shape type filtered by this collection, always returning Chart.
public override FloatingShapeType ShapeType { get; }Overrides: