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