Gráfico de rosquillas
Por ejemplo, agregue un Gráfico de rosquillas como este:
package main
import (
"fmt"
"github.com/xuri/excelize/v2"
)
func main() {
f := excelize.NewFile()
defer func() {
if err := f.Close(); err != nil {
fmt.Println(err)
}
}()
if err := f.SetSheetName("Sheet1", "Hoja1"); err != nil {
fmt.Println(err)
return
}
for idx, row := range [][]interface{}{
{"Manzana", "Naranja", "Pera"},
{2, 3, 3},
} {
cell, err := excelize.CoordinatesToCellName(1, idx+1)
if err != nil {
fmt.Println(err)
return
}
if err := f.SetSheetRow("Hoja1", cell, &row); err != nil {
fmt.Println(err)
return
}
}
if err := f.AddChart("Hoja1", "E1", &excelize.Chart{
Type: excelize.Doughnut,
Series: []excelize.ChartSeries{
{
Name: "Monto",
Categories: "Hoja1!$A$1:$C$1",
Values: "Hoja1!$A$2:$C$2",
},
},
Format: excelize.GraphicOptions{
OffsetX: 15,
OffsetY: 10,
},
Legend: excelize.ChartLegend{
Position: "right",
},
Title: []excelize.RichTextRun{
{
Text: "Gráfico de rosquillas",
},
},
PlotArea: excelize.ChartPlotArea{
ShowCatName: false,
ShowLeaderLines: false,
ShowPercent: true,
ShowSerName: false,
ShowVal: false,
},
ShowBlanksAs: "zero",
}); err != nil {
fmt.Println(err)
return
}
// Guarde la hoja de cálculo por la ruta dada.
if err := f.SaveAs("Libro1.xlsx"); err != nil {
fmt.Println(err)
}
}