2D Clustered Column Chart

[barismar]

Hi everyone!

I want to ask about how to make a 2D Clustered Column Chart chart in Excelize, here are the details:

From this table:

I want to make a chart like this:

I have tried with this code:

   for idx, row := range [][]interface{}{
	{nil, "Apple"},
	{"Small", 0.20123},
	{"Normal", 0.52},
	{"Large", 0.633},
} {
	cell, err := excelize.CoordinatesToCellName(1, idx+1)
	if err != nil {
		return
	}
	if err := sw.SetRow(cell, row, excelize.RowOpts{
		StyleID: styleID,
	}); err != nil {
		break
	}
}

if err := f.AddChart("Sheet1", "H1", &excelize.Chart{
	Type: excelize.Col,
	Series: []excelize.ChartSeries{
		{
			Name:       "Sheet1!$B$1",
			Categories: "Sheet1!$A$2:$A$4",
			Values:     "Sheet1!$B$2:$B$4",
		},
	},
	Legend: excelize.ChartLegend{
		Position:      "bottom",
		ShowLegendKey: true,
	},
	Title: []excelize.RichTextRun{
		{
			Text: "Apple",
		},
	},
	YAxis: excelize.ChartAxis{
		NumFmt: excelize.ChartNumFmt{
			CustomNumFmt: "0%",
		},
	},
	Dimension: excelize.ChartDimension{
		Height: 260,
	},
}); err != nil {
	fmt.Println(err)
	return
}

But the code creates a chart like this:

can I create a chart like I want, using Excelize?

I have checked the Excel file directly by comparing the data used between the two tables and the results are the same, I am confused as to why the resulting output is different.

[barismar]

I have found the answer, I had to set the VaryColors to false