二维堆积面积图

例如，创建如下效果的二维堆积面积图：

使用 Go 语言在 Excel 文档中创建二维堆积面积图

  1. package main
  3. import (
  4.     "fmt"
  6.     "github.com/xuri/excelize/v2"
  7. )
  9. func main() {
  10.     f := excelize.NewFile()
  11.     defer func() {
  12.         if err := f.Close(); err != nil {
  13.             fmt.Println(err)
  14.         }
  15.     }()
  16.     for idx, row := range [][]interface{}{
  17.         {nil, "Apple", "Orange", "Pear"},
  18.         {"Small", 2, 3, 3},
  19.         {"Normal", 5, 2, 4},
  20.         {"Large", 6, 7, 8},
  21.     } {
  22.         cell, err := excelize.CoordinatesToCellName(1, idx+1)
  23.         if err != nil {
  24.             fmt.Println(err)
  25.             return
  26.         }
  27.         if err := f.SetSheetRow("Sheet1", cell, &row); err != nil {
  28.             fmt.Println(err)
  29.             return
  30.         }
  31.     }
  32.     if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
  33.         Type: excelize.AreaStacked,
  34.         Series: []excelize.ChartSeries{
  35.             {
  36.                 Name:       "Sheet1!$A$2",
  37.                 Categories: "Sheet1!$B$1:$D$1",
  38.                 Values:     "Sheet1!$B$2:$D$2",
  39.             },
  40.             {
  41.                 Name:       "Sheet1!$A$3",
  42.                 Categories: "Sheet1!$B$1:$D$1",
  43.                 Values:     "Sheet1!$B$3:$D$3",
  44.             },
  45.             {
  46.                 Name:       "Sheet1!$A$4",
  47.                 Categories: "Sheet1!$B$1:$D$1",
  48.                 Values:     "Sheet1!$B$4:$D$4",
  49.             },
  50.         },
  51.         Format: excelize.GraphicOptions{
  52.             OffsetX: 15,
  53.             OffsetY: 10,
  54.         },
  55.         Title: []excelize.RichTextRun{
  56.             {
  57.                 Text: "Fruit 2D Stacked Area Chart",
  58.             },
  59.         },
  60.         PlotArea: excelize.ChartPlotArea{
  61.             ShowCatName:     false,
  62.             ShowLeaderLines: false,
  63.             ShowPercent:     true,
  64.             ShowSerName:     true,
  65.             ShowVal:         true,
  66.         },
  67.         ShowBlanksAs: "zero",
  68.     }); err != nil {
  69.         fmt.Println(err)
  70.         return
  71.     }
  72.     // 保存工作簿
  73.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  74.         fmt.Println(err)
  75.     }
  76. }