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

Initializes a new instance of the SpreadChart class.

Syntax

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.

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. The location and size parameters specify the location and size (width and height) of the chart.

Example

This example creates a chart control.

FpSpread1.Sheets[0].RowCount = 10;
FpSpread1.Sheets[0].ColumnCount = 10;
FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
FpSpread1.Sheets[0].Cells[1, 1].Value = 7;
FpSpread1.Sheets[0].Cells[2, 2].Value = 7;
FpSpread1.Sheets[0].Cells[3, 3].Value = 5;
System.Drawing.Point loc = new System.Drawing.Point(20, 30);
System.Drawing.Size size = new System.Drawing.Size(200, 300);
FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$B$2:$D$7", typeof(FarPoint.Web.Chart.BarSeries), loc, size);
FpSpread1.Sheets[0].Charts.Add(chart);

Visual Basic

FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 1).Value = 7
FpSpread1.Sheets(0).Cells(2, 2).Value = 7
FpSpread1.Sheets(0).Cells(3, 3).Value = 5
Dim loc As New System.Drawing.Point(20, 30)
Dim size As New System.Drawing.Size(200, 300)
Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$B$2:$D$7", GetType(FarPoint.Web.Chart.BarSeries), loc, size)
FpSpread1.Sheets(0).Charts.Add(chart)

Reference

SpreadChart Class
SpreadChart Members
Overload List