Spread Silverlight Documentation
DataSeries Property (SpreadChart)
Example 


Gets the collection of data series.
Syntax
'Declaration
 
Public ReadOnly Property DataSeries As DataSeriesCollection
'Usage
 
Dim instance As SpreadChart
Dim value As DataSeriesCollection
 
value = instance.DataSeries
public DataSeriesCollection DataSeries {get;}

Property Value

The collection of data series.
Example
This example sets the DataSeries 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, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

SpreadChart Class
SpreadChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.