SpreadChart Constructor(String,SpreadChartType,String,String,String,Double,Double,Double,Double)

Initializes a new instance of the SpreadChart class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal name As System.String, _
   ByVal type As SpreadChartType, _
   ByVal itemsFormula As System.String, _
   ByVal nameFormula As System.String, _
   ByVal dataFormula As System.String, _
   ByVal x As System.Double, _
   ByVal y As System.Double, _
   ByVal width As System.Double, _
   ByVal height As System.Double _
)

'Usage
 
Dim name As System.String
Dim type As SpreadChartType
Dim itemsFormula As System.String
Dim nameFormula As System.String
Dim dataFormula As System.String
Dim x As System.Double
Dim y As System.Double
Dim width As System.Double
Dim height As System.Double
 
Dim instance As New SpreadChart(name, type, itemsFormula, nameFormula, dataFormula, x, y, width, height)

public SpreadChart( 
   System.string name,
   SpreadChartType type,
   System.string itemsFormula,
   System.string nameFormula,
   System.string dataFormula,
   System.double x,
   System.double y,
   System.double width,
   System.double height
)

Parameters

name: The name of the chart.
type: The type of the chart.
itemsFormula: The items formula for the chart.
nameFormula: The name formula for the chart.
dataFormula: The data formula for the chart.
x: The x location of the chart.
y: The y location of the chart.
width: The width of the chart.
height: The height of the chart.

Remarks

The itemsFormula 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 type parameter indicates which type of chart will be added.

Example

This example creates a chart.

gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = "c1";
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = "c2";
gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = "c3";
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = "s1";
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = "s2";
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = "s3";
gcSpreadSheet1.Sheets[0].Cells[4, 0].Value = "s4";
gcSpreadSheet1.Sheets[0].Cells[5, 0].Value = "s5";
gcSpreadSheet1.Sheets[0].Cells[6, 0].Value = "s6";

gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[2, 1].Value = 2;
gcSpreadSheet1.Sheets[0].Cells[3, 1].Value = 3;
gcSpreadSheet1.Sheets[0].Cells[4, 1].Value = 4;
gcSpreadSheet1.Sheets[0].Cells[5, 1].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[6, 1].Value = 6;

gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = 7;
gcSpreadSheet1.Sheets[0].Cells[2, 2].Value = 8;
gcSpreadSheet1.Sheets[0].Cells[3, 2].Value = 9;
gcSpreadSheet1.Sheets[0].Cells[4, 2].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[5, 2].Value = 11;
gcSpreadSheet1.Sheets[0].Cells[6, 2].Value = 12;

gcSpreadSheet1.Sheets[0].Cells[1, 3].Value = 13;
gcSpreadSheet1.Sheets[0].Cells[2, 3].Value = 14;
gcSpreadSheet1.Sheets[0].Cells[3, 3].Value = 15;
gcSpreadSheet1.Sheets[0].Cells[4, 3].Value = 16;
gcSpreadSheet1.Sheets[0].Cells[5, 3].Value = 17;
gcSpreadSheet1.Sheets[0].Cells[6, 3].Value = 18;

GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$2:$A$7", "Sheet1!$B$!:$D$1", "Sheet1!$B$1:$D$7", 0, 0, 400, 300);
gcSpreadSheet1.Sheets[0].Charts.Add(chart);

VB.NET

GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = "c1"
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = "c2"
GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = "c3"
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = "s1"
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = "s2"
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = "s3"
GcSpreadSheet1.Sheets(0).Cells(4, 0).Value = "s4"
GcSpreadSheet1.Sheets(0).Cells(5, 0).Value = "s5"
GcSpreadSheet1.Sheets(0).Cells(6, 0).Value = "s6"

GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 1
GcSpreadSheet1.Sheets(0).Cells(2, 1).Value = 2
GcSpreadSheet1.Sheets(0).Cells(3, 1).Value = 3
GcSpreadSheet1.Sheets(0).Cells(4, 1).Value = 4
GcSpreadSheet1.Sheets(0).Cells(5, 1).Value = 5
GcSpreadSheet1.Sheets(0).Cells(6, 1).Value = 6

GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = 7
GcSpreadSheet1.Sheets(0).Cells(2, 2).Value = 8
GcSpreadSheet1.Sheets(0).Cells(3, 2).Value = 9
GcSpreadSheet1.Sheets(0).Cells(4, 2).Value = 10
GcSpreadSheet1.Sheets(0).Cells(5, 2).Value = 11
GcSpreadSheet1.Sheets(0).Cells(6, 2).Value = 12

GcSpreadSheet1.Sheets(0).Cells(1, 3).Value = 13
GcSpreadSheet1.Sheets(0).Cells(2, 3).Value = 14
GcSpreadSheet1.Sheets(0).Cells(3, 3).Value = 15
GcSpreadSheet1.Sheets(0).Cells(4, 3).Value = 16
GcSpreadSheet1.Sheets(0).Cells(5, 3).Value = 17
GcSpreadSheet1.Sheets(0).Cells(6, 3).Value = 18

Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$2:$A$7", "Sheet1!$B$!:$D$1", "Sheet1!$B$1:$D$7", 0, 0, 400, 300)
gcSpreadSheet1.Sheets(0).Charts.Add(chart)

Reference

SpreadChart Class
SpreadChart Members
Overload List