GrapeCity.Xaml.SpreadSheet.Data
MajorUnit Property (Axis)
Example 


Gets or sets the major unit (distance between labels).
Syntax
'Declaration
 
Public Property MajorUnit As Double
'Usage
 
Dim instance As Axis
Dim value As Double
 
instance.MajorUnit = value
 
value = instance.MajorUnit
public double MajorUnit {get; set;}
Remarks
For time axis the distance is measured in days. E.g. 6 hours = 0.25 (days).
Example
This example sets the MajorUnit 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

Axis Class
Axis Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options