DataSeries Property (SpreadChart)

In This Topic

Gets the collection of data series.

Syntax

Visual Basic
C#

'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);

VB.NET

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)

Reference

SpreadChart Class
SpreadChart Members

Product Support Forum | Print this page