Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / Axis Class / AutoMin Property
Example


In This Topic
    AutoMin Property
    In This Topic
    Gets or sets whether the minimum value for the axis is set automatically.
    Syntax
    'Declaration
     
    Public Property AutoMin As Boolean
    'Usage
     
    Dim instance As Axis
    Dim value As Boolean
     
    instance.AutoMin = value
     
    value = instance.AutoMin
    public bool AutoMin {get; set;}
    Example
    This example sets the AutoMin property.
    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, 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.Windows.SpreadSheet.Data.GeneralFormatter("mm/dd/yyyy");
    chart.AxisX.LabelAngle = 30;
    chart.AxisX.AutoBaseTimeUnit = true;
    gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
    Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.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.Windows.SpreadSheet.Data.GeneralFormatter("mm/dd/yyyy")
    chart.AxisX.LabelAngle = 30
    chart.AxisX.AutoBaseTimeUnit = True
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
    See Also