Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadChart Class / DataSeries Property
Example


In This Topic
    DataSeries Property (SpreadChart)
    In This Topic
    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)
    See Also