﻿ Histogram | Document Solutions for Excel, .NET Edition | Document Solutions
Document Solutions for Excel, .NET Edition | Document Solutions
Features / Chart / Chart Types / Statistical Chart / Histogram
In This Topic
Histogram
In This Topic

Histograms are visual representation of data distribution over a continuous interval or certain time period. These charts comprise vertical bars to indicate the frequency in each interval or bin created by dividing the raw data values into a series of consecutive and non-overlapping intervals. Hence, histograms help in estimating the range where maximum values fall as well as in knowing the extremes and gaps in data values, if there are any. For instance, histogram can help you find the range of height in which maximum students of a particular age group fall.

### Using Code

Refer to the following code to add a Histogram chart.

C#
Copy Code
```    public void HistogramChart()
{
// Initialize workbook
Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.Worksheets[0];

// Prepare data for chart
worksheet.Range["A1:B11"].Value = new object[,]
{
{"Complaint", "Count"},
{"Too noisy", 27},
{"Overpriced", 789},
{"Food is tasteless", 65},
{"Food is not fresh", 19},
{"Food is too salty", 15},
{"Not clean", 30},
{"Unfriendly staff", 12},
{"Wait time", 109},
{ "No atmosphere", 45},
{"Small portions", 621 }
};
worksheet.Range["A:B"].Columns.AutoFit();
// Add Histogram Chart
IShape histogramchartShape = worksheet.Shapes.AddChart(ChartType.Histogram, 300, 30, 300, 250);

// Set range"A1:B11" as the histogram chart series
histogramchartShape.Chart.SeriesCollection.Add(worksheet.Range["A1:B11"]);

// Sets bins type by category
histogramchartShape.Chart.ChartGroups[0].BinsType = BinsType.BinsTypeCategorical;

// Configure Chart Title
histogramchartShape.Chart.ChartTitle.Text = "Histogram Chart";

// Saving workbook to Xlsx
workbook.Save(@"29-HistogramChart.xlsx", SaveFileFormat.Xlsx);
}```