Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Axis Class / AxisType Property
Example


In This Topic
    AxisType Property
    In This Topic
    Gets or sets the type of the axis.
    Syntax
    'Declaration
     
    Public Property AxisType As AxisType
    'Usage
     
    Dim instance As Axis
    Dim value As AxisType
     
    instance.AxisType = value
     
    value = instance.AxisType
    public AxisType AxisType {get; set;}

    Property Value

    The type of the axis.
    Example
    This example sets the AxisType property.
    GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries ds = new GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries();
    ds.StrokeThickness = 3;
    ds.XValues.AddRange(new double[] { 
    new DateTime(2008,10,1).ToOADate(), new DateTime(2008,10,2).ToOADate(), new DateTime(2008,10,3).ToOADate(),
    new DateTime(2008,10,6).ToOADate(), new DateTime(2008,10,7).ToOADate(), new DateTime(2008,10,8).ToOADate()
              });
    ds.OpenSeries.Values.AddRange(new double[] { 100, 102, 104, 100, 107, 102 });
    ds.CloseSeries.Values.AddRange(new double[] { 102, 104, 100, 107, 102, 100 });
    ds.HighSeries.Values.AddRange(new double[] { 102, 105, 105, 108, 109, 105 });
    ds.LowSeries.Values.AddRange(new double[] { 99, 95, 95, 100, 96, 99, 98 });
    GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
    chart.DataSeries.Add(ds);
    chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose;
    chart.Name = "name1";
    chart.AxisX.AxisType = GrapeCity.Windows.SpreadSheet.Data.AxisType.Date;
    chart.AxisX.BaseTimeUnit = GrapeCity.Windows.SpreadSheet.Data.AxisTimeUnit.Days;
    this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
    Dim ds As New GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries()
    ds.StrokeThickness = 3
    ds.XValues.AddRange(New Double() {
    New DateTime(2008, 10, 1).ToOADate(), New DateTime(2008, 10, 2).ToOADate(), New DateTime(2008, 10, 3).ToOADate(),
    New DateTime(2008, 10, 6).ToOADate(), New DateTime(2008, 10, 7).ToOADate(), New DateTime(2008, 10, 8).ToOADate()
          })
    ds.OpenSeries.Values.AddRange(New Double() {100, 102, 104, 100, 107, 102})
    ds.CloseSeries.Values.AddRange(New Double() {102, 104, 100, 107, 102, 100})
    ds.HighSeries.Values.AddRange(New Double() {102, 105, 105, 108, 109, 105})
    ds.LowSeries.Values.AddRange(New Double() {99, 95, 95, 100, 96, 99, 98})
    Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart()
    chart.DataSeries.Add(ds)
    chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose
    chart.Name = "name1"
    chart.AxisX.AxisType = GrapeCity.Windows.SpreadSheet.Data.AxisType.Date
    chart.AxisX.BaseTimeUnit = GrapeCity.Windows.SpreadSheet.Data.AxisTimeUnit.Days
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
    See Also