ExcelChartsCollection Class

Represents the collection of charts in a worksheet

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
C#
public class ExcelChartsCollection
Inheritance
Object    ExcelChartsCollection

Properties

Count Gets the number of charts in this collection.
Item Gets the chart at the specified index from collection.
Worksheet Gets the worksheet of this charts collection

Methods

AddChart(ExcelChartType) Use this type of constructor when the series will be manually added to the chart, otherwise use the constructor accepting the data source range parameter. Adds a new chart to the collection without specifying the data source range. The location and the size of the chart inside the worksheet are the default ones.
AddChart(ExcelChartType, ExcelRange, Boolean) Adds a new chart to the collection. The data source range of the chart is specified as the dataSourceRange parameter. The chart series are automatically generated from the the data source. The location and the size of the chart inside the worksheet are the default ones.
AddChart(ExcelChartType, Int32, Int32, Int32, Int32) Use this type of constructor when the series will be manually added to the chart, otherwise use the constructor accepting the data source range parameter. Adds a new chart to the collection without specifying the data source range. The location and the size of the chart inside the worksheet are specified by the left column, top row, right column and bottom row parameters.
AddChart(ExcelChartType, ExcelRange, Boolean, Int32, Int32, Int32, Int32) Adds a new chart to the collection. The data source range of the chart is specified as the dataSourceRange parameter. The chart series are automatically generated from the the data source. The location and the size of the chart inside the worksheet are specified by the left column, top row, right column and bottom row parameters.
Equals
(Inherited from Object)
Finalize
(Inherited from Object)
GetEnumerator Gets the collection enumerator
GetHashCode
(Inherited from Object)
GetType
(Inherited from Object)
MemberwiseClone
(Inherited from Object)
RemoveChart Removes the chart at the specified zero based index from collection
ToString
(Inherited from Object)

See Also