Spread Windows Forms 12.0 Product Documentation
SpreadChart Constructor(String,String,String,Type)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Chart Namespace > SpreadChart Class > SpreadChart Constructor : SpreadChart Constructor(String,String,String,Type)
The category formula.
The name formula.
The data formula.
Type of the series.
Initializes a new instance of the SpreadChart class.
Syntax
'Declaration
 
Public Function New( _
   ByVal categoryFormula As String, _
   ByVal nameFormula As String, _
   ByVal dataFormula As String, _
   ByVal seriesType As Type _
)
'Usage
 
Dim categoryFormula As String
Dim nameFormula As String
Dim dataFormula As String
Dim seriesType As Type
 
Dim instance As New SpreadChart(categoryFormula, nameFormula, dataFormula, seriesType)
public SpreadChart( 
   string categoryFormula,
   string nameFormula,
   string dataFormula,
   Type seriesType
)

Parameters

categoryFormula
The category formula.
nameFormula
The name formula.
dataFormula
The data formula.
seriesType
Type of the series.
Remarks
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.
Example
This example creates a chart.
fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
fpSpread1.Sheets[0].Cells[1, 1].Value = 7;
fpSpread1.Sheets[0].Cells[3, 3].Value = 5;
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));
chart.Location = new Point(100, 100);
chart.Size = new Size(200, 200);
fpSpread1.Sheets[0].Charts.Add(chart);
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 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))
chart.Location = New Point(100, 100)
chart.Size = New Size(200, 200)
fpSpread1.Sheets(0).Charts.Add(chart)
See Also

Reference

SpreadChart Class
SpreadChart Members
Overload List