FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Chart Namespace > SpreadChart Class > GenerateFromCellRanges Method : GenerateFromCellRanges(SheetView,CellRange,CellRange,CellRange,Boolean) Method |
true
, the processing switches rows and columns automatically, if necessary.
'Declaration Public Overloads Sub GenerateFromCellRanges( _ ByVal sheetView As SheetView, _ ByVal category As CellRange, _ ByVal seriesName As CellRange, _ ByVal data As CellRange, _ ByVal autoSwitch 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 instance.GenerateFromCellRanges(sheetView, category, seriesName, data, autoSwitch)
public void GenerateFromCellRanges( SheetView sheetView, CellRange category, CellRange seriesName, CellRange data, bool autoSwitch )
true
, the processing switches rows and columns automatically, if necessary.FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart(typeof(FarPoint.Web.Chart.BarSeries)); chart.GenerateFromCellRanges(FpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(1, 0, 6, 1), new FarPoint.Web.Spread.Model.CellRange(0, 1, 1, 3), new FarPoint.Web.Spread.Model.CellRange(1, 1, 6, 3), true); FpSpread1.Sheets[0].Charts.Add(chart);
Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart(GetType(FarPoint.Web.Chart.BarSeries)) chart.GenerateFromCellRanges(FpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(1, 0, 6, 1), New FarPoint.Web.Spread.Model.CellRange(0, 1, 1, 3), New FarPoint.Web.Spread.Model.CellRange(1, 1, 6, 3), True) FpSpread1.Sheets(0).Charts.Add(chart)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6