SpreadChart Constructor(String,String,String,Type,Point,Size)

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal categoryFormula As String, _
   ByVal nameFormula As String, _
   ByVal dataFormula As String, _
   ByVal seriesType As Type, _
   ByVal location As Point, _
   ByVal size As Size _
)

'Usage
 
Dim categoryFormula As String
Dim nameFormula As String
Dim dataFormula As String
Dim seriesType As Type
Dim location As Point
Dim size As Size
 
Dim instance As New SpreadChart(categoryFormula, nameFormula, dataFormula, seriesType, location, size)

public SpreadChart( 
   string categoryFormula,
   string nameFormula,
   string dataFormula,
   Type seriesType,
   Point location,
   Size size
)

Parameters

categoryFormula: The category formula.
nameFormula: The name formula.
dataFormula: The data formula.
seriesType: Type of the series.
location: The location.
size: The size.

The categoryFormula is for the axis title. The nameFormula is for the names of the series (SeriesName). The dataFormula is for the actual data in each series. The seriesType parameter indicates which type of chart will be added. The location and size parameters specify the location and size (width and height) of the chart.

This example creates a chart.

C#

fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
fpSpread1.Sheets[0].Cells[1, 1].Value = 7;
fpSpread1.Sheets[0].Cells[3, 3].Value = 5;
Point loc = new Point(20, 30);
Size size = new Size(300, 400);
FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$B$2:$D$7", typeof(FarPoint.Win.Chart.BarSeries), loc, size);
fpSpread1.Sheets[0].Charts.Add(chart);

Visual Basic

fpSpread1.Sheets(0).Cells(0, 0).Value = 3
fpSpread1.Sheets(0).Cells(1, 1).Value = 7
fpSpread1.Sheets(0).Cells(3, 3).Value = 5
Dim loc As New Point(20, 30)
Dim size As New Size(300, 400)
Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$B$2:$D$7", GetType(FarPoint.Win.Chart.BarSeries), loc, size)
fpSpread1.Sheets(0).Charts.Add(chart)

Reference

SpreadChart Class
SpreadChart Members
Overload List