ExcelChartWorksheetsCollectionAddChartWorksheet(ExcelChartType, ExcelRange, Boolean) Method |
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.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 9.0.0
Syntaxpublic ExcelChartWorksheet AddChartWorksheet(
ExcelChartType chartType,
ExcelRange dataSourceRange,
bool seriesByRows
)
Public Function AddChartWorksheet (
chartType As ExcelChartType,
dataSourceRange As ExcelRange,
seriesByRows As Boolean
) As ExcelChartWorksheet
Parameters
- chartType ExcelChartType
- The chart type
- dataSourceRange ExcelRange
- The data source range of the chart
- seriesByRows Boolean
- 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
ExcelChartWorksheetThe newly created chart worksheet.
See Also