GrapeCity.Xaml.SpreadSheet.Data
SpreadChartType Enumeration
Example Example 


Specifies the chart type.
Syntax
'Declaration
 
Public Enum SpreadChartType 
   Inherits System.Enum
'Usage
 
Dim instance As SpreadChartType
public enum SpreadChartType : System.Enum 
Members
MemberDescription
Area Specifies the area chart.
AreaStacked Specifies the stacked area chart.
AreaStacked100pc Specifies the 100% stacked area chart.
BarClustered Specifies the clustered bar chart.
BarStacked Specifies the stacked bar chart.
BarStacked100pc Specifies the 100% stacked bar chart.
Bubble Specifies the bubble chart.
ColumnClustered Specifies the clustered column chart.
ColumnStacked Specifies the stacked column chart.
ColumnStacked100pc Specifies the 100% stacked column chart.
Line Specifies the line chart.
LineSmoothed Specifies the smooth line chart.
LineStacked Specifies the stacked line chart.
LineStacked100pc Specifies the 100% stacked line chart.
LineStacked100pcWithMarkers Specifies the 100% stacked line chart with markers.
LineStackedWithMarkers Specifies the stacked line chart with markers.
LineWithMarkers Specifies the line chart with markers.
LineWithMarkersSmoothed Specifies the smooth line chart with markers.
None Specifies none.
Pie Specifies the pie chart.
PieDoughnut Specifies the doughnut chart.
PieExploded Specifies the exploded pie chart.
PieExplodedDoughnut Specifies the exploded doughnut chart.
Radar Specifies the radar chart.
RadarFilled Specifies the filled radar chart.
RadarWithMarkers Specifies the radar chart with markers.
Scatter Specifies the scatter chart.
ScatterLines Specifies the line scatter chart.
ScatterLinesSmoothed Specifies the smooth line scatter chart.
ScatterLinesSmoothedWithMarkers Specifies the smooth line scatter chart with markers.
ScatterLinesWithMarkers Specifies the line scatter chart with markers.
StockHighLowOpenClose Specifies the high low open close stock chart.
Example
This example uses the SpreadChartType enumeration.
GrapeCity.Xaml.SpreadSheet.Data.SpreadBubbleSeries series0 = new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.SpreadBubbleSeries series1 = new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.ChartTitle label = new GrapeCity.Xaml.SpreadSheet.Data.ChartTitle();
label.Text = "XYZ Point Chart";
label.FontSize = 10;
label.FontFamily = new FontFamily("Tahoma");
GrapeCity.Xaml.SpreadSheet.Data.Legend l = new GrapeCity.Xaml.SpreadSheet.Data.Legend();
l.Alignment = GrapeCity.Xaml.SpreadSheet.Data.LegendAlignment.TopLeft;
GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart();
chart.ChartTitle = label;
chart.Legend = l;
chart.DataSeries.Add(series0);
chart.DataSeries.Add(series1);
chart.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Bubble;
chart.Name = "name1";
this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
Dim series0 As New GrapeCity.Xaml.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.Xaml.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.Xaml.SpreadSheet.Data.ChartTitle()
label.Text = "XYZ Point Chart"
label.FontSize = 10
label.FontFamily = New FontFamily("Tahoma")
Dim l As New GrapeCity.Xaml.SpreadSheet.Data.Legend()
l.Alignment = GrapeCity.Xaml.SpreadSheet.Data.LegendAlignment.TopLeft
Dim chart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart()
chart.ChartTitle = label
chart.Legend = l
chart.DataSeries.Add(series0)
chart.DataSeries.Add(series1)
chart.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Bubble
chart.Name = "name1"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType

Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options