HistogramSeriesOptions.OverflowValue Property
Returns or specifies a custom threshold value for the overflow bin.
Namespace: DevExpress.Spreadsheet.Charts
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
Type | Description |
---|---|
Double | The threshold value. |
Property Paths
You can access this nested property as listed below:
Object Type | Path to OverflowValue |
---|---|
SeriesLayoutOptions |
|
Remarks
Set the HistogramSeriesOptions.OverflowType property to Fixed and use the OverflowValue property to create the overflow bin for all points that are above the specified value.
The following example demonstrates how to create a histogram chart and display the overflow bin:
// Create a histogram chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.Histogram, worksheet["B2:B21"]);
chart.TopLeftCell = worksheet.Cells["D2"];
chart.BottomRightCell = worksheet.Cells["K18"];
// Specify histogram series options.
var options = chart.Series[0].LayoutOptions.Histogram;
options.BinType = HistogramBinType.BinWidth;
options.BinWidth = 20;
// Create the overflow bin
// for all values that are above 90.
options.OverflowType = HistogramOverflowType.Fixed;
options.OverflowValue = 90;
// Specify the gap width.
chart.Series[0].GapWidth = 10;
// Add the chart title.
chart.Title.Visible = true;
chart.Title.SetValue("Exam Score Distribution");
See Also