BinOption Property | Spread Windows Forms 13.0 Product Documentation

BinOption Property

In This Topic

Gets or sets the bin options for the histogram series.

Syntax

Visual Basic
C#

'Declaration
 
Public Property BinOption As BinOption

'Usage
 
Dim instance As HistogramSeries
Dim value As BinOption
 
instance.BinOption = value
 
value = instance.BinOption

public BinOption BinOption {get; set;}

Example

This example creates a histogram chart.

fpSpread1.ActiveSheet.Cells[0, 1].Value = 23;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 5;
fpSpread1.ActiveSheet.Cells[2, 1].Value = 79;
fpSpread1.ActiveSheet.Cells[3, 1].Value = 11;
fpSpread1.ActiveSheet.Cells[4, 1].Value = 23;
fpSpread1.ActiveSheet.Cells[5, 1].Value = 55;
fpSpread1.ActiveSheet.Cells[6, 1].Value = 88;
fpSpread1.ActiveSheet.Cells[7, 1].Value = 67;
fpSpread1.ActiveSheet.Cells[8, 1].Value = 42;
fpSpread1.ActiveSheet.Cells[9, 1].Value = 56;        
fpSpread1.ActiveSheet.AddChart(new FarPoint.Win.Spread.Model.CellRange(0, 1, 10, 1), typeof(FarPoint.Win.Chart.HistogramSeries), 400, 300, 150, 0);
(fpSpread1.ActiveSheet.Charts[0].Model.PlotAreas[0].Series[0] as HistogramSeries).BinOption.BinSize = 10;

Visual Basic

FpSpread1.ActiveSheet.Cells(0, 1).Value = 23
FpSpread1.ActiveSheet.Cells(1, 1).Value = 5
FpSpread1.ActiveSheet.Cells(2, 1).Value = 79
FpSpread1.ActiveSheet.Cells(3, 1).Value = 11
FpSpread1.ActiveSheet.Cells(4, 1).Value = 23
FpSpread1.ActiveSheet.Cells(5, 1).Value = 55
FpSpread1.ActiveSheet.Cells(6, 1).Value = 88
FpSpread1.ActiveSheet.Cells(7, 1).Value = 67
FpSpread1.ActiveSheet.Cells(8, 1).Value = 42
FpSpread1.ActiveSheet.Cells(9, 1).Value = 56
FpSpread1.ActiveSheet.AddChart(New FarPoint.Win.Spread.Model.CellRange(0, 1, 10, 1), GetType(FarPoint.Win.Chart.HistogramSeries), 400, 300, 150, 0)
TryCast(FpSpread1.ActiveSheet.Charts(0).Model.PlotAreas(0).Series(0), FarPoint.Win.Chart.HistogramSeries).BinOption.BinSize = 10

Reference

HistogramSeries Class
HistogramSeries Members

Product Support Forum | Print this page