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.

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$1:$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);

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 chart As New FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$A$1:$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)

Reference

SpreadChart Class
SpreadChart Members
Overload List