Values Property

Gets or sets the data values collection.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Values As DoubleSeriesCollection

'Usage
 
Dim instance As SpreadDataSeries
Dim value As DoubleSeriesCollection
 
instance.Values = value
 
value = instance.Values

public DoubleSeriesCollection Values {get; set;}

Property Value

The data values collection.

Example

This example sets the Values property.

GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries series0 = new GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries();
series0.Name = "Series 0";
series0.XValues.Add(1.0);
series0.XValues.Add(2.0);
series0.XValues.Add(4.0);
series0.XValues.Add(8.0);
series0.Values.Add(2.0);
series0.Values.Add(4.0);
series0.Values.Add(3.0);
series0.Values.Add(5.0);
series0.SizeValues.Add(1.0);
series0.SizeValues.Add(2.0);
series0.SizeValues.Add(1.0);
series0.SizeValues.Add(2.0);
GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries series1 = new GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries();
series1.Name = "Series 1";
series1.XValues.Add(1.0);
series1.XValues.Add(3.0);
series1.XValues.Add(5.0);
series1.XValues.Add(8.0);
series1.Values.Add(1.0);
series1.Values.Add(2.0);
series1.Values.Add(4.0);
series1.Values.Add(8.0);
series1.SizeValues.Add(4.0);
series1.SizeValues.Add(3.0);
series1.SizeValues.Add(4.0);
series1.SizeValues.Add(3.0);

GrapeCity.Windows.SpreadSheet.Data.ChartTitle label = new GrapeCity.Windows.SpreadSheet.Data.ChartTitle();
label.Text = "XYZ Point Chart";
label.FontSize = 10;
label.FontFamily = new FontFamily("Tahoma");
GrapeCity.Windows.SpreadSheet.Data.Legend l = new GrapeCity.Windows.SpreadSheet.Data.Legend();
l.Alignment = GrapeCity.Windows.SpreadSheet.Data.LegendAlignment.TopLeft;
GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
chart.ChartTitle = label;
chart.Legend = l;
chart.DataSeries.Add(series0);
chart.DataSeries.Add(series1);
chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble;
chart.Name = "name1";
this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart);

VB.NET

Dim series0 As New GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries()
series0.Name = "Series 0"
series0.XValues.Add(1.0)
series0.XValues.Add(2.0)
series0.XValues.Add(4.0)
series0.XValues.Add(8.0)
series0.Values.Add(2.0)
series0.Values.Add(4.0)
series0.Values.Add(3.0)
series0.Values.Add(5.0)
series0.SizeValues.Add(1.0)
series0.SizeValues.Add(2.0)
series0.SizeValues.Add(1.0)
series0.SizeValues.Add(2.0)
Dim series1 As New GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries()
series1.Name = "Series 1"
series1.XValues.Add(1.0)
series1.XValues.Add(3.0)
series1.XValues.Add(5.0)
series1.XValues.Add(8.0)
series1.Values.Add(1.0)
series1.Values.Add(2.0)
series1.Values.Add(4.0)
series1.Values.Add(8.0)
series1.SizeValues.Add(4.0)
series1.SizeValues.Add(3.0)
series1.SizeValues.Add(4.0)
series1.SizeValues.Add(3.0)

Dim label As New GrapeCity.Windows.SpreadSheet.Data.ChartTitle()
label.Text = "XYZ Point Chart"
label.FontSize = 10
label.FontFamily = New FontFamily("Tahoma")
Dim l As New GrapeCity.Windows.SpreadSheet.Data.Legend()
l.Alignment = GrapeCity.Windows.SpreadSheet.Data.LegendAlignment.TopLeft
Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart()
chart.ChartTitle = label
chart.Legend = l
chart.DataSeries.Add(series0)
chart.DataSeries.Add(series1)
chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble
chart.Name = "name1"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)

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

Reference

SpreadDataSeries Class
SpreadDataSeries Members