Click or drag to resize

ExcelChartWorksheetsCollectionAddChartWorksheet Method (ExcelChartType, ExcelRange, Boolean, String)

Adds a new chart worksheet with the specified 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,
	string worksheetName
)

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.
worksheetName
Type: SystemString
The name of the chart worksheet.

Return Value

Type: ExcelChartWorksheet
The newly created chart worksheet.
See Also