GrapeCity.Xaml.SpreadSheet.Data
SpreadChart Constructor(String,SpreadChartType,String,Double,Double,Double,Double)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > SpreadChart Class > SpreadChart Constructor : SpreadChart Constructor(String,SpreadChartType,String,Double,Double,Double,Double)
The name of the chart.
The type of the chart.
The formula for the chart.
The x location of the chart.
The y location of the chart.
The width of the chart.
The height of the chart.
Initializes a new instance of the SpreadChart class.
Syntax
'Declaration
 
Public Function New( _
   ByVal name As String, _
   ByVal type As SpreadChartType, _
   ByVal formula As String, _
   ByVal x As Double, _
   ByVal y As Double, _
   ByVal width As Double, _
   ByVal height As Double _
)
'Usage
 
Dim name As String
Dim type As SpreadChartType
Dim formula As String
Dim x As Double
Dim y As Double
Dim width As Double
Dim height As Double
 
Dim instance As New SpreadChart(name, type, formula, x, y, width, height)
public SpreadChart( 
   string name,
   SpreadChartType type,
   string formula,
   double x,
   double y,
   double width,
   double height
)

Parameters

name
The name of the chart.
type
The type of the chart.
formula
The 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 formula parameter is for the chart data. The type parameter indicates which type of chart will be added.
Example
This example creates a chart.
gcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } });
GrapeCity.Xaml.SpreadSheet.Data.ChartTitle clabel = new GrapeCity.Xaml.SpreadSheet.Data.ChartTitle();
clabel.Text = "Chart Label";
GrapeCity.Xaml.SpreadSheet.Data.SpreadChart schart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("test", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 100, 100, 200, 200);
schart.ChartTitle = clabel;
gcSpreadSheet1.ActiveSheet.Charts.Add(schart);
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}})
Dim clabel As New GrapeCity.Xaml.SpreadSheet.Data.ChartTitle()
clabel.Text = "Chart Label"
Dim schart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("test", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 100, 100, 200, 200)
schart.ChartTitle = clabel
GcSpreadSheet1.ActiveSheet.Charts.Add(schart)
See Also

Reference

SpreadChart Class
SpreadChart Members
Overload List