ExcelChartsCollectionAddChart(ExcelChartType, ExcelRange, Boolean) Method |
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.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 9.0.0
Syntaxpublic ExcelChart AddChart(
ExcelChartType chartType,
ExcelRange dataSourceRange,
bool seriesByRows
)
Public Function AddChart (
chartType As ExcelChartType,
dataSourceRange As ExcelRange,
seriesByRows As Boolean
) As ExcelChart
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
ExcelChartThe newly created chart
See Also