Combo Column + Line chart with secondary invisible axis produces unexpected results.

Description The following book contains two charts - Top one produced by the program below, Bottom one - the expected output.

Book1.xlsx

Things I had to adjust on the default combo chat generated by Excel to match my requirements:

Change chart type to combo - Clustered Column line on secondary axis
Change color for bar chart series to "1F77B4" and "FF7F0E"
Change line chart series color to "2CA02C"
Change number format for all series to '#""'
Change secondary Vertical Axis position to "none"
Add data labels to all series and unset "Show leader lines".
Change data label font color to white for bar chart
Change bar chart data label position to "Inside End"
Change line chart data label position to "Above"
Change Y axis Major grid line color to "868686"
Add a Linear trend line to "b" series.

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},
        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, None: true},
            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: Produced

Describe the results you expected:

Output of go version:

go version go1.22.3 darwin/arm64

Excelize version or commit ID:

v2.8.1

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

MacOS Sonoma 14.5, Microsoft® Excel for Mac Version 16.85 (24051214)

qax-os / excelize

Combo Column + Line chart with secondary invisible axis produces unexpected results. #1921