Spread WPF 17
Spread WPF Documentation / Developer's Guide / Working with Charts / Creating Charts / Creating Chart Types / Adding an Area Chart
In This Topic
    Adding an Area Chart
    In This Topic

    You can create different types of area charts such as Area, Area3D, AreaStacked, AreaStacked3D, AreaStacked100pc3D, and AreaStacked100pc. The following image displays an area chart.

    An example of 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)
    See Also
    ChartType Property