You can add a chart control to the sheet using code.
Using Code
The following example creates an area chart with the AddChart method.
| CS |
Copy Code |
|---|---|
| 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.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 0, 0, 400, 300); gcSpreadSheet1.Sheets[0].Charts.Add(chart); | |
| VB |
Copy Code |
|---|---|
| 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.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 0, 0, 400, 300) GcSpreadSheet1.Sheets(0).Charts.Add(chart) | |
See Also