GenerateFromCellRanges(SheetView,CellRange,CellRange,CellRange,Boolean,Boolean) Method
In This Topic
Generates a chart from cell ranges.
Syntax
'Declaration
Public Overloads Sub GenerateFromCellRanges( _
ByVal As SheetView, _
ByVal As CellRange, _
ByVal As CellRange, _
ByVal As CellRange, _
ByVal As Boolean, _
ByVal As Boolean _
)
'Usage
Dim instance As SpreadChart
Dim sheetView As SheetView
Dim category As CellRange
Dim seriesName As CellRange
Dim data As CellRange
Dim autoSwitch As Boolean
Dim autoCreateCategory As Boolean
instance.GenerateFromCellRanges(sheetView, category, seriesName, data, autoSwitch, autoCreateCategory)
public void GenerateFromCellRanges(
SheetView ,
CellRange ,
CellRange ,
CellRange ,
bool ,
bool
)
Parameters
- sheetView
- The sheet view.
- category
- The category.
- seriesName
- Name of the series.
- data
- The data.
- autoSwitch
- if set to
true
, the processing switches the row and column automatically, if necessary. - autoCreateCategory
- if set to
true
, the generating process automatically detects and creates the category if the category cell range is NULL.
Example
This example uses the GenerateFromCellRanges method.
See Also