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)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SpreadChart Class
SpreadChart Members
Overload List