MESCIUS SPREAD for Windows Forms 17.0J
BinOption プロパティ

ヒストグラム系列のビンオプションを取得または設定します。
構文
'Declaration
 
Public Property BinOption As BinOption
public BinOption BinOption {get; set;}
次のサンプルコードは、ヒストグラム図を作成します。
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;
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
参照

HistogramSeries クラス
HistogramSeries メンバ

 

 


© MESCIUS inc. All rights reserved.