AddChart(String,SpreadChartType,String,Int32,Double,Int32,Double,Int32,Double,Int32,Double) Method

Adds the chart.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function AddChart( _
   ByVal name As String, _
   ByVal chartType As SpreadChartType, _
   ByVal formula As String, _
   ByVal row As Integer, _
   ByVal rowOffset As Double, _
   ByVal column As Integer, _
   ByVal columnOffset As Double, _
   ByVal endRow As Integer, _
   ByVal endRowOffset As Double, _
   ByVal endColumn As Integer, _
   ByVal endColumnOffset As Double _
) As SpreadChart

'Usage
 
Dim instance As Worksheet
Dim name As String
Dim chartType As SpreadChartType
Dim formula As String
Dim row As Integer
Dim rowOffset As Double
Dim column As Integer
Dim columnOffset As Double
Dim endRow As Integer
Dim endRowOffset As Double
Dim endColumn As Integer
Dim endColumnOffset As Double
Dim value As SpreadChart
 
value = instance.AddChart(name, chartType, formula, row, rowOffset, column, columnOffset, endRow, endRowOffset, endColumn, endColumnOffset)

public SpreadChart AddChart( 
   string name,
   SpreadChartType chartType,
   string formula,
   int row,
   double rowOffset,
   int column,
   double columnOffset,
   int endRow,
   double endRowOffset,
   int endColumn,
   double endColumnOffset
)

Parameters

name: The name of the chart.
chartType: Type of the chart.
formula: The formula.
row: The row.
rowOffset: The row offset.
column: The column.
columnOffset: The column offset.
endRow: The end row.
endRowOffset: The end row offset.
endColumn: The end column.
endColumnOffset: The end column offset.

Example

This example uses the AddChart method.

C#
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;
//gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Bubble, "Sheet1!$A$1:$D$7", 0, 0, 400, 300);
//gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, 0, 0, 350, 250);
gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnStacked, "Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$A$1:$D$7", 0, 0, 400, 300);
//gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 1, 1, 1, 1, 5, 5, 5, 5);
//gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 1, 1, 1, 1, 400, 350);
//gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$A$1:$D$7", 1, 1, 1, 1, 400, 350);

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
'GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Bubble, "Sheet1!$A$1:$D$7", 0, 0, 400, 300)
'GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, 0, 0, 400, 300)
GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnStacked, "Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$A$1:$D$7", 0, 0, 400, 300)
'GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 1, 1, 1, 1, 400, 350)
'GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$2:$A$7", "Sheet1!$B$1:$D$1", "Sheet1!$A$1:$D$7", 1, 1, 1, 1, 400, 350)
'GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 1, 1, 1, 1, 5, 5, 5, 5)

Reference

Worksheet Class
Worksheet Members
Overload List