GrapeCity.Documents.Excel.Drawing.BinsType

BinsType Enum

Specifies how the horizontal axis of a histogram chart is formatted.

Use this enumeration with BinsType to control whether histogram bins are determined automatically, by category, manually, by bin size, or by bin count.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public enum BinsType

Public Enum BinsType

Examples

worksheet.Range["A1:A6"].Value = new object[] {1, 2, 2, 3, 4, 5};
IShape shape = worksheet.Shapes.AddChart(ChartType.Histogram, 20, 20, 360, 220);
IChart chart = shape.Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:A6"]);
chart.ChartGroups[0].BinsType = BinsType.BinsTypeBinSize;

Fields

Name	Description
BinsTypeAutomatic	Specifies bins type automatically.
BinsTypeBinCount	Specifies bins type by count.
BinsTypeBinSize	Specifies bins type by size.
BinsTypeCategorical	Specifies bins type by category.
BinsTypeManual	Specifies that histogram bins are set manually.