SpreadChart Constructor(String,Type)

Initializes a new instance of the SpreadChart class.

Syntax

Visual Basic
C#

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

'Usage
 
Dim formula As String
Dim seriesType As Type
 
Dim instance As New SpreadChart(formula, seriesType)

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.

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

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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SpreadChart Class
SpreadChart Members
Overload List