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

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, _
   ByVal viewType As ChartViewType, _
   ByVal showLegend As Boolean _
)

'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 viewType As ChartViewType
Dim showLegend As Boolean
 
Dim instance As New SpreadChart(categoryFormula, nameFormula, dataFormula, seriesType, location, size, viewType, showLegend)

public SpreadChart( 
   string categoryFormula,
   string nameFormula,
   string dataFormula,
   Type seriesType,
   Point location,
   Size size,
   ChartViewType viewType,
   bool showLegend
)

Parameters

categoryFormula: The category formula.
nameFormula: The name formula.
dataFormula: The data formula.
seriesType: Type of the series.
location: The location.
size: The size.
viewType: Type of the view.
showLegend: if set to true [show legend].

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. The viewType parameter is the view type of the chart (2D or 3D). The showLegend parameter indicates whether to show a default legend area in the chart.

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;
Point loc = new Point(20, 30);
Size size = new Size(300, 400);
FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$B$2:$D$7", typeof(FarPoint.Win.Chart.BarSeries), loc, size,FarPoint.Win.Chart.ChartViewType.View2D, false);
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 loc As New Point(20, 30)
Dim size As New Size(300, 400)
Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$B$2:$D$7", GetType(FarPoint.Win.Chart.BarSeries), loc, size, FarPoint.Win.Chart.ChartViewType.View2D, False)
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