GrapeCity.Xaml.SpreadSheet.Data
SwitchRowColumn Method
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > SpreadChart Class : SwitchRowColumn Method
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.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.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

Reference

SpreadChart Class
SpreadChart Members