[]
旭日图, 也称为多级饼图,非常适合可视化由同心圆表示的多级分层数据。中心的圆圈表示被圆环包围的根节点,圆环代表不同层次的层次结构。环根据它们与父切片的关系进行划分,每个环被均分或与一个值成比例。这种类型的图表可帮助用户将数据分解为不同的实体,以便在不同的业务场景中快速有效地识别和可视化多级父子关系。
请参阅下面的代码来添加一个旭日图:
private static void SunburstChart() {
// Initialize workbook
Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.getWorksheets().get(0);
// Prepare data for chart
worksheet.getRange("A1:D16")
.setValue(new Object[][] {
{ "Region", "Subregion", "Country", "Population" },
{ "Asia", "Southern", "India", 1354051854 },
{ null, null, "Pakistan", 200813818 },
{ null, null, "Bangladesh", 166368149 },
{ null, null, "Others", 170220300 },
{ null, "Eastern", "China", 1415045928 },
{ null, null, "Japan", 127185332 },
{ null, null, "Others", 111652273 },
{ null, "South-Eastern", null, 655636576 },
{ null, "Western", null, 272298399 },
{ null, "Central", null, 71860465 },
{ "Africa", "Eastern", null, 433643132 },
{ null, "Western", null, 381980688 },
{ null, "Northern", null, 237784677 },
{ null, "Others", null, 234512021 },
{ "Europe", null, null, 742648010 },
{ "Others", null, null, 1057117703 } });
worksheet.getRange("A:D").getColumns().autoFit();
// Add Sunburst Chart
IShape sunburstChartShape = worksheet.getShapes().addChart(ChartType.Sunburst, 250, 20, 360, 330);
// Adding series to SeriesCollection
sunburstChartShape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D16"), RowCol.Columns, true,
true);
// Configure Chart Title
sunburstChartShape.getChart().getChartTitle().setText("World Population");
// Saving workbook to Xlsx
workbook.save("32-SunburstChart.xlsx", SaveFileFormat.Xlsx);