'Declaration
 
Public Overloads Sub GenerateFromCellRanges( _
   ByVal chart As SpreadChart, _
   ByVal sheetView As SheetView, _
   ByVal category As CellRange, _
   ByVal seriesName As CellRange, _
   ByVal data As CellRange, _
   ByVal autoSwitch As Boolean, _
   ByVal autoCreateCategory As Boolean _
) 

'Usage
 
Dim instance As SpreadChartExtension
Dim chart 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(chart, sheetView, category, seriesName, data, autoSwitch, autoCreateCategory)

public void GenerateFromCellRanges( 
   SpreadChart chart,
   SheetView sheetView,
   CellRange category,
   CellRange seriesName,
   CellRange data,
   bool autoSwitch,
   bool autoCreateCategory
)

Parameters

chart

The target chart.

sheetView

The sheet view.

category

The category.

seriesName

Name of the series.

data

The data.

autoSwitch

if set to true, the procesing will switch row and column automatically if necessary.

autoCreateCategory

if set to true, the generating process will auto detect and create a category if the category cell range is null.

Reference

SpreadChartExtension Class
SpreadChartExtension Members
Overload List