[]
直方图是连续时间间隔或特定时间段内数据分布的直观表示。这些图表包括竖线,以指示每个间隔或通过将原始数据值划分为一系列连续和不重叠的间隔而创建的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);