All docs
V20.2
20.2
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

HistogramSeriesOptions.OverflowValue Property

Returns or specifies a custom threshold value for the overflow bin.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

Declaration

double OverflowValue { get; set; }
Property OverflowValue As Double

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
.Histogram.OverflowValue

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");

Add an overflow bin to a histogram chart

See Also