You can create different types of area charts such as Area, Area3D, AreaStacked, AreaStacked3D, AreaStacked100pc3D, and AreaStacked100pc. The following image displays an area chart.
Using Code
The following code creates an area chart.
-
Create and add values to the control.
-
Add the chart and specify the chart type 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