GrapeCity.Documents.Excel.Drawing.IChartGroup.BinsOverflowEnabled

BinsOverflowEnabled Property

BinsOverflowEnabled

Gets or sets whether a bin for values above the BinsOverflowValue property is enabled.

This property applies to histogram charts and indicates whether values greater than the overflow threshold are grouped into a separate overflow bin.

Declaration

bool BinsOverflowEnabled { get; set; }

Property BinsOverflowEnabled As Boolean

Examples

worksheet.Range["A1:A6"].Value = new object[,] {
    {"Score"},
    {10},
    {12},
    {15},
    {18},
    {22}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.Histogram, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:A6"]);
IChartGroup chartGroup = chart.ChartGroups[0];
chartGroup.BinsOverflowValue = 20;
bool overflowEnabled = chartGroup.BinsOverflowEnabled;