Charts Property

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Charts As SpreadChartCollection

'Usage
 
Dim instance As SheetView
Dim value As SpreadChartCollection
 
value = instance.Charts

public SpreadChartCollection Charts {get;}

Property Value

The charts.

This example adds a chart control.

C#

FarPoint.Web.Chart.BarSeries series1 = new FarPoint.Web.Chart.BarSeries();
series1.SeriesName = "Series 0";
series1.Values.Add(2.0);
series1.Values.Add(4.0);
series1.Values.Add(3.0);
series1.Values.Add(5.0);

FarPoint.Web.Chart.BarSeries series2 = new FarPoint.Web.Chart.BarSeries();
series2.SeriesName = "Series 1";
series2.Values.Add(2.0);
series2.Values.Add(4.0);
series2.Values.Add(3.0);
series2.Values.Add(5.0);

FarPoint.Web.Chart.ClusteredBarSeries series = new FarPoint.Web.Chart.ClusteredBarSeries();
series.Series.Add(series1);
series.Series.Add(series2);

FarPoint.Web.Chart.YPlotArea plotArea = new FarPoint.Web.Chart.YPlotArea();
plotArea.Location = new System.Drawing.PointF(0.2f, 0.2f);
plotArea.Size = new System.Drawing.SizeF(0.6f, 0.6f);
plotArea.Series.Add(series);
      
FarPoint.Web.Chart.ChartModel model = new FarPoint.Web.Chart.ChartModel();
model.PlotAreas.Add(plotArea);

FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart();
chart.Model = model;
FpSpread1.Sheets[0].Charts.Add(chart);
FpSpread1.Sheets[0].ActiveChart = chart;

Visual Basic

Dim series1 As New FarPoint.Web.Chart.BarSeries()
series1.SeriesName = "Series 0"
series1.Values.Add(2.0)
series1.Values.Add(4.0)
series1.Values.Add(3.0)
series1.Values.Add(5.0)

Dim series2 As New FarPoint.Web.Chart.BarSeries()
series2.SeriesName = "Series 1"
series2.Values.Add(2.0)
series2.Values.Add(4.0)
series2.Values.Add(3.0)
series2.Values.Add(5.0)

Dim series As New FarPoint.Web.Chart.ClusteredBarSeries()
series.Series.Add(series1)
series.Series.Add(series2)

Dim plotArea As New FarPoint.Web.Chart.YPlotArea()
plotArea.Location = New System.Drawing.PointF(0.2F, 0.2F)
plotArea.Size = New System.Drawing.SizeF(0.6F, 0.6F)
plotArea.Series.Add(series)

Dim model As New FarPoint.Web.Chart.ChartModel()
model.PlotAreas.Add(plotArea)

Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart()
chart.Model = model
FpSpread1.Sheets(0).Charts.Add(chart)
FpSpread1.Sheets(0).ActiveChart = chart

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members