GrapeCity.Xaml.SpreadSheet.Data Namespace > Worksheet Class > AddChart Method : AddChart(String,SpreadChartType,String,Int32,Double,Int32,Double,Double,Double) Method |
'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 width As Double, _ ByVal height 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 width As Double Dim height As Double Dim value As SpreadChart value = instance.AddChart(name, chartType, formula, row, rowOffset, column, columnOffset, width, 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