[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

Histogram Chart

Histogram charts are visual representation of data distribution over a continuous interval or a certain period. These charts consist of vertical bars that indicate the frequency in each interval or bin, created by dividing the raw data values into a series of consecutive and non-overlapping intervals. A histogram looks more similar to the bar charts, but there are no gaps between bars.

Sample Image

Description


ChartType.Histogram Represents a Histogram chart.

It is used to show the distribution of data grouped into bins.

Refer to the following example code to add a histogram chart.

C#

// Enable enhanced shape and chart engines.
fpSpread1.Features.EnhancedShapeEngine = true;
fpSpread1.Features.EnhancedChartEngine = true;
// Histogram chart.
object[,] dataArray = {
    { "John Mathew", 71, 74, 97, 85 },
    { "Jim Parker", 76, 58, 88, 84 },
    { "Sophia Ran", 97, 80, 74, 80 },
    { "Wendi Blake", 55, 97, 84, 60 },
    { "Stephan Lai", 81, 83, 94, 90 },
    { "Fay Van Damme", 71, 78, 72, 82 },
    { "Brevin Dice", 84, 80, 83, 93 },
    { "Regina Oleveria", 86, 76, 56, 92 },
    { "Georgi Facello", 78, 61, 91, 68 },
    { "Bezalel Simmel", 85, 58, 92, 68 },
    { "Sachin Tsukuda", 76, 70, 55, 81 },
    { "Patricia Breugel", 64, 77, 83, 85 },
    { "Zito Baaz", 82, 97, 66, 90 },
    { "Navin Argence", 59, 87, 83, 85 },
    { "Siamak Salverda", 77, 85, 97, 65 },
    { "Khaled Kohling", 87, 67, 77, 97 },
    { "Bangqing Kleiser", 49, 97, 78, 75 },
    { "Rimli Dusink", 25, 61, 91, 91 },
    { "Nathan Ranta", 65, 60, 96, 92 },
    { "Gila Lukaszewicz", 27, 91, 62, 93 },
    { "Kaijung Rodham", 31, 81, 67, 87 },
    { "Mohammed Pleszkun", 20, 98, 67, 82 },
    { "Shuichi Piazza", 67, 56, 81, 82 },
    { "Katsuo Leuchs", 83, 74, 51, 42 },
    { "Masanao Ducloy", 67, 64, 58, 73 },
    { "Mihalis Crabtree", 80, 91, 57, 84 },
    { "Danny Lenart", 92, 38, 99, 86 },
    { "Yongqiao Dalton", 85, 61, 73, 81 },
    { "Gaetan Veldwijk", 64, 52, 76, 72 },
    { "Leszek Pulkowski", 95, 75, 64, 99 },
    { "Weidon Gente", 77, 88, 77, 96 },
    { "Krister Stranks", 72, 38, 89, 55 },
    { "Ziyad Baaz", 89, 81, 83, 48 },
    { "Ymte Perelgut", 67, 70, 97, 94 },
    { "Tonia Butner", 99, 71, 87, 76 },
    { "Shigeaki Narlikar", 78, 80, 80, 97 },
    { "Ayakannu Beerel", 86, 61, 85, 81 },
    { "Moni Bale", 60, 72, 71, 86 },
    { "Manohar Heemskerk", 97, 60, 75, 78 },
    { "Angus Swan", 33, 97, 99, 99 },
    { "Christ Murtagh", 91, 76, 73, 80 },
    { "Hilary Rodiger", 75, 64, 84, 54 },
    { "Maren Baez", 45, 77, 86, 88 },
    { "Greger Jahnichen", 98, 89, 81, 63 },
    { "Ymte Duclos", 95, 83, 72, 72 },
    { "Chenyi Hainaut", 81, 97, 99, 87 },
    { "Kasidit Picel", 87, 80, 88, 80 },
    { "Elrique Walstra", 96, 54, 38, 54 },
    { "Adel Reghbati", 56, 88, 81, 88 }
};
for (int i = 0; i < dataArray.GetLength(0); i++)
{
    for (int j = 0; j < dataArray.GetLength(1); j++)
    {
        fpSpread1.AsWorkbook().ActiveSheet.Cells[i, j].Value = dataArray[i, j];
    }
}
fpSpread1.AsWorkbook().ActiveSheet.Cells["A1:E49"].Select();
fpSpread1.AsWorkbook().ActiveSheet.Shapes.AddChart(
    GrapeCity.Spreadsheet.Charts.ChartType.Histogram, 100, 150, 400, 300, true
);

VB

' Enable enhanced shape and chart engines.
fpSpread1.Features.EnhancedShapeEngine = True
fpSpread1.Features.EnhancedChartEngine = True
' Histogram chart.
Dim dataArray As Object(,) = {
    {"John Mathew", 71, 74, 97, 85},
    {"Jim Parker", 76, 58, 88, 84},
    {"Sophia Ran", 97, 80, 74, 80},
    {"Wendi Blake", 55, 97, 84, 60},
    {"Stephan Lai", 81, 83, 94, 90},
    {"Fay Van Damme", 71, 78, 72, 82},
    {"Brevin Dice", 84, 80, 83, 93},
    {"Regina Oleveria", 86, 76, 56, 92},
    {"Georgi Facello", 78, 61, 91, 68},
    {"Bezalel Simmel", 85, 58, 92, 68},
    {"Sachin Tsukuda", 76, 70, 55, 81},
    {"Patricia Breugel", 64, 77, 83, 85},
    {"Zito Baaz", 82, 97, 66, 90},
    {"Navin Argence", 59, 87, 83, 85},
    {"Siamak Salverda", 77, 85, 97, 65},
    {"Khaled Kohling", 87, 67, 77, 97},
    {"Bangqing Kleiser", 49, 97, 78, 75},
    {"Rimli Dusink", 25, 61, 91, 91},
    {"Nathan Ranta", 65, 60, 96, 92},
    {"Gila Lukaszewicz", 27, 91, 62, 93},
    {"Kaijung Rodham", 31, 81, 67, 87},
    {"Mohammed Pleszkun", 20, 98, 67, 82},
    {"Shuichi Piazza", 67, 56, 81, 82},
    {"Katsuo Leuchs", 83, 74, 51, 42},
    {"Masanao Ducloy", 67, 64, 58, 73},
    {"Mihalis Crabtree", 80, 91, 57, 84},
    {"Danny Lenart", 92, 38, 99, 86},
    {"Yongqiao Dalton", 85, 61, 73, 81},
    {"Gaetan Veldwijk", 64, 52, 76, 72},
    {"Leszek Pulkowski", 95, 75, 64, 99},
    {"Weidon Gente", 77, 88, 77, 96},
    {"Krister Stranks", 72, 38, 89, 55},
    {"Ziyad Baaz", 89, 81, 83, 48},
    {"Ymte Perelgut", 67, 70, 97, 94},
    {"Tonia Butner", 99, 71, 87, 76},
    {"Shigeaki Narlikar", 78, 80, 80, 97},
    {"Ayakannu Beerel", 86, 61, 85, 81},
    {"Moni Bale", 60, 72, 71, 86},
    {"Manohar Heemskerk", 97, 60, 75, 78},
    {"Angus Swan", 33, 97, 99, 99},
    {"Christ Murtagh", 91, 76, 73, 80},
    {"Hilary Rodiger", 75, 64, 84, 54},
    {"Maren Baez", 45, 77, 86, 88},
    {"Greger Jahnichen", 98, 89, 81, 63},
    {"Ymte Duclos", 95, 83, 72, 72},
    {"Chenyi Hainaut", 81, 97, 99, 87},
    {"Kasidit Picel", 87, 80, 88, 80},
    {"Elrique Walstra", 96, 54, 38, 54},
    {"Adel Reghbati", 56, 88, 81, 88}
}
For i As Integer = 0 To dataArray.GetLength(0) - 1
    For j As Integer = 0 To dataArray.GetLength(1) - 1
        fpSpread1.AsWorkbook().ActiveSheet.Cells(i, j).Value = dataArray(i, j)
    Next
Next
fpSpread1.AsWorkbook().ActiveSheet.Cells("A1:E49").Select()
fpSpread1.AsWorkbook().ActiveSheet.Shapes.AddChart(
    GrapeCity.Spreadsheet.Charts.ChartType.Histogram, 100, 150, 400, 300, True
)