Spread for ASP.NET 9.0 Product Documentation
ActiveChart Property
Example 


Gets or sets the active chart.
Syntax
'Declaration
 
Public Property ActiveChart As Object
'Usage
 
Dim instance As SheetView
Dim value As Object
 
instance.ActiveChart = value
 
value = instance.ActiveChart
public object ActiveChart {get; set;}
Example
This example adds a chart control and makes the chart active.
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;
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
Requirements

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

See Also

Reference

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.