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

Initializes a new instance of the SpreadChart class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal formula As String, _
   ByVal seriesType As Type, _
   ByVal location As Point, _
   ByVal size As Size, _
   ByVal viewType As ChartViewType, _
   ByVal showLegend As Boolean _
)

'Usage
 
Dim formula 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(formula, seriesType, location, size, viewType, showLegend)

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

Parameters

formula: The formula.
seriesType: Type of the series.
location: The location.
size: The size.
viewType: Chart view type.
showLegend: if set to true [show legend].

Remarks

The formula parameter is for the chart data. 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 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;
System.Drawing.Point loc = new System.Drawing.Point(20, 30);
System.Drawing.Size size = new System.Drawing.Size(200, 300);
FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$1:$D$7", typeof(FarPoint.Web.Chart.BarSeries),loc,size, FarPoint.Web.Chart.ChartViewType.View2D, false);
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 loc As New System.Drawing.Point(20, 30)
Dim size As New System.Drawing.Size(200, 300)
Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart("Sheet1!$A$1:$D$7", GetType(FarPoint.Web.Chart.BarSeries), loc, size, FarPoint.Web.Chart.ChartViewType.View2D, False)      
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