Spread WPF Documentation
SpreadChartType Enumeration
Example Example 


GrapeCity.Windows.SpreadSheet.Data Namespace : SpreadChartType Enumeration
Specifies the chart type.
Syntax
public enum SpreadChartType : System.Enum 
'Declaration
 
Public Enum SpreadChartType 
   Inherits System.Enum
 
'Usage
 
Dim instance As SpreadChartType
Members
MemberDescription
AreaSpecifies the area chart.
Area3DSpecifies the 3D area chart.
AreaStackedSpecifies the stacked area chart.
AreaStacked100pcSpecifies the 100% stacked area chart.
AreaStacked100pc3DSpecifies the 100% 3D stacked area chart.
AreaStacked3DSpecifies the 3D stacked area chart.
Bar3DSpecifies the 3D bar chart.
BarClusteredSpecifies the clustered bar chart.
BarStackedSpecifies the stacked bar chart.
BarStacked100pcSpecifies the 100% stacked bar chart.
BarStacked100pc3DSpecifies the 100% stacked 3D bar chart.
BarStacked3DSpecifies the stacked 3D bar chart.
BubbleSpecifies the bubble chart.
Column3DSpecifies the 3D column chart.
ColumnClusteredSpecifies the clustered column chart.
ColumnStackedSpecifies the stacked column chart.
ColumnStacked100pcSpecifies the 100% stacked column chart.
ColumnStacked100pc3DSpecifies the 100% stacked 3D column chart.
ColumnStacked3DSpecifies the stacked 3D column chart.
LineSpecifies the line chart.
Line3DSpecifies the 3D line chart.
LineSmoothedSpecifies the smooth line chart.
LineStackedSpecifies the stacked line chart.
LineStacked100pcSpecifies the 100% stacked line chart.
LineStacked100pcWithMarkersSpecifies the 100% stacked line chart with markers.
LineStackedWithMarkersSpecifies the stacked line chart with markers.
LineWithMarkersSpecifies the line chart with markers.
LineWithMarkersSmoothedSpecifies the smooth line chart with markers.
NoneSpecifies none.
PieSpecifies the pie chart.
Pie3DSpecifies the 3D pie chart.
PieDoughnutSpecifies the doughnut chart.
PieExplodedSpecifies the exploded pie chart.
PieExploded3DSpecifies the 3D exploded pie chart.
PieExplodedDoughnutSpecifies the exploded doughnut chart.
RadarSpecifies the radar chart.
RadarFilledSpecifies the filled radar chart.
RadarWithMarkersSpecifies the radar chart with markers.
ScatterSpecifies the scatter chart.
ScatterLinesSpecifies the line scatter chart.
ScatterLinesSmoothedSpecifies the smooth line scatter chart.
ScatterLinesSmoothedWithMarkersSpecifies the smooth line scatter chart with markers.
ScatterLinesWithMarkersSpecifies the line scatter chart with markers.
StockHighLowOpenCloseSpecifies the high low open close stock chart.
Example
This example creates a chart control. 
gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = "c1";
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = "c2";
gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = "c3";
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = "s1";
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = "s2";
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = "s3";
gcSpreadSheet1.Sheets[0].Cells[4, 0].Value = "s4";
gcSpreadSheet1.Sheets[0].Cells[5, 0].Value = "s5";
gcSpreadSheet1.Sheets[0].Cells[6, 0].Value = "s6";
gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[2, 1].Value = 2;
gcSpreadSheet1.Sheets[0].Cells[3, 1].Value = 3;
gcSpreadSheet1.Sheets[0].Cells[4, 1].Value = 4;
gcSpreadSheet1.Sheets[0].Cells[5, 1].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[6, 1].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = 7;
gcSpreadSheet1.Sheets[0].Cells[2, 2].Value = 8;
gcSpreadSheet1.Sheets[0].Cells[3, 2].Value = 9;
gcSpreadSheet1.Sheets[0].Cells[4, 2].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[5, 2].Value = 11;
gcSpreadSheet1.Sheets[0].Cells[6, 2].Value = 12;
gcSpreadSheet1.Sheets[0].Cells[1, 3].Value = 13;
gcSpreadSheet1.Sheets[0].Cells[2, 3].Value = 14;
gcSpreadSheet1.Sheets[0].Cells[3, 3].Value = 15;
gcSpreadSheet1.Sheets[0].Cells[4, 3].Value = 16;
gcSpreadSheet1.Sheets[0].Cells[5, 3].Value = 17;
gcSpreadSheet1.Sheets[0].Cells[6, 3].Value = 18;
gcSpreadSheet1.Sheets[0].AddChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble, "Sheet1!$A$1:$D$7", 0, 0, 400, 300);
GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = "c1"
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = "c2"
GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = "c3"
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = "s1"
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = "s2"
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = "s3"
GcSpreadSheet1.Sheets(0).Cells(4, 0).Value = "s4"
GcSpreadSheet1.Sheets(0).Cells(5, 0).Value = "s5"
GcSpreadSheet1.Sheets(0).Cells(6, 0).Value = "s6"
GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 1
GcSpreadSheet1.Sheets(0).Cells(2, 1).Value = 2
GcSpreadSheet1.Sheets(0).Cells(3, 1).Value = 3
GcSpreadSheet1.Sheets(0).Cells(4, 1).Value = 4
GcSpreadSheet1.Sheets(0).Cells(5, 1).Value = 5
GcSpreadSheet1.Sheets(0).Cells(6, 1).Value = 6
GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = 7
GcSpreadSheet1.Sheets(0).Cells(2, 2).Value = 8
GcSpreadSheet1.Sheets(0).Cells(3, 2).Value = 9
GcSpreadSheet1.Sheets(0).Cells(4, 2).Value = 10
GcSpreadSheet1.Sheets(0).Cells(5, 2).Value = 11
GcSpreadSheet1.Sheets(0).Cells(6, 2).Value = 12
GcSpreadSheet1.Sheets(0).Cells(1, 3).Value = 13
GcSpreadSheet1.Sheets(0).Cells(2, 3).Value = 14
GcSpreadSheet1.Sheets(0).Cells(3, 3).Value = 15
GcSpreadSheet1.Sheets(0).Cells(4, 3).Value = 16
GcSpreadSheet1.Sheets(0).Cells(5, 3).Value = 17
GcSpreadSheet1.Sheets(0).Cells(6, 3).Value = 18
GcSpreadSheet1.Sheets(0).AddChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble, "Sheet1!$A$1:$D$7", 0, 0, 400, 300)
Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace

 

 

Copyright © GrapeCity, inc. All rights reserved.