# GrapeCity.Documents.Excel.Drawing.IChartGroup.BinsType

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Documents_Excel_Drawing_IChartGroup_BinsType_" data-uid="GrapeCity.Documents.Excel.Drawing.IChartGroup.BinsType*">BinsType Property
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_Drawing_IChartGroup_BinsType_" data-uid="GrapeCity.Documents.Excel.Drawing.IChartGroup.BinsType*"></a>
<h4 id="GrapeCity_Documents_Excel_Drawing_IChartGroup_BinsType" data-uid="GrapeCity.Documents.Excel.Drawing.IChartGroup.BinsType">BinsType</h4>
<div class="markdown level1 summary"><p>Gets or sets how the horizontal axis of the histogram chart is formatted.</p>
<p>
Use this property to read the current binning mode for a histogram chart group,
such as automatic, bin count, bin size, or categorical binning.
</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">BinsType BinsType { get; set; }</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Property BinsType As BinsType</code></pre>
</div>
<h5 id="GrapeCity_Documents_Excel_Drawing_IChartGroup_BinsType_examples">Examples</h5>
<pre><code class="lang-csharp">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.BinsType = BinsType.BinsTypeBinCount;
BinsType binsType = chartGroup.BinsType;</code></pre>

</div>
