Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadChart Class / ChartType Property
Example


In This Topic
    ChartType Property (SpreadChart)
    In This Topic
    Gets or sets the type of the chart.
    Syntax
    'Declaration
     
    Public Property ChartType As SpreadChartType
    'Usage
     
    Dim instance As SpreadChart
    Dim value As SpreadChartType
     
    instance.ChartType = value
     
    value = instance.ChartType
    public SpreadChartType ChartType {get; set;}

    Property Value

    The type of the chart.
    Example
    This example creates a chart control.
    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.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
    chart.DataFormula = "Sheet1!$A$1:$D$7";
    chart.Name = "Chart1";
    chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Area;
    gcSpreadSheet1.Sheets[0].Charts.Add(chart);
    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.Windows.SpreadSheet.Data.SpreadChart()
    chart.DataFormula = "Sheet1!$A$1:$D$7"
    chart.Name = "Chart1"
    chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Area
    GcSpreadSheet1.Sheets(0).Charts.Add(chart)
    See Also