Initializes a new instance of the SpreadChart class.

Syntax

Visual Basic (Declaration)
Public Function New( _ ByVal formula As String, _ ByVal seriesType As Type _ )

Visual Basic (Usage)	Copy Code
Dim formula As String Dim seriesType As Type Dim instance As New SpreadChart(formula, seriesType)

C#
public SpreadChart( string formula, Type seriesType )

Parameters

formula: The formula.
seriesType: Type of the series.

Remarks

The formula parameter is for the chart data. The seriesType parameter indicates which type of chart will be added.

Example

This example creates a chart control.

C#	Copy Code
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; FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$1:$D$7", typeof(FarPoint.Web.Chart.BarSeries)); FpSpread1.Sheets[0].Charts.Add(chart);

Copy Code

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;
FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$1:$D$7", typeof(FarPoint.Web.Chart.BarSeries));
FpSpread1.Sheets[0].Charts.Add(chart);

Visual Basic	Copy Code
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 chart As New FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$1:$D$7", GetType(FarPoint.Web.Chart.BarSeries)) FpSpread1.Sheets(0).Charts.Add(chart)

Visual Basic

Copy Code

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 chart As New FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$1:$D$7", GetType(FarPoint.Web.Chart.BarSeries))
FpSpread1.Sheets(0).Charts.Add(chart)

Requirements

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

Syntax

Parameters

Remarks

Example

Requirements

See Also

Reference

Spread for ASP.NET 7.0 Product Documentation
SpreadChart Constructor(String,Type)
See Also Example Support Options