Click or drag to resize

ExcelChartWorksheetsCollectionAddChartWorksheet Method (ExcelChartType, ExcelRange, Boolean)

Adds a new chart worksheet with a default name 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.

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
Copy
public ExcelChartWorksheet AddChartWorksheet(
	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: ExcelChartWorksheet
The newly created chart worksheet.
See Also