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.

1. Create and add values to the control.  
2. 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; gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 0, 0, 400, 300);

VB.NET

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 GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Area, "Sheet1!$A$1:$D$7", 0, 0, 400, 300)

Copyright © GrapeCity, inc. All rights reserved.