[]
        
立即试用
(Showing Draft Content)

旭日图

旭日图, 也称为多级饼图,非常适合可视化由同心圆表示的多级分层数据。中心的圆圈表示被圆环包围的根节点,圆环代表不同层次的层次结构。环根据它们与父切片的关系进行划分,每个环被均分或与一个值成比例。这种类型的图表可帮助用户将数据分解为不同的实体,以便在不同的业务场景中快速有效地识别和可视化多级父子关系。


用例代码

请参阅下面的代码来添加一个旭日图:

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);