Click or drag to resize

ExcelChartsCollectionAddChart Method (ExcelChartType, Int32, Int32, Int32, Int32)

Use this type of constructor when the series will be manually added to the chart, otherwise use the constructor accepting the data source range parameter. Adds a new chart to the collection without specifying the data source range. The location and the size of the chart inside the worksheet are specified by the left column, top row, right column and bottom row parameters.

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
public ExcelChart AddChart(
	ExcelChartType chartType,
	int leftColumnIndex,
	int topRowIndex,
	int rightColumnIndex,
	int bottomRowIndex
)

Parameters

chartType
Type: ExpertXls.ExcelLibExcelChartType
The chart type
leftColumnIndex
Type: SystemInt32
The one based left column index of the chart area in the worksheet. The left column is included in the chart area.
topRowIndex
Type: SystemInt32
The one based top row index of the chart area in the worksheet. The top row is included in the chart area.
rightColumnIndex
Type: SystemInt32
The one based right column index of the chart area in the worksheet. The right column is not included in the chart area.
bottomRowIndex
Type: SystemInt32
The one based bottom row index of the chart area in the worksheet. The bottom row is not included in the chart area.

Return Value

Type: ExcelChart
The newly created chart
See Also