Set charts background and add text wrap to box shapes

[LaneDoesData]

I believe that you can edit the xml files associated with the Excel file (this is not a stable solution) but is it possible to add a feature to

1. set the background color of charts (to transparent or another color)
2. add text wrapping to box shapes

[xuri]

Thanks for your issue.

1. We have added a new field Fill in Chart, ChartPlotArea, and ChartMarker struct, for support set solid color or transparent fill for chart area, plot area, and maker. Please try to upgrade the master branch code, and this feature will be released in the next version.
2. This library already support add text wrap to box shapes.

For example:

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)
        }
    }()
    for idx, row := range [][]interface{}{
        {nil, "Apple", "Orange", "Pear"}, {"Small", 2, 3, 3},
        {"Normal", 5, 2, 4}, {"Large", 6, 7, 8},
    } {
        cell, err := excelize.CoordinatesToCellName(1, idx+1)
        if err != nil {
            fmt.Println(err)
            return
        }
        f.SetSheetRow("Sheet1", cell, &row)
    }
    if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
        Type: excelize.Line,
        Series: []excelize.ChartSeries{
            {
                Name:       "Sheet1!$A$2",
                Categories: "Sheet1!$B$1:$D$1",
                Values:     "Sheet1!$B$2:$D$2",
            },
            {
                Name:       "Sheet1!$A$3",
                Categories: "Sheet1!$B$1:$D$1",
                Values:     "Sheet1!$B$3:$D$3",
            },
            {
                Name:       "Sheet1!$A$4",
                Categories: "Sheet1!$B$1:$D$1",
                Values:     "Sheet1!$B$4:$D$4",
                Marker: excelize.ChartMarker{
                    // Specify solid fill for chart marker by Fill field
                    Fill: excelize.Fill{Type: "pattern", Color: []string{"777777"}, Pattern: 1},
                },
            }},
        Title: []excelize.RichTextRun{
            {
                Text: "Line Chart",
            },
        },
        // Specify transparent fill for chart area by Fill field,
        // declare Type and Pattern, but without Color
        Fill: excelize.Fill{Type: "pattern", Pattern: 1},
        PlotArea: excelize.ChartPlotArea{
            // Specify transparent fill for chart plot area by Fill field,
            // declare Type and Pattern, but without Color
            Fill: excelize.Fill{Type: "pattern", Pattern: 1},
        },
    }); err != nil {
        fmt.Println(err)
        return
    }

    // Add a rectangle shape with gray fill color and rich-text
    if err := f.AddShape("Sheet1", &excelize.Shape{
        Cell: "B7",
        Type: "rect",
        Paragraph: []excelize.RichTextRun{
            {Text: "Rectangle", Font: &excelize.Font{Color: "CD5C5C"}},
            {Text: "Shape", Font: &excelize.Font{Bold: true, Color: "2980B9"}},
        },
        Fill:   excelize.Fill{Type: "pattern", Color: []string{"DDDDDD"}, Pattern: 1},
        Height: 50,
        Width:  80,
    }); err != nil {
        fmt.Println(err)
        return
    }

    // Save spreadsheet by the given path.
    if err := f.SaveAs("Book1.xlsx"); err != nil {
        fmt.Println(err)
    }
}