Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadChart Class / SwitchRowColumn Method
Example


In This Topic
    SwitchRowColumn Method (SpreadChart)
    In This Topic
    Switches the row and column of the chart.
    Syntax
    'Declaration
     
    Public Function SwitchRowColumn() As Boolean
    'Usage
     
    Dim instance As SpreadChart
    Dim value As Boolean
     
    value = instance.SwitchRowColumn()
    public bool SwitchRowColumn()

    Return Value

    If the switching process is successful, returns true; otherwise, returns false.
    Example
    This example uses the SwitchRowColumn method.
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } });
    GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 300, 300);
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart);
    if (chart.CanSwitchRowColumn)
     chart.SwitchRowColumn();
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}})
    Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 300, 300)
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
    If (chart.CanSwitchRowColumn) Then
    chart.SwitchRowColumn()
    End If
    See Also