GrapeCity.Xaml.SpreadSheet.Data Namespace > Worksheet Class > AddChart Method : AddChart(String,SpreadChartType,String,String,String,Double,Double,Double,Double) Method |
'Declaration Public Overloads Function AddChart( _ ByVal name As String, _ ByVal chartType As SpreadChartType, _ ByVal itemsFormula As String, _ ByVal nameFormula As String, _ ByVal dataFormula As String, _ ByVal x As Double, _ ByVal y As Double, _ ByVal width As Double, _ ByVal height As Double _ ) As SpreadChart
'Usage Dim instance As Worksheet Dim name As String Dim chartType As SpreadChartType Dim itemsFormula As String Dim nameFormula As String Dim dataFormula As String Dim x As Double Dim y As Double Dim width As Double Dim height As Double Dim value As SpreadChart value = instance.AddChart(name, chartType, itemsFormula, nameFormula, dataFormula, x, y, width, height)
public SpreadChart AddChart( string name, SpreadChartType chartType, string itemsFormula, string nameFormula, string dataFormula, double x, double y, double width, double height )
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)
Target Platforms: Windows Server 2012, Windows RT