三维簇状柱形图

例如，创建如下效果的三维簇状柱形图：

使用 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.     max, min := 7.5, 0.5
  33.     if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
  34.         Type: excelize.Col3DClustered,
  35.         Series: []excelize.ChartSeries{
  36.             {
  37.                 Name:       "Sheet1!$A$2",
  38.                 Categories: "Sheet1!$B$1:$D$1",
  39.                 Values:     "Sheet1!$B$2:$D$2",
  40.             },
  41.             {
  42.                 Name:       "Sheet1!$A$3",
  43.                 Categories: "Sheet1!$B$1:$D$1",
  44.                 Values:     "Sheet1!$B$3:$D$3",
  45.             },
  46.             {
  47.                 Name:       "Sheet1!$A$4",
  48.                 Categories: "Sheet1!$B$1:$D$1",
  49.                 Values:     "Sheet1!$B$4:$D$4",
  50.             },
  51.         },
  52.         Format: excelize.GraphicOptions{
  53.             OffsetX: 15,
  54.             OffsetY: 10,
  55.         },
  56.         Title: []excelize.RichTextRun{
  57.             {
  58.                 Text: "Fruit 3D Clustered Column Chart",
  59.             },
  60.         },
  61.         PlotArea: excelize.ChartPlotArea{
  62.             ShowCatName:     false,
  63.             ShowLeaderLines: false,
  64.             ShowPercent:     true,
  65.             ShowSerName:     true,
  66.             ShowVal:         true,
  67.         },
  68.         ShowBlanksAs: "zero",
  69.         XAxis: excelize.ChartAxis{
  70.             ReverseOrder: true,
  71.         },
  72.         YAxis: excelize.ChartAxis{
  73.             Maximum: &max,
  74.             Minimum: &min,
  75.         },
  76.     }); err != nil {
  77.         fmt.Println(err)
  78.         return
  79.     }
  80.     // 保存工作簿
  81.     if err := f.SaveAs("Book1.xlsx"); err != nil {
  82.         fmt.Println(err)
  83.     }
  84. }