Spread Silverlight Documentation
Values Property
Example 


Gets or sets the data values collection.
Syntax
'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);
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

See Also

Reference

SpreadDataSeries Class
SpreadDataSeries Members

 

 


Copyright © GrapeCity, inc. All rights reserved.