FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Chart Namespace > SpreadChart Class > SpreadChart Constructor : SpreadChart Constructor(String,String,String,Type,Point,Size) |
'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 _ )
'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 instance As New SpreadChart(categoryFormula, nameFormula, dataFormula, seriesType, location, size)
public SpreadChart( string categoryFormula, string nameFormula, string dataFormula, Type seriesType, Point location, Size size )
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); fpSpread1.Sheets[0].Charts.Add(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 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) FpSpread1.Sheets(0).Charts.Add(chart)
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