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


In This Topic
    AutoMax Property
    In This Topic
    Gets or sets whether the maximum value for the axis is set automatically.
    Syntax
    'Declaration
     
    Public Property AutoMax As Boolean
    'Usage
     
    Dim instance As Axis
    Dim value As Boolean
     
    instance.AutoMax = value
     
    value = instance.AutoMax
    public bool AutoMax {get; set;}
    Example
    This example sets the AutoMax 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