Click or drag to resize

ExcelChartsCollection Class

Represents the collection of charts in a worksheet
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelChartsCollection

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
Copy
public class ExcelChartsCollection

The ExcelChartsCollection type exposes the following members.

Properties
  NameDescription
Public propertyCount
Gets the number of charts in this collection.
Public propertyItem
Gets the chart at the specified index from collection.
Public propertyWorksheet
Gets the worksheet of this charts collection
Top
Methods
  NameDescription
Public methodAddChart(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.
Public methodAddChart(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 data source. The location and the size of the chart inside the worksheet are the default ones.
Public methodAddChart(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.
Public methodAddChart(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 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.
Public methodGetEnumerator
Gets the collection enumerator
Public methodRemoveChart
Removes the chart at the specified zero based index from collection
Top
See Also