Spread WPF Documentation
XValues Property
Example 


Gets or sets the X values.
Syntax
'Declaration
 
Public Property XValues As DoubleSeriesCollection
'Usage
 
Dim instance As SpreadXYDataSeries
Dim value As DoubleSeriesCollection
 
instance.XValues = value
 
value = instance.XValues
public DoubleSeriesCollection XValues {get; set;}

Property Value

The X values.
Example
This example sets the XValues property.
GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries open = new GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries();
open.XValues = new GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection();
open.XValues.Add(1);
open.XValues.Add(2);
open.XValues.Add(3);
open.XValues.Add(4);
open.XValues.Add(5);
open.HighSeries.Values.AddRange(new double[] { 5, 7, 6, 8, 7, 9 });
open.LowSeries.Values.AddRange(new double[] { 2, 4, 3, 5, 4, 6 });
open.CloseSeries.Values.AddRange(new Double[] { 4, 6, 5, 7, 6, 8 });
open.OpenSeries.Values.AddRange(new Double[] { 3, 8, 9, 10, 12, 6 });
GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart1 = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
chart1.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose;
chart1.DataSeries.Add(open);
chart1.Name = "Name";
this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart1);
Dim open As New GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries()
open.XValues = New GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection()
open.XValues.Add(1)
open.XValues.Add(2)
open.XValues.Add(3)
open.XValues.Add(4)
open.XValues.Add(5)
open.HighSeries.Values.AddRange(New Double() {5, 7, 6, 8, 7, 9})
open.LowSeries.Values.AddRange(New Double() {2, 4, 3, 5, 4, 6})
open.CloseSeries.Values.AddRange(New Double() {4, 6, 5, 7, 6, 8})
open.OpenSeries.Values.AddRange(New Double() {3, 8, 9, 10, 12, 6})

Dim chart1 As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart()
chart1.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose
chart1.DataSeries.Add(open)
chart1.Name = "Name"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart1)
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

SpreadXYDataSeries Class
SpreadXYDataSeries Members

 

 


Copyright © GrapeCity, inc. All rights reserved.