Click or drag to resize

ExcelChartsCollectionAddChart Method (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.

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
public ExcelChart AddChart(
	ExcelChartType chartType,
	ExcelRange dataSourceRange,
	bool seriesByRows
)

Parameters

chartType
Type: ExpertXls.ExcelLibExcelChartType
The chart type
dataSourceRange
Type: ExpertXls.ExcelLibExcelRange
The data source range of the chart
seriesByRows
Type: SystemBoolean
When this parameter is true the chart series will be created from range rows, otherwise the chart series will be created from range columns.

Return Value

Type: ExcelChart
The newly created chart
See Also