Secondary axis title is not displayed.

[vsemichev]

Description

I am trying to generate a combo chart with a secondary Y axis, however, the secondary Y axis is missing the title.

Steps to reproduce the issue:

Run the following code

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)
        }
    }()
    data := [][]interface{}{
        {"MonYear", "Aug-23", "Sep-23", "Oct-23", "Nov-23", "Dec-23", "Jan-24", "Feb-24", "Mar-24", "Apr-24", "May-24", "Jun-24"},
        {"a", 14, 14, 14, 12, 14, 14, 13, 13, 12, 13, 4},
        {"b", 3, 2, 4, 3, 2, 3, 2, 3, 2, 1, 0},
        {"c", 44198, 44366, 44683, 44857, 44762, 44949, 45005, 45157, 45483, 45574, 45435},
    }
    for idx, col := range data {
        cell, err := excelize.CoordinatesToCellName(idx+1, 1)
        if err != nil {
            fmt.Println(err)
            return
        }
        f.SetSheetCol("Sheet1", cell, &col)
    }
    disable := false
    if err := f.AddChart("Sheet1", "F1", &excelize.Chart{
        Type:       excelize.Col,
        Dimension:  excelize.ChartDimension{Width: 1080, Height: 576},
        XAxis:      excelize.ChartAxis{Font: excelize.Font{Color: "000000"}},
        YAxis:      excelize.ChartAxis{Font: excelize.Font{Color: "000000"}, MajorGridLines: true, Title: []excelize.RichTextRun{{Text: "Primary Axis"}}},
        VaryColors: &disable,
        PlotArea:   excelize.ChartPlotArea{ShowVal: true, NumFmt: excelize.ChartNumFmt{CustomNumFmt: "#\"\""}},
        Series: []excelize.ChartSeries{
            {
                Name:              "Sheet1!$B$1",
                Categories:        "Sheet1!$A$2:$A$12",
                Values:            "Sheet1!$B$2:$B$12",
                Fill:              excelize.Fill{Type: "pattern", Color: []string{"1F77B4"}, Pattern: 1},
                DataLabelPosition: excelize.ChartDataLabelsPositionInsideEnd,
            },
            {
                Name:              "Sheet1!$C$1",
                Categories:        "Sheet1!$A$2:$A$12",
                Values:            "Sheet1!$C$2:$C$12",
                Fill:              excelize.Fill{Type: "pattern", Color: []string{"FF7F0E"}, Pattern: 1},
                DataLabelPosition: excelize.ChartDataLabelsPositionInsideEnd,
            },
        },
        Title: []excelize.RichTextRun{
            {
                Text: "Combo column and line chart",
            },
        },
    },
        &excelize.Chart{
            Type:       excelize.Line,
            Dimension:  excelize.ChartDimension{Width: 1080, Height: 576},
            YAxis:      excelize.ChartAxis{Secondary: true, Font: excelize.Font{Color: "000000"}, Title: []excelize.RichTextRun{{Font: &excelize.Font{Color: "000000"}, Text: "Secondary Axis"}}},
            VaryColors: &disable,
            PlotArea:   excelize.ChartPlotArea{ShowVal: true, NumFmt: excelize.ChartNumFmt{CustomNumFmt: "#\"\""}},
            Series: []excelize.ChartSeries{
                {
                    Name:              "Sheet1!$D$1",
                    Categories:        "Sheet1!$A$2:$A$12",
                    Values:            "Sheet1!$D$2:$D$12",
                    Fill:              excelize.Fill{Type: "pattern", Color: []string{"2CA02C"}, Pattern: 1},
                    DataLabelPosition: excelize.ChartDataLabelsPositionAbove,
                    Marker:            excelize.ChartMarker{Symbol: "none"},
                },
            },
        }); err != nil {
        fmt.Println(err)
        return
    }
    // Save spreadsheet by the given path.
    if err := f.SaveAs("Book1.xlsx"); err != nil {
        fmt.Println(err)
    }
}

Describe the results you received:

Combo bar + line chart. Primary Y-axis has the title, but the secondary Y-axis does not.

Describe the results you expected:

I expect the secondary Y-axis to have a title that I provided.

Output of go version:

go version go1.22.4 darwin/arm64

Excelize version or commit ID:

v2.8.2-0.20240617135415-1a99dd4a233c

Environment details (OS, Microsoft Excel™ version, physical, etc.):

MacOS Sonoma 14.5, Microsoft Excel for Mac Version 16.86 (24060916)

[xuri]

Thanks for your issue. It seems we need remove this line of code in the drawing.go, would you like to create a pull request for help us fix that?

[vsemichev]

Hi @xuri, per your instruction I have just submitted a new pull request. Thank you for a quick response!