Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

HistogramSeriesOptions.BinCount Property

Returns or specifies the number of bins in a histogram chart.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

int BinCount { get; set; }

#Property Value

Type Description
Int32

The number of histogram bins.

#Property Paths

You can access this nested property as listed below:

Object Type Path to BinCount
SeriesLayoutOptions
.Histogram .BinCount

#Remarks

Set the HistogramSeriesOptions.BinType option to HistogramBinType.BinCount and use the BinCount property to specify the number of bins in a histogram chart.

The example below creates a histogram with four bins.

A histogram with four bins

// 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.BinCount;
// Specify the number of bins.
options.BinCount = 4;
// 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