Spread WPF Documentation
AxisType Enumeration
Example Example 


Specifies the axis type.
Syntax
'Declaration
 
Public Enum AxisType 
   Inherits System.Enum
'Usage
 
Dim instance As AxisType
public enum AxisType : System.Enum 
Members
MemberDescription
CategorySpecifies that the axis is a category axis
DateSpecifies that the axis is a date axis
ValueSpecifies that the axis is a value axis
Example
This example sets the AxisType enumeration.
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)
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.AxisType

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.