GrapeCity.Xaml.SpreadSheet.Data
AxisY Property (SpreadChart)
Example 


Gets or sets the y-axis.
Syntax
'Declaration
 
Public Property AxisY As Axis
'Usage
 
Dim instance As SpreadChart
Dim value As Axis
 
instance.AxisY = value
 
value = instance.AxisY
public Axis AxisY {get; set;}

Property Value

The y-axis of the chart.
Example
This example uses the AxisY property.
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, 200, 200);
gcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } });

chart.AxisY.DisplayUnit = 100;
chart.AxisX.Min = 2;
chart.AxisX.Max = 5;
chart.AxisX.AutoMin = true;
chart.AxisX.AutoMax = true;
chart.AxisX.MinorUnit = 2;
chart.AxisX.MajorUnit = 3;
chart.AxisX.LabelFormatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("mm/dd/yyyy");
chart.AxisX.LabelAngle = 30;
chart.AxisX.AutoBaseTimeUnit = true;
gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
Dim chart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 200, 200)
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}})

chart.AxisY.DisplayUnit = 100
chart.AxisX.Min = 2
chart.AxisX.Max = 5
chart.AxisX.AutoMin = True
chart.AxisX.AutoMax = True
chart.AxisX.MinorUnit = 2
chart.AxisX.MajorUnit = 3
chart.AxisX.LabelFormatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("mm/dd/yyyy")
chart.AxisX.LabelAngle = 30
chart.AxisX.AutoBaseTimeUnit = True
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SpreadChart Class
SpreadChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options