GrapeCity.Documents.Excel.Drawing.IChartGroup.BinsType

BinsType Property

BinsType

Gets or sets how the horizontal axis of the histogram chart is formatted.

Use this property to read the current binning mode for a histogram chart group, such as automatic, bin count, bin size, or categorical binning.

Declaration

BinsType BinsType { get; set; }

Property BinsType As BinsType

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.BinsType = BinsType.BinsTypeBinCount;
BinsType binsType = chartGroup.BinsType;