[]
        
(Showing Draft Content)

直方图

直方图是连续时间间隔或特定时间段内数据分布的直观表示。这些图表包括竖线,以指示每个间隔或通过将原始数据值划分为一系列连续和不重叠的间隔而创建的bin中的频率。因此,直方图有助于估计最大值下降的范围以及知道数据值的极端和差距(如果有)。例如,直方图可以帮助您找到特定年龄段的最大学生落入的身高范围。

用例代码

请参考以下代码以添加直方图。

private static void HistogramChart() {
    // Initialize workbook
    Workbook workbook = new Workbook();
    // Fetch default worksheet
    IWorksheet worksheet = workbook.getWorksheets().get(0);

    // Prepare data for chart
    worksheet.getRange("A1:B11")
            .setValue(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.getRange("A:B").getColumns().autoFit();
    // Add Histogram Chart
    IShape histogramchartShape = worksheet.getShapes().addChart(ChartType.Histogram, 300, 30, 300, 250);

    // Set range"A1:B11" as the histogram chart series
    histogramchartShape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B11"));

    // Sets bins type by category
    histogramchartShape.getChart().getChartGroups().get(0).setBinsType(BinsType.BinsTypeCategorical);

    // Configure Chart Title
    histogramchartShape.getChart().getChartTitle().setText("Histogram Chart");

    // Saving workbook to Xlsx
    workbook.save("29-HistogramChart.xlsx", SaveFileFormat.Xlsx);